How I can set max_client_conn for pgbouncer?

PostgreSQL
1

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 ?

2

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

  • 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