Thank you for the clarification.
On Sat, 3 Jul, 2021, 23:20 Ben Chobot, <bench@xxxxxxxxxxxxxxx> 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.
