# How I can set max\_client\_conn for pgbouncer?

**URL:** <https://forums.percona.com/t/how-i-can-set-max-client-conn-for-pgbouncer/38598>\
**Category:** PostgreSQL\
**Created:** [July 8, 2025, 12:00pm UTC](https://forums.percona.com/t/how-i-can-set-max-client-conn-for-pgbouncer/38598 "2025-07-08T12:00:01Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Andrei\_Zakabluk1](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/andrei_zakabluk1/32/21442_2.png) [@Andrei\_Zakabluk1](https://forums.percona.com/u/Andrei_Zakabluk1)\
**Post date:** [July 8, 2025, 12:00pm UTC](https://forums.percona.com/t/how-i-can-set-max-client-conn-for-pgbouncer/38598/1 "2025-07-08T12:00:01Z")

</div>

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 ?

---

<div class="post-metadata">

**Author:** ![Robert\_Bernier](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/robert_bernier/32/1367_2.png) [@Robert\_Bernier](https://forums.percona.com/u/Robert_Bernier)\
**Post date:** [July 8, 2025, 4:51pm UTC](https://forums.percona.com/t/how-i-can-set-max-client-conn-for-pgbouncer/38598/2 "2025-07-08T16:51:14Z")

</div>

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”

```auto

        ;;;
        ;;; Users allowed into database 'pgbouncer'
        ;;;

        admin_users = pgbouncer

```

```
- edit pgbouncer file "userlist.txt" (actually password can be hashed, refer to documentation)

```

```auto
        ;; EXAMPLE password/username
        "pgbouncer" "pgbouncer"

```

- Restart pgbouncer

- login pgbouncer as administrator

- 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**

> **[pgbouncer(5) — pgbouncer — Debian testing — Debian Manpages](https://manpages.debian.org/testing/pgbouncer/pgbouncer.5.en.html)**