PostgreSQL

PostgreSQL Application Connection Failover Using HAProxy with xinetd

PostgreSQL Application Connection Failover Using HAProxy with xinetd

Recently we published a blog about a very simple application failover using libpq features which could be the simplest of all automatic application connection routing.  In this blog post, we are discussing how a proxy server using HAProxy can be used for connection routing which is a well-known technique with very wide deployment. There […]

Read more

Seamless Application Failover using libpq Features in PostgreSQL

libpq features in postgresql

When you build replication in PostgreSQL using Streaming replication, you cannot perform writes to a standby node; only reads. This way, you could offload reads or reporting queries to standby servers and send writes to master. Additionally, starting from PostgreSQL 10,
libpq  and
psql clients could probe the connection for a master and allow […]

Read more