This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
soft:pgbouncer [2019/08/07 16:22] phil created |
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 110: | Line 110: | ||
% PGPASSWORD=wrong psql -p 6432 -U foo -d template1 -c ' | % PGPASSWORD=wrong psql -p 6432 -U foo -d template1 -c ' | ||
psql: ERROR: | psql: ERROR: | ||
+ | |||
+ | % PGPASSWORD=bar createdb -p 6432 -U bar bar | ||
+ | createdb: database creation failed: ERROR: | ||
+ | |||
+ | % PGPASSWORD=foo createdb -p 6432 -U foo foo | ||
+ | |||
+ | % PGPASSWORD=foo psql -p 6432 -U foo -d foo -c ' | ||
+ | | ||
+ | -------------- | ||
+ | foo | ||
+ | (1 row) | ||
+ | |||
+ | % PGPASSWORD=secret psql -p 6432 -U pgbouncer -d pgbouncer -c 'show databases' | ||
+ | | ||
+ | -----------+------+------+-----------+------------+-----------+--------------+-----------+-----------------+---------------------+--------+---------- | ||
+ | | ||
+ | | ||
+ | (2 rows) | ||
+ | |||
</ | </ |