PgBouncer Pro Tip: Use auth_user

December 18, 2018

Anyone running a database in a production environment with over a hundred users should seriously consider employing a connection pooler to keep resource usage under control. PgBouncer is one such tool, and it’s great because it’s lightweight and yet has a handful of nifty features for DBAs that have very specific needs. One of these nifty features that I want to share about is theauth_userandauth_querycombo that serves as an alternative to the default authentication process that usesuserlist.txt

“What’s wrong withuserlist.txt” you may ask?

Read more on Postgres Rocks to learn why user/role administration can be tricky. >>


Every #TechTuesday, EnterpriseDB shares a how-to post authored by a Postgres contributor and expert for Postgres Gems, the PostgresRocks community forum. PostgresRocks is a community to discuss all things Postgres. Join us at PostgresRocks and be part of the conversation.

Share this