Managing traffic to the database can get harder and harder as it increases in amount and the database is actually distributed across multiple servers. PostgreSQL…
View More PostgreSQL Replication Setup using HAProxy
Tag: pgpool
PostgreSQL Connection Pooling and Load Balancing with PgPool-II Cluster
In this post, I will walk you through on how to perform load balancing and connection pooling with PgPool-II, what are the benefits and motivation…
View More PostgreSQL Connection Pooling and Load Balancing with PgPool-II Cluster
How to Configure SCRAM and MD5 Authentication in Pgpool-II
scram-sha-256 Authentication Configuration To perform the password-based authentication, Pgpool-II requires a password file which contains a list of database users and passwords in format username:password. The…
View More How to Configure SCRAM and MD5 Authentication in Pgpool-II