Chapter 3. Pooling Resources

In this chapter, we will learn to combine and abstract connectivity to isolate and protect the database. We will cover the following recipes in this chapter:

• Determining connection costs and limits
• Installing PgBouncer
• Configuring PgBouncer safely
• Connecting to PgBouncer
• Listing PgBouncer server connections
• Listing PgBouncer client connections
• Evaluating PgBouncer pool health
• Installing pgpool
• Configuring pgpool for master/slave mode
• Testing a write query on pgpool
• Swapping active nodes with pgpool
• Combining the power of pgBouncer and pgpool