PgBouncer Pro Tip: Use auth_user

December 18, 2018

Contributed by Richard  Yen 

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

Relevant Blogs

More Blogs

PostgreSQL VACUUM and ANALYZE Best Practice Tips

VACUUM and ANALYZE are the two most important PostgreSQL database maintenance operations.  A vacuum is used for recovering space occupied by “dead tuples” in a table. A dead tuple is...
January 27, 2023