HI! I use last version of Percona Everest and launche DBs by web UI. How I can manage settings for pgbouncer ? For example count of max_client_conn ?
Hi,
Here’s one method making changes to a pgbouncer runtime parameter such as “max_client_conn”
- Configure pgbouncer for remote administrative access
- edit “pgbouncer.ini”
;;;
;;; Users allowed into database 'pgbouncer'
;;;
admin_users = pgbouncer
- edit pgbouncer file "userlist.txt" (actually password can be hashed, refer to documentation)
;; EXAMPLE password/username
"pgbouncer" "pgbouncer"
-
Restart pgbouncer
-
login pgbouncer as administrator
- login
psql -h myhost -p 6432 -U pgbouncer
- assumptions:
- useraccount pgbouncer doesn’t exist on postgres server
- pgbouncer password is set in userlist.txt
- port number is 6432
- login
-
set the runtime parameter
set max_client_conn = 50;
CAVEAT: The runtime parameter is effective only until the next time you restart pgbouncer. Otherwise, you’ll need to edit pgbouncer.ini.
Hope this helps.
reference