Doubt on pgbouncer
Hi Team,
How can I split read and write queries using pgbouncer
Regards
A.Rama Krishnan
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
Virus-free.
www.avast.com
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
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.
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:
Show quoted text
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.comIf only the physical world exists, free will is an illusion.
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.
Thank you for the clarification.
On Sat, 3 Jul, 2021, 23:20 Ben Chobot, <bench@silentmedia.com> wrote:
Show quoted text
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.
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
Try using HAProxy.
Regards,
Ganesh Korde.
On Sat, 3 Jul 2021, 9:06 pm Rama Krishnan, <raghuldrag@gmail.com> wrote:
Show quoted text
Hi Team,
How can I split read and write queries using pgbouncer
Regards
A.Rama Krishnan
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail> Virus-free.
www.avast.com
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
<#m_3619964688060668000_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
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:
Show quoted text
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
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail> Virus-free.
www.avast.com
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
<#m_2585993038985863414_m_3619964688060668000_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
Ok, thank you sir
On Thu, 22 Jul, 2021, 20:23 Ninad Shah, <nshah.postgres@gmail.com> wrote:
Show quoted text
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
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail> Virus-free.
www.avast.com
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
<#m_-3565042833678223020_m_2585993038985863414_m_3619964688060668000_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>