This shows you the differences between two versions of the page.
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 " | # You will need max_db_connections=1 on template1 database, otherwise multiple connections to the template1 database will not allow running " | ||
- | # Also for unknown reason, not setting | + | # Also for unknown reason, not repeating |
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' | ||
+ | | ||
+ | -----------+------+------+-----------+------------+-----------+--------------+-----------+-----------------+---------------------+--------+---------- | ||
+ | | ||
+ | | ||
+ | (2 rows) | ||
+ | |||
</ | </ |