I've been looking at pgbouncer, among other add-ons, to use it's connection pooling to distribute queries to my primary and standby servers, but I don't see how, if some of these are writes, if it decides to only send those operations to the primary server, as obviously you cannot send writes to a standby server. I'm not finding anything about this online. Has anyone implemented pgbouncer that could speak knowledgeably?
--
Jay