pgbouncer/trunk/pgbouncer.ini

   1 [pgbouncer]
   2 logfile = /var/log/pgbouncer/pgbouncer.log
   3 pidfile = /run/pgbouncer/pgbouncer.pid
   4
   5 ;; ip address or * which means all ip-s
   6 ;listen_addr = 127.0.0.1
   7 ;listen_port = 6432
   8
   9 unix_socket_dir = /run/postgresql
  10 unix_socket_mode = 0777
  11
  12 ; any, trust, plain, crypt, md5
  13 auth_type = trust
  14 auth_file = /etc/pgbouncer/userlist.txt
  15
  16 ; comma-separated list of users, who are allowed to change settings
  17 admin_users = postgres
  18
  19 ; comma-separated list of users who are just allowed to use SHOW command
  20 stats_users = stats, postgres
  21
  22 ; total number of clients that can connect
  23 max_client_conn = 100
  24
  25 ; default pool size.  20 is good number when transaction pooling
  26 ; is in use, in session pooling it needs to be the number of
  27 ; max clients you want to handle at any moment
  28 default_pool_size = 20
  29
  30
  31 ;; database name = connect string
  32 ;;
  33 ;; connect string params:
  34 ;;   dbname= host= port= user= password=
  35 ;;   client_encoding= datestyle= timezone=
  36 ;;   pool_size= connect_query=
  37 [databases]
  38
  39 ; foodb over unix socket
  40 ;foodb =
  41
  42 ; redirect bardb to bazdb on localhost
  43 ;bardb = host=localhost dbname=bazdb
  44
  45 ; acceess to dest database will go with single user
  46 ;forcedb = host=127.0.0.1 port=300 user=baz password=foo client_encoding=UNICODE datestyle=ISO connect_query='SELECT 1'
  47
  48 ; use custom pool sizes
  49 ;nondefaultdb = pool_size=50 reserve_pool=10
  50
  51 ; fallback connect string
  52 ;* = host=testserver