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.
Relevant Blogs
The Cache that Wasn’t: Optimizing Postgres for SELECT Performance
What’s the first thing that springs to mind when thinking about the word “cache”? For many of us who work with databases regularly, the first thought is usually to take...Postgres Partition: Upgrade your Partitioning from Inheritance to Declarative
Before PostgreSQL 10, Postgres users partitioned their data using inheritance based partitioning. The method used constraints to define the partitions and rules or triggers to route the data to appropriate...Replication Server 7 vs Postgres Distributed 5.0: Which Offers Better Performance and Scalability?
Introduction EDB provides the tool EDB Replication Server (xDB/EPRS) 7.4 that's a trigger or physical replication-based system with a managed process for data distribution. It can perform multi-master replication, but...More Blogs
PG Phriday: Addressing Demands of Highly Available OLTP Environments
What do you think of when you encounter the acronym: OLTP? We all know the acronym stands for Online Transaction Processing, and probably equate that with “lots of transactions”. But...