Erinevus lehekülje "PgBouncer" redaktsioonide vahel
Allikas: Kuutõrvaja
(Uus lehekülg: '===Sissejuhatus=== PgBouncer https://developer.skype.com/SkypeGarage/DbProjects/PgBouncer ... ===Tarkvara paigaldamine=== TODO ===Tarkvara seadistamine=== TODO ===Tarkvara kas…') |
|||
| 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 14:25
Sisukord
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
