Thank you for the clarification. On Sat, 3 Jul, 2021, 23:20 Ben Chobot, <be...@silentmedia.com> wrote:
> Rama Krishnan wrote on 7/3/21 8:35 AM: > > > Hi Team, > > How can I split read and write queries using pgbouncer > > > You do it with your application. Make a pgbouncer database for read/write > queries and point it at your postgresql primary, and then make a second > pgbouncer database for read-only queries and point it at a replica. Have > your application connect to the proper database, depending upon its needs. > > It's not transparent, but it is effective. >
