Seamless Application Failover using 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 […]