Re: Doubt on pgbouncer - Mailing list pgsql-general

From Rama Krishnan
Subject Re: Doubt on pgbouncer
Date
Msg-id CAJWX+ENynPi70Ti9zK692e8=dgTLToXicS=3xtopdsvUJas40g@mail.gmail.com
Whole thread Raw
In response to Re: Doubt on pgbouncer  (Ben Chobot <bench@silentmedia.com>)
List pgsql-general
Thank you for the clarification. 

On Sat, 3 Jul, 2021, 23:20 Ben Chobot, <bench@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.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Damaged (during upgrade?) table, how to repair?
Next
From: Yi Sun
Date:
Subject: Re: postgresql version 13 repo question