From 8d88928d771252c6140d20635b409fde89f8d611 Mon Sep 17 00:00:00 2001 From: Marko Kreen Date: Tue, 17 Apr 2012 15:54:08 +0300 Subject: [PATCH] Improve sample ini file - Use full paths for log and pidfile - comment out console users - comment out sample databases --- etc/pgbouncer.ini | 21 +++++++++++---------- 1 file changed, 11 insertions(+), 10 deletions(-) diff --git a/etc/pgbouncer.ini b/etc/pgbouncer.ini index 09d622f..1c4e8d8 100644 --- a/etc/pgbouncer.ini +++ b/etc/pgbouncer.ini @@ -7,15 +7,16 @@ [databases] ; foodb over unix socket -foodb = +;foodb = ; redirect bardb to bazdb on localhost -bardb = host=localhost dbname=bazdb +;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' +;forcedb = host=127.0.0.1 port=300 user=baz password=foo client_encoding=UNICODE datestyle=ISO connect_query='SELECT 1' -nondefaultdb = pool_size=50 reserve_pool=10 +; use custom pool sizes +;nondefaultdb = pool_size=50 reserve_pool=10 ; fallback connect string ;* = host=testserver @@ -27,8 +28,8 @@ nondefaultdb = pool_size=50 reserve_pool=10 ;;; Administrative settings ;;; -logfile = pgbouncer.log -pidfile = pgbouncer.pid +logfile = /var/log/pgbouncer/pgbouncer.log +pidfile = /var/run/pgbouncer/pgbouncer.pid ;;; ;;; Where to wait for clients @@ -50,18 +51,18 @@ listen_port = 6432 ; any, trust, plain, crypt, md5 auth_type = trust -;auth_file = 8.0/main/global/pg_auth -auth_file = etc/userlist.txt +;auth_file = /8.0/main/global/pg_auth +auth_file = /etc/pgbouncer/userlist.txt ;;; ;;; Users allowed into database 'pgbouncer' ;;; ; comma-separated list of users, who are allowed to change settings -admin_users = user2, someadmin, otheradmin +;admin_users = user2, someadmin, otheradmin ; comma-separated list of users who are just allowed to use SHOW command -stats_users = stats, root +;stats_users = stats, root ;;; ;;; Pooler personality questions -- 2.39.5