In this article, the author explains how libpq can support configuring multiple backend connection preferences, including read-only, prefer-read, and prefer-write.
