Differences

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

--- soft:pgbouncer [2019/08/07 18:58]
phil
+++ soft:pgbouncer [2019/08/07 19:12] (current)
phil
@@ Line 66: / Line 66: @@
 [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
-# 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
 # connect all other database through unix socket
@@ Line 121: / Line 121: @@
  foo
 (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>

philpep's wiki