In this article, the author explains how libpq can support configuring multiple backend connection preferences, including read-only, prefer-read, and prefer-write.
In this article, the author discusses libpq failover and load balancing JDBC driver layer in PostgreSQL.
