Pgbouncer related query: Discussion with chatGpt

Query:

Where id pgbouncer config file in ubuntu?

On Ubuntu, the PgBouncer config file location depends on how you installed it.

---

✅ Default location (APT install)

If you installed via:

sudo apt install pgbouncer

👉 Config file is usually:

/etc/pgbouncer/pgbouncer.ini

---

📂 Other important files

🔹 User list (auth file)

/etc/pgbouncer/userlist.txt

---

🔹 Service config (systemd)

/lib/systemd/system/pgbouncer.service

---

🔍 Verify actual config path (recommended)

Run:

ps aux | grep pgbouncer

Look for:

pgbouncer /etc/pgbouncer/pgbouncer.ini

👉 That shows the exact file in use

---

⚡ If running manually

If you started like:

pgbouncer /path/to/custom.ini

👉 Then config is wherever you specified

---

🔧 Quick check command

pgbouncer -V

or

pgbouncer -h

---

🚀 Typical minimal config example

[databases]
mydb = host=127.0.0.1 port=5432 dbname=mydb

[pgbouncer]
listen_addr = 127.0.0.1
listen_port = 6432
auth_type = md5
auth_file = /etc/pgbouncer/userlist.txt

---

🧠 Pro tip (important)

If you modify config:

sudo systemctl restart pgbouncer

---

✅ Final answer

👉 Most likely your config is:

/etc/pgbouncer/pgbouncer.ini