PgBouncer

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 ja käivitamine

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 sisaldab nt

"postgres" "parool"

Käivitamiseks peab olema failis /etc/default/pgbouncer rida

START=1

ja tuleb öelda

# /etc/init.d/pgbouncer start

Tarkvara kasutamine

TODO

Kasulikud lisamaterjalid

• PostgreSQL