Postgres Pro
Downloads
Home   >   mailing lists

Thread: Doubt on pgbouncer

Doubt on pgbouncer

From
Rama Krishnan
Date:

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

From
Bruce Momjian
Date:
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  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  If only the physical world exists, free will is an illusion.

Re: Doubt on pgbouncer

From
Rama Krishnan
Date:
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, <bruce@momjian.us> wrote:
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  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  If only the physical world exists, free will is an illusion.

Re: Doubt on pgbouncer

From
Ben Chobot
Date:
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.

Re: Doubt on pgbouncer

From
Rama Krishnan
Date:
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.

Re: Doubt on pgbouncer

From
Merlin Moncure
Date:
On Sat, Jul 3, 2021 at 10:36 AM Rama Krishnan <raghuldrag@gmail.com> 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

From
Ganesh Korde
Date:
Try using HAProxy.

Regards,
Ganesh Korde.

On Sat, 3 Jul 2021, 9:06 pm Rama Krishnan, <raghuldrag@gmail.com> wrote:

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

From
Ninad Shah
Date:
Pgbouncer doesn't provide such a functionality. Kindly consider using pgpool.

On Thu, 22 Jul 2021 at 15:58, Ganesh Korde <ganeshakorde@gmail.com> wrote:
Try using HAProxy.

Regards,
Ganesh Korde.

On Sat, 3 Jul 2021, 9:06 pm Rama Krishnan, <raghuldrag@gmail.com> wrote:

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

From
Rama Krishnan
Date:
Ok, thank you sir

On Thu, 22 Jul, 2021, 20:23 Ninad Shah, <nshah.postgres@gmail.com> wrote:
Pgbouncer doesn't provide such a functionality. Kindly consider using pgpool.

On Thu, 22 Jul 2021 at 15:58, Ganesh Korde <ganeshakorde@gmail.com> wrote:
Try using HAProxy.

Regards,
Ganesh Korde.

On Sat, 3 Jul 2021, 9:06 pm Rama Krishnan, <raghuldrag@gmail.com> wrote:

Hi Team,

How can I split read and write queries using pgbouncer

Regards

A.Rama Krishnan

Virus-free. www.avast.com