User Tools

Site Tools


soft:pgbouncer

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
soft:pgbouncer [2019/08/07 18:58]
phil
soft:pgbouncer [2019/08/07 19:12] (current)
phil
Line 66: Line 66:
 [databases] [databases]
 # You will need max_db_connections=1 on template1 database, otherwise multiple connections to the template1 database will not allow running "​createdb"​ through pgbouncer # You will need max_db_connections=1 on template1 database, otherwise multiple connections to the template1 database will not allow running "​createdb"​ through pgbouncer
-# Also for unknown reason, not setting ​auth_user here don't work+# Also for unknown reason, not repeating ​auth_user here don't work
 template1 = auth_user=pgbouncer max_db_connections=1 template1 = auth_user=pgbouncer max_db_connections=1
 # connect all other database through unix socket # connect all other database through unix socket
Line 121: Line 121:
  foo  foo
 (1 row) (1 row)
 +
 +% PGPASSWORD=secret psql -p 6432 -U pgbouncer -d pgbouncer -c 'show databases'​
 +   ​name ​   | host | port | database ​ | force_user | pool_size | reserve_pool | pool_mode | max_connections | current_connections | paused | disabled ​
 +-----------+------+------+-----------+------------+-----------+--------------+-----------+-----------------+---------------------+--------+----------
 + ​pgbouncer |      | 6432 | pgbouncer | pgbouncer ​ |         2 |            0 | statement |               0 |                   0 |      0 |        0
 + ​template1 |      | 5432 | template1 |            |        20 |            0 |           ​| ​              1 |                   0 |      0 |        0
 +(2 rows)
 +
 </​code>​ </​code>​
soft/pgbouncer.txt ยท Last modified: 2019/08/07 19:12 by phil