Doubt on pgbouncer

Hi Team, How can I split read and write queries using pgbouncer Regards A.Rama Krishnan Virus-free. www.avast.com

Re: Doubt on pgbouncer

On Sat, Jul 3, 2021 at 09:05:58PM +0530, Rama Krishnan wrote: > > Hi Team, > > How can I split read and write queries using pgbouncer No. I think only PgPool can do that because it parses the SQL. -- Bruce Momjian https://momjian.us EDB https

Re: Doubt on pgbouncer

Hi Bruce Thank you for the clarification. Can you pls share any links or docs about my doubt that can be helpful for me further information On Sat, 3 Jul, 2021, 21:21 Bruce Momjian, wrote: > On Sat, Jul 3, 2021 at 09:05:58PM +0530, Rama Krishnan wrote: > > > > Hi Team, > > > > How can I split

Re: Doubt on pgbouncer

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 a

Re: Doubt on pgbouncer

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

Re: Doubt on pgbouncer

On Sat, Jul 3, 2021 at 10:36 AM Rama Krishnan wrote: > > > Hi Team, > > How can I split read and write queries using pgbouncer Check out pgbouncer-rr. I haven't used it, but it may do what you need. merlin

Re: Doubt on pgbouncer

Try using HAProxy. Regards, Ganesh Korde. On Sat, 3 Jul 2021, 9:06 pm Rama Krishnan, wrote: > > Hi Team, > > How can I split read and write queries using pgbouncer > > Regards > > A.Rama Krishnan > > >

Re: Doubt on pgbouncer

Pgbouncer doesn't provide such a functionality. Kindly consider using pgpool. On Thu, 22 Jul 2021 at 15:58, Ganesh Korde wrote: > Try using HAProxy. > > Regards, > Ganesh Korde. > > On Sat, 3 Jul 2021, 9:06 pm Rama Krishnan, wrote: > >> >> Hi Team, >> >> How can I split read and write queries u

Re: Doubt on pgbouncer

Ok, thank you sir On Thu, 22 Jul, 2021, 20:23 Ninad Shah, wrote: > Pgbouncer doesn't provide such a functionality. Kindly consider using > pgpool. > > On Thu, 22 Jul 2021 at 15:58, Ganesh Korde wrote: > >> Try using HAProxy. >> >> Regards, >> Ganesh Korde. >> >> On Sat, 3 Jul 2021, 9:06 pm Rama