Difference between revisions of "Pgbouncer"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
| + | # Usage | ||
| + | - https://www.pgbouncer.org/usage.html | ||
| + | |||
# Install | # Install | ||
``` | ``` | ||
Revision as of 00:54, 17 January 2021
Usage
Install
apt install pgbouncer
create role someuser; create role someadmin; ALTER ROLE someadmin WITH PASSWORD 'test'; ALTER ROLE someuser WITH PASSWORD 'test'; ALTER ROLE someuser WITH login; ALTER ROLE someadmin WITH login SUPERUSER;
Update userlist.txt
sudo -u postgres psql -Atq -U postgres -d postgres -c "SELECT concat('\"', usename, '\" \"', passwd, '\"') FROM pg_shadow" > /etc/pgbouncer/userlist.txt
/etc/pgbouncer/pgbouncer.ini
[databases] # pgb = dbname=pgb host=127.0.0.1 port=5432 template1 = dbname=template1 host=127.0.0.1 port=5432 auth_type = md5 # any, trust, plain, md5, cert, hba, pam
Reestart
service restart pgbouncer