pgbouncer

 10 ;[databases]
 11 * = host=localhost port=5432
 12
 13 ; redirect bardb to bazdb on localhost
 14 ;bardb = host=localhost dbname=bazdb
 15
 16 ; acceess to dest database will go with single user
 17 ;forcedb = host=127.0.0.1 port=300 user=baz password=foo client_encoding=UNICODE datestyle=ISO connect_query='SELECT 1'
 18
 19 ; use custom pool sizes
 20 ;nondefaultdb = pool_size=50 reserve_pool_size=10
 21
 22 ; fallback connect string
 23 ;* = host=testserver
 24
 25 ;; Configuration section
 26 [pgbouncer]
 27
 28 ;;;
 29 ;;; Administrative settings
 30 ;;;
 31
 32 logfile = /var/log/pgbouncer/pgbouncer.log
 33 pidfile = /var/run/pgbouncer/pgbouncer.pid
 34
 35 ;;;
 36 ;;; Where to wait for clients
 37 ;;;
 38
 39 ; ip address or * which means all ip-s
 40 listen_addr = *
 41 listen_port = 6666
 42
 43 ; unix socket is also used for -R.
 44 ; On debian it should be /var/run/postgresql
 45 ;unix_socket_dir = /tmp
 46 ;unix_socket_mode = 0777
 47 ;unix_socket_group =
 48
 49 ;;;
 50 ;;; Authentication settings
 51 ;;;
 52
 53 ; any, trust, plain, crypt, md5
 54 auth_type = md5
 55 ;auth_file = /8.0/main/global/pg_auth
 56 ;auth_file = /usr/local/share/doc/pgbouncer/userlist.txt
 57
 58 ;; Query to use to fetch password from database.  Result
 59 ;; must have 2 columns - username and password hash.
 60 auth_query = SELECT usename, passwd FROM pg_shadow WHERE usename=$1
 61
 62 ;;;
 63 ;;; Users allowed into database 'pgbouncer'
 64 ;;;
 65
 66 ; comma-separated list of users, who are allowed to change settings
 67 admin_users = postgres
 68
 69 ; comma-separated list of users who are just allowed to use SHOW command
 70 stats_users = postgres
 71
 72 ;;;
 73 ;;; Pooler personality questions
 74 ;;;
 75
 76 ; When server connection is released back to pool:
 77 ;   session      - after client disconnects
 78 ;   transaction  - after transaction finishes
 79 ;   statement    - after statement finishes
 80 pool_mode = transaction