PgBouncer: erinevus redaktsioonide vahel
Allikas: Kuutõrvaja
Mine navigeerimisribaleMine otsikasti
Uus lehekülg: '===Sissejuhatus=== PgBouncer https://developer.skype.com/SkypeGarage/DbProjects/PgBouncer ... ===Tarkvara paigaldamine=== TODO ===Tarkvara seadistamine=== TODO ===Tarkvara kas…' |
Resümee puudub |
||
| 5. rida: | 5. rida: | ||
===Tarkvara paigaldamine=== | ===Tarkvara paigaldamine=== | ||
Tarkvara paigaldamiseks Debian Squeeze keskkonnas sobib öelda | |||
# apt-get install pgbouncer | |||
Paigaldatakse muu seas sellised failid | |||
/usr/sbin/pgbouncer | |||
/etc/default/pgbouncer | |||
/etc/pgbouncer/pgbouncer.ini | |||
/etc/pgbouncer/userlist.txt | |||
/etc/init.d/pgbouncer | |||
===Tarkvara seadistamine=== | ===Tarkvara seadistamine=== | ||
Tarvara tööd kontrollivad seadistusfailid | |||
* /etc/pgbouncer/pgbouncer.ini, mille sisu võiks olla nt | |||
# egrep -v "^$|^;" /etc/pgbouncer/pgbouncer.ini | |||
[databases] | |||
test = host=127.0.0.1 dbname=test | |||
[pgbouncer] | |||
logfile = /var/log/postgresql/pgbouncer.log | |||
pidfile = /var/run/postgresql/pgbouncer.pid | |||
listen_addr = * | |||
listen_port = 6432 | |||
unix_socket_dir = /var/run/postgresql | |||
auth_type = trust | |||
auth_file = /etc/pgbouncer/userlist.txt | |||
admin_users = postgres | |||
stats_users = postgres | |||
pool_mode = session | |||
server_reset_query = | |||
server_check_query = select 1 | |||
server_check_delay = 10 | |||
max_client_conn = 100 | |||
default_pool_size = 20 | |||
log_connections = 1 | |||
log_disconnections = 1 | |||
log_pooler_errors = 1 | |||
* /etc/pgbouncer/userlist.txt | |||
===Tarkvara kasutamine=== | ===Tarkvara kasutamine=== | ||
Redaktsioon: 13. aprill 2010, kell 11:25
Sissejuhatus
PgBouncer https://developer.skype.com/SkypeGarage/DbProjects/PgBouncer ...
Tarkvara paigaldamine
Tarkvara paigaldamiseks Debian Squeeze keskkonnas sobib öelda
# apt-get install pgbouncer
Paigaldatakse muu seas sellised failid
/usr/sbin/pgbouncer /etc/default/pgbouncer /etc/pgbouncer/pgbouncer.ini /etc/pgbouncer/userlist.txt /etc/init.d/pgbouncer
Tarkvara seadistamine
Tarvara tööd kontrollivad seadistusfailid
- /etc/pgbouncer/pgbouncer.ini, mille sisu võiks olla nt
# egrep -v "^$|^;" /etc/pgbouncer/pgbouncer.ini [databases] test = host=127.0.0.1 dbname=test [pgbouncer] logfile = /var/log/postgresql/pgbouncer.log pidfile = /var/run/postgresql/pgbouncer.pid listen_addr = * listen_port = 6432 unix_socket_dir = /var/run/postgresql auth_type = trust auth_file = /etc/pgbouncer/userlist.txt admin_users = postgres stats_users = postgres pool_mode = session server_reset_query = server_check_query = select 1 server_check_delay = 10 max_client_conn = 100 default_pool_size = 20 log_connections = 1 log_disconnections = 1 log_pooler_errors = 1
- /etc/pgbouncer/userlist.txt
Tarkvara kasutamine
TODO
