diff options
author | root <root@rshg054.dnsready.net> | 2013-01-16 00:05:27 -0800 |
---|---|---|
committer | root <root@rshg054.dnsready.net> | 2013-01-16 00:05:27 -0800 |
commit | e1c991185c594db7cc8978ed0239ebca4d37560e (patch) | |
tree | 4194e204102f73813c57aed0afba08fd06e38999 /extra/pgbouncer/pgbouncer.ini | |
parent | 733e4f771063834ef4d8f31af1dcac95d55e3c3e (diff) |
Wed Jan 16 00:05:27 PST 2013
Diffstat (limited to 'extra/pgbouncer/pgbouncer.ini')
-rw-r--r-- | extra/pgbouncer/pgbouncer.ini | 52 |
1 files changed, 52 insertions, 0 deletions
diff --git a/extra/pgbouncer/pgbouncer.ini b/extra/pgbouncer/pgbouncer.ini new file mode 100644 index 000000000..183c9c39d --- /dev/null +++ b/extra/pgbouncer/pgbouncer.ini @@ -0,0 +1,52 @@ +[pgbouncer] +logfile = /var/log/pgbouncer/pgbouncer.log +pidfile = /run/pgbouncer/pgbouncer.pid + +;; ip address or * which means all ip-s +;listen_addr = 127.0.0.1 +;listen_port = 6432 + +unix_socket_dir = /run/postgresql +unix_socket_mode = 0777 + +; any, trust, plain, crypt, md5 +auth_type = trust +auth_file = /etc/pgbouncer/userlist.txt + +; comma-separated list of users, who are allowed to change settings +admin_users = postgres + +; comma-separated list of users who are just allowed to use SHOW command +stats_users = stats, postgres + +; total number of clients that can connect +max_client_conn = 100 + +; default pool size. 20 is good number when transaction pooling +; is in use, in session pooling it needs to be the number of +; max clients you want to handle at any moment +default_pool_size = 20 + + +;; database name = connect string +;; +;; connect string params: +;; dbname= host= port= user= password= +;; client_encoding= datestyle= timezone= +;; pool_size= connect_query= +[databases] + +; foodb over unix socket +;foodb = + +; redirect bardb to bazdb on localhost +;bardb = host=localhost dbname=bazdb + +; acceess to dest database will go with single user +;forcedb = host=127.0.0.1 port=300 user=baz password=foo client_encoding=UNICODE datestyle=ISO connect_query='SELECT 1' + +; use custom pool sizes +;nondefaultdb = pool_size=50 reserve_pool=10 + +; fallback connect string +;* = host=testserver |