Proxies for PostgreSQL

/ home / computer / postgresql / postgresql for mysql admins / .

Table of Contents

• Which PostgreSQL HA Solution Fits Your Needs: Pgpool or Patroni?

PostgreSQL 16 Brings Native Load Balancing to libpq for Improved Scalability https://medium.com/@mydbopsdatabasemanagement/postgresql-16-brings-native-load-balancing-to-libpq-for-improved-scalability-54a0a2588552

https://dhamaniasad.github.io/awesome-postgres/ https://github.com/stars/tbussmann/lists/postgresql

mails von daniel und tobias

Pgpool-II

• Pgpool-II
• https://www.pgpool.net/docs/latest/en/html/example-cluster.html
• pgpool https://stormatics.tech/blogs/which-postgresql-ha-solution-fits-your-needs-pgpool-or-patroni
• Which PostgreSQL HA Solution Fits Your Needs: Pgpool or Patroni?

Based on PostgreSQL Streaming Replication

Slony-I

(outdated?) https://www.slony.info/ https://wiki.postgresql.org/wiki/Slony

HAproxy

…

ProxySQL

https://proxysql.com/documentation/proxysql-configuration-postgresql/

ProxySQL for PostgreSQL https://proxysql.com/documentation/proxysql-configuration-postgresql/

Spock pgEdge (Enterprise) https://docs.pgedge.com/spock-v5/development/install_spock/#creating-a-replication-scenario

EDB Failover manager

https://www.reddit.com/r/PostgreSQL/comments/1j0chnt/what_solution_do_you_use_for_automatic_failover/

Introduction to pg_auto_failover (Citus) https://pg-auto-failover.readthedocs.io/en/main/intro.html

Repmgr https://wiki.postgresql.org/wiki/Repmgr

pgCat

Connection pooler, not so much maintened any more?

• https://github.com/postgresml/pgcat
• https://pgcat.org/
• https://dev.to/yugabyte/pgcat-a-postgresql-pooler-3a24 (YugabyteDB)
• https://www.enterprisedb.com/blog/transaction-pooling-postgres-pgcat

PgBouncer

• https://www.enterprisedb.com/blog/transaction-pooling-postgres-pgcat
• PgBouncer

JDBC-Connector

• JDBC: Connection Pools and Data Sources