Do it in SQL: pgbouncer_wrapper
summary
pgbouncer_wrapper lets you control pgbouncer with SQL by exposing one view per SHOW command and one function per control command, running as a lightweight Postgres instance that talks to the pgbouncer console. You can pause/resume pools, set default_pool_size 300, and run SELECTs like clients grouped by addr. It logs actions, handles injection carefully, reports bugs mostly when pgbouncer adds columns, lacks cross-command locking, and is proven in production to have rescued SLOs — distribution via pgbouncer_wrapper on PGXN is considered.
AI-written summary · about
chapters (5)
- 0:00Start
- 8:04Monitoring and Control Systems
- 12:08Typical User Experience
- 27:14Issue a Pause Command
- 40:46Feedback Forms
related talks
46mPgBouncer Connection Pooling and Routing
51mConnection pooling routing and queueing with pgBouncer
53mPgBouncer: Present and Future
44mPgBouncer and 20000 TPS at one node: advanced tuning, hacks and problem solving
59mComparing Connection Poolers for PostgreSQL
23mComparing Postgres connection pooler support for prepared statements
20mElephant by the pool: PostgreSQL connection poolers overview
43mWhen it all GOes right