planner to not use this kind of join
which results in different plans when using this tainted pgbouncer
connection instead of the clean one from pg17.
The problem is that server_reset_query is not used when the pool is in
transaction mode. Now, we have to see how to fix this problem.
But you&#x
On 2025-May-05, Mladen Marinović wrote:
> Hi,
>
> Mystery not solved...but identified. The pool is in transaction mode and
> some connections use set enable_mergejoin=off, but they do not set it back
> to on.
Maybe instead of "SET enable_mergejoin=off" these connections could be
changed to use S
Hi , wish you good lock with the "transaction mode" 🙂 if pgbouncer is not
really needed , remove and use plain connections.i have experienced
pgbouncer in session mode over 2 years with situation like "pain in the
ass" , finaly removed t
in
different plans when using this tainted pgbouncer connection instead of the
clean one from pg17.
The problem is that server_reset_query is not used when the pool is in
transaction mode. Now, we have to see how to fix this problem.
Regards,
Mladen Marinović
On Mon, May 5, 2025 at 3:10 PM
ry vacuum analyze for the whole db , pgbouncer
connection layer can not causeslow queries.
I did that already. But the slow query is the consequence of the different
plan, not the statistics.
From: Mladen Marinović
Sent: Monday, May 5, 2025 12:27 PM
To: Achilleas Mantzios
Cc: pgs
: Monday, May 5, 2025 12:52 PM
To: SERHAD ERDEM
Cc: Achilleas Mantzios ;
pgsql-general@lists.postgresql.org
Subject: Re: Different execution plans in PG17 and pgBouncer...
On Mon, May 5, 2025 at 2:38 PM SERHAD ERDEM
mailto:serh...@hotmail.com>> wrote:
Hi , you had better try vacuum analy
On Mon, May 5, 2025 at 2:38 PM SERHAD ERDEM wrote:
> Hi , you had better try vacuum analyze for the whole db , pgbouncer
> connection layer can not causeslow queries.
>
I did that already. But the slow query is the consequence of the different
plan, not the s
>> On 5/5/25 11:00, Mladen Marinović wrote:
>>
>>
>>
>> On Mon, May 5, 2025 at 11:24 AM Achilleas Mantzios <
>> a.mantz...@cloud.gatewaynet.com> wrote:
>>
>>>
>>> On 5/5/25 09:52, Mladen Marinović wrote:
>>>
>>> Hi,
>&g
Hi , you had better try vacuum analyze for the whole db , pgbouncer
connection layer can not causeslow queries.
From: Mladen Marinović
Sent: Monday, May 5, 2025 12:27 PM
To: Achilleas Mantzios
Cc: pgsql-general@lists.postgresql.org
Subject: Re: Different
,
We recently migrated our production instances from PG11 to
PG17. While doing so we upgraded our pgBouncer instances
from 1.12 to 1.24. As everything worked on the test servers
we pushed this to production a few weeks ago. We did not
notice any problems until a few days
Mon, May 5, 2025 at 11:24 AM Achilleas Mantzios
wrote:
On 5/5/25 09:52, Mladen Marinović wrote:
Hi,
We recently migrated our production instances from PG11 to
PG17. While doing so we upgraded our pgBouncer instances
from 1.12 to 1.24. As everything wor
>> On 5/5/25 09:52, Mladen Marinović wrote:
>>
>> Hi,
>>
>> We recently migrated our production instances from PG11 to PG17. While
>> doing so we upgraded our pgBouncer instances from 1.12 to 1.24. As
>> everything worked on the test servers we pushed this to product
On 5/5/25 11:00, Mladen Marinović wrote:
On Mon, May 5, 2025 at 11:24 AM Achilleas Mantzios
wrote:
On 5/5/25 09:52, Mladen Marinović wrote:
Hi,
We recently migrated our production instances from PG11 to PG17.
While doing so we upgraded our pgBouncer instances from 1.12
On 5/5/25 09:52, Mladen Marinović wrote:
Hi,
We recently migrated our production instances from PG11 to PG17. While
doing so we upgraded our pgBouncer instances from 1.12 to 1.24. As
everything worked on the test servers we pushed this to production a
few weeks ago. We did not notice any
Hi,
We recently migrated our production instances from PG11 to PG17. While
doing so we upgraded our pgBouncer instances from 1.12 to 1.24. As
everything worked on the test servers we pushed this to production a few
weeks ago. We did not notice any problems until a few days ago (but the
problems
Hello,
> On Oct 10, 2024, at 03:02, Ravi Varma Addala wrote:
>
> Hello Team,I wanted to reach out to provide some insight into a request from
> my customer regarding their multiple PostgreSQL Flex instances with
> PGbouncer. Currently, they are utilizing an Azure Load
Hello Team,
I wanted to reach out to provide some insight into a request from my customer
regarding their multiple PostgreSQL Flex instances with PGbouncer. Currently,
they are utilizing an Azure Load Balancer which distributes connections using
the Round-robin mechanism. However, they are now
On Sun, Jul 9, 2023 at 6:28 AM Rita wrote:
>
> Is there a way to see how many queued connections there are? Looking at the
> stats I can't seem to figure that out.
pgbouncer exposes quite a few statistics via the SHOW commands [1].
See if any of those help.
[1]: https://www
Thanks for the tips. So far, I am very happy with PGbouncer. Just increased
number of db connections. Great piece of software!
Is there a way to see how many queued connections there are? Looking at the
stats I can't seem to figure that out.
On Sat, Jul 8, 2023 at 9:46 AM Ben Chobot
pgbouncer and is quite happy with ~30 server connections (roughly the
core count of the db server). If we couldn't use transaction pooling
we'd be fighting with how to keep those thousands of connections from
wasting a bunch of resources on our db.
https://www.pgbouncer.org/features.html
ver
> accordingly. However, I still get can't connect to postgresql some times. I
> installed pgbouncer on few servers in the farm. I pointed the traffic to
> pgbouncer and things helped dramatically. My question are: is there a ratio
> of max connections and pool i should use in my
On Fri, Jul 7, 2023 at 9:24 AM Rita wrote:
>
> My question are: is there a ratio of max connections and pool i should use in
> my pgbouncer config?
Short answer: No, there's no recommended ratio for PG max_connections
and pgbouncer pool size.
In pgbouncer, a client connect
Rita wrote on 7/7/23 9:23 AM:
I have an application that does many db calls from a server farm.
I've increased my max connections on postgresql to 1000 and tuned the
server accordingly. However, I still get can't connect to postgresql
some times. I installed pgbouncer on few serv
I have an application that does many db calls from a server farm. I've
increased my max connections on postgresql to 1000 and tuned the server
accordingly. However, I still get can't connect to postgresql some times. I
installed pgbouncer on few servers in the farm. I pointed the
Laurenz Albe wrote on 6/28/23 5:27 AM:
On Wed, 2023-06-28 at 07:19 -0400, Rita wrote:
seems like I may need to deploy pgbouncer for my webapp. should i deploy it on
the db server or on the webserver?
On the database server. You don't want network latency between pgbouncer and
PostgreSQ
so) during that time.
On Wed, Jun 28, 2023 at 8:23 AM Sebastiaan Mannem wrote:
> It greatly depends on what you want to achieve. Both have pro’s and con’s.
> What do you need pgbouncer for?
>
> Verstuurd vanaf mijn iPhone
>
> > Op 28 jun. 2023 om 13:19 heeft Rita het
ou'll direct to
pgbouncer.
A couple more: be careful to choose the right pool_mode and tune the
right server_connect_timeout value.
all the best, Giovanni
Il giorno mer 28 giu 2023 alle ore 13:19 Rita ha
scritto:
>
> seems like I may need to deploy pgbouncer for my webapp. should i deplo
On Wed, 2023-06-28 at 07:19 -0400, Rita wrote:
> seems like I may need to deploy pgbouncer for my webapp. should i deploy it
> on the db server or on the webserver?
On the database server. You don't want network latency between pgbouncer and
PostgreSQL,
so that the connections can b
It greatly depends on what you want to achieve. Both have pro’s and con’s.
What do you need pgbouncer for?
Verstuurd vanaf mijn iPhone
> Op 28 jun. 2023 om 13:19 heeft Rita het volgende
> geschreven:
>
>
>
> seems like I may need to deploy pgbouncer for my webapp. should
seems like I may need to deploy pgbouncer for my webapp. should i deploy it
on the db server or on the webserver?
--
--- Get your facts first, then you can distort them as you please.--
Hi There,
Could someone shed some light on this error please? I am trying to set
up pgbouncer on a postgres Paas instance.
Regards
Vikas
On 19.12.21 12:50, Shubham Mittal wrote:
2021-11-25 14:45:45.244 IST [18307] LOG C-0x6ae270:
sit/postgres@abcdlogin attempt: db=sit user=postgres tls=no
2021-11-25 14:45:45.299 IST [18307] LOG S-0x6b4f48: sit/postgres@abcd
new connection to server (from abcd)
2021-11-25 14:46:17.843 IST [18307]
Hi Team,
I get below logs in pgbouncer.. when I configure query timeout in spring
boot application as below:
SessionImplementor session = entityManager.unwrap(SessionImplementor.class);
Connection connection = session.connection();
connection.createStatement().execute("SET
Simply a bug.
https://github.com/pgbouncer/pgbouncer/issues/568
Cheers, Markus
> -Ursprüngliche Nachricht-
> Von: Zwettler Markus (OIZ)
> Gesendet: Dienstag, 7. Dezember 2021 17:10
> An: pgsql-general@lists.postgresql.org
> Betreff: error connecting to pgbouncer admin
On 07.12.21 17:10, Zwettler Markus (OIZ) wrote:
I did a pgbouncer configuration using the following ini file:
[databases]
* = host=localhost port=5433 auth_user=pgbouncer
Using the name "pgbouncer" for auth_user is buggy. Try using a
different name.
I did a pgbouncer configuration using the following ini file:
[databases]
* = host=localhost port=5433 auth_user=pgbouncer
[users]
[pgbouncer]
logfile = /pgdata/pcl_l002/pgbouncer/pgbouncer_pcl_l002.log
pidfile = /pgdata/pcl_l002/pgbouncer/pgbouncer_pcl_l002.pid
listen_addr = *
listen_port
I manage PostgreSQL v12.8 database clusters.
Our database clusters are on Linux VMs, with OS:
Flavor: redhat_7
Release: 3.10.0-1160.45.1.el7.x86_64
We have repmgr clusters of 1 Primary & 2 Standby servers & use another server
with PgBouncer to direct the connections to the current
There is no equation to determine the best value. It depends on your
environment.
Regards,
Ninad Shah
On Wed, 3 Nov 2021 at 19:18, Rama Krishnan wrote:
>
> Hi All,
>
> What is the limit value for fixing connection timeout issues?
>
> As i searched in google and verified
Hi All,
What is the limit value for fixing connection timeout issues?
As i searched in google and verified pgbouncer document
client_login_timeout
If a client connects but does not manage to log in in this amount of time,
it will be disconnected. Mainly needed to avoid dead connections stalling
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,
>> Gan
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,
>&g
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
>
>
> <https://www.avast.com/sig-email?utm_medium=email&am
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
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 rea
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
;
> > 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://enterprisedb.com
>
> If only the physical world exists, free will is an illusion.
>
>
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://momj
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=
I had to install pam-devel before reinstalling pgbouncer. appears to be
working now. thanks for pointing me in the right direction Laurenz!
On Wed, Apr 28, 2021 at 7:09 AM Chris Stephens
wrote:
> huh. you are right. i originally installed pgbouncer with yum but removed
> with just "
huh. you are right. i originally installed pgbouncer with yum but removed
with just "yum remove pgbouncer" before following "Building from Git"
section at http://www.pgbouncer.org/install.html.
i just ran "make uninstall" -> reinstalled with
403 21-04-28 06:5
On Tue, 2021-04-27 at 19:46 -0500, Chris Stephens wrote:
> I'm trying to run pgbouncer but am having trouble with what looks like a very
> simple configuration.
>
> centos 7
> postgres 12
> pgbouncer 1.15
>
> we are already using pam for database auth. pgbouncer wa
I'm trying to run pgbouncer but am having trouble with what looks like a
very simple configuration.
centos 7
postgres 12
pgbouncer 1.15
we are already using pam for database auth. pgbouncer was compiled with
--with-pam. there is a /etc/pam.d/pgbouncer config file copied from the one
curr
On Wed, Oct 14, 2020 at 11:08 AM Atul Kumar wrote:
> Hi Team,
>
> Please share a clean example of installing,
https://www.pgbouncer.org/install.html
> configuring
https://www.pgbouncer.org/config.html
> and testing pgBouncer.
>
https://www.pgbouncer.org/usage.html
Wha
On Wed, Oct 14, 2020 at 10:08 AM Atul Kumar wrote:
> Please share a clean example of installing, configuring and testing
> pgBouncer.
>
> Your official links are not organized so I need an example of
> PgBouncer with organized steps.
>
As I said on your exact same posting
Hi Team,
Please share a clean example of installing, configuring and testing pgBouncer.
Your official links are not organized so I need an example of
PgBouncer with organized steps.
Regards,
Atul
On 2/10/20 9:50 π.μ., Fabio Pardi wrote:
Hi Rama,
On 02/10/2020 01:42, Rama Krishnan wrote:
Hi Friends,
By using pg bouncer can we split read and queries
pgbouncer is just a connection pooler.
The logic where to send the reads and where the writes, should be in our
application.
yeah
On Thursday, October 1, 2020, Fabio Pardi wrote:
> Hi Rama,
>
> On 02/10/2020 01:42, Rama Krishnan wrote:
>
> Hi Friends,
>
> By using pg bouncer can we split read and queries
>
>
> pgbouncer is just a connection pooler.
>
> The logic where to send the read
Hi Rama,
On 02/10/2020 01:42, Rama Krishnan wrote:
> Hi Friends,
>
> By using pg bouncer can we split read and queries
>
pgbouncer is just a connection pooler.
The logic where to send the reads and where the writes, should be in our
application.
regards,
fabio pardi
Yeah. Rob
On Fri, 2 Oct, 2020, 05:14 Rob Sargent, wrote:
>
>
> > On Oct 1, 2020, at 5:42 PM, Rama Krishnan wrote:
> >
> > Hi Friends,
> >
> > By using pg bouncer can we split read and queries
> >
> > Thank
> > Rk
>
> Did you mean reads vs writes?
>
Yeah rob can we spilt read/write queries using pgbouncer
On Fri, 2 Oct, 2020, 08:43 Rama Krishnan, wrote:
> Yeah. Rob
>
> On Fri, 2 Oct, 2020, 05:14 Rob Sargent, wrote:
>
>>
>>
>> > On Oct 1, 2020, at 5:42 PM, Rama Krishnan wrote:
>> >
>> &g
> On Oct 1, 2020, at 5:42 PM, Rama Krishnan wrote:
>
> Hi Friends,
>
> By using pg bouncer can we split read and queries
>
> Thank
> Rk
Did you mean reads vs writes?
Hi Friends,
By using pg bouncer can we split read and queries
Thank
Rk
On 2020-08-21 19:49, Achilleas Mantzios wrote:
On 21/8/20 7:56 μ.μ., greigwise wrote:
Not sure if this is the right place to post this, but if not someone please
point me in the right direction.
My issue is with pgbouncer 1.14. This does not seem to happen on 1.13.
If I do a service
On 21/8/20 7:56 μ.μ., greigwise wrote:
Not sure if this is the right place to post this, but if not someone please
point me in the right direction.
My issue is with pgbouncer 1.14. This does not seem to happen on 1.13.
If I do a service pgbouncer restart, then anytime I try to connect to
Not sure if this is the right place to post this, but if not someone please
point me in the right direction.
My issue is with pgbouncer 1.14. This does not seem to happen on 1.13.
If I do a service pgbouncer restart, then anytime I try to connect to my
databases via pgbouncer, I get ERROR: no
On 6/11/20 1:47 AM, pgdba pgdba wrote:
Hello ,
When I want to create a logrotate in postgresql, I get this error when I
want to work later. Does anyone have any idea about this error?
logrotate -f /etc/logrotate.conf error after error:
pgbouncer: 1 unknown option 'var' - ignoring
Hello ,
When I want to create a logrotate in postgresql, I get this error when I want
to work later. Does anyone have any idea about this error?
logrotate -f /etc/logrotate.conf error after error:
pgbouncer: 1 unknown option 'var' - ignoring line
error: pgbouncer: 11 unknown unit
I could help! pgbouncer and LDAP is a PITA!
It could be nice if you replied to the list thread just to have an
update on how it goes.
On 18/9/19 11:23 π.μ., Ayub M wrote:
Hi Achilleas, yes got the pam authentication working. I had to create
pgbouncer file in pam directo
Please dont top-post.
On 14/9/19 9:41 π.μ., Ayub M wrote:
Yes I did set that, here is how pgbouncer looks like ---
-rwsrwsr-x. 1 root root 2087504 Sep 13 00:45 pgbouncer
If you had set the same password in the postgresql server for the user and in
the pgbouncer local unix user it should
Yes I did set that, here is how pgbouncer looks like ---
-rwsrwsr-x. 1 root root 2087504 Sep 13 00:45 pgbouncer
On Fri, Sep 13, 2019 at 6:50 AM Achilleas Mantzios <
ach...@matrix.gatewaynet.com> wrote:
> On 13/9/19 10:19 π.μ., Ayub M wrote:
>
> Stumbled in the f
On 13/9/19 10:19 π.μ., Ayub M wrote:
Stumbled in the first step - PAM authentication via pgbouncer. After compiling
pgbouncer with the pam plug-in, I am unable to login into the db - throws PAM
error message. Please help.
User created with the same password as linux user --
localhost:~$ psql
Stumbled in the first step - PAM authentication via pgbouncer. After
compiling pgbouncer with the pam plug-in, I am unable to login into the db
- throws PAM error message. Please help.
User created with the same password as linux user --
localhost:~$ psql -h dbhost -p 3306 -U admin -W db1
db1
;> "Auth-method field: Only methods supported by PgBouncer’s auth_type
>> >> are supported", and "ldap" is not supported.
>> >> When there's no ldap support in pgbouncer, there's no ldap support
>> >> in pgbouncer.
>> >
t; are supported", and "ldap" is not supported.
>> When there's no ldap support in pgbouncer, there's no ldap support
>> in pgbouncer.
> To throw in something less tautological:
>
> PgBouncer supports PAM authentication, so if you are on
le-format
> >> "Auth-method field: Only methods supported by PgBouncer’s auth_type
> >> are supported", and "ldap" is not supported.
> >> When there's no ldap support in pgbouncer, there's no ldap support
> >> in pgbouncer.
> > To
; are supported", and "ldap" is not supported.
> >> When there's no ldap support in pgbouncer, there's no ldap support
> >> in pgbouncer.
> > To throw in something less tautological:
> >
> > PgBouncer supports PAM authentication, so if you are
orted by PgBouncer’s auth_type
are supported", and "ldap" is not supported.
When there's no ldap support in pgbouncer, there's no ldap support
in pgbouncer.
To throw in something less tautological:
PgBouncer supports PAM authentication, so if you are on UNIX,
you could us
pported by PgBouncer’s auth_type
> are supported", and "ldap" is not supported.
> When there's no ldap support in pgbouncer, there's no ldap support
> in pgbouncer.
To throw in something less tautological:
PgBouncer supports PAM authentication, so if you are on
It has hba and via hba file one can specify ldap connections
https://www.postgresql.org/docs/9.3/auth-pg-hba-conf.html
On Mon, Sep 9, 2019, 3:40 AM Christoph Moench-Tegeder
wrote:
> ## Ayub M (hia...@gmail.com):
>
> > Hello, I am trying to setup pgbouncer with ldap to conn
are supported", and "ldap" is not supported.
When there's no ldap support in pgbouncer, there's no ldap support
in pgbouncer.
Regards,
Christoph
--
Spare Space
## Ayub M (hia...@gmail.com):
> Hello, I am trying to setup pgbouncer with ldap to connect with rds
> postgres. Downloaded latest version of pbbouncer (1.11) and using hba
> auth_type. Getting below error when starting pgbouncer daemon. Am I
> missing something?
There's no
Hello, I am trying to setup pgbouncer with ldap to connect with rds
postgres. Downloaded latest version of pbbouncer (1.11) and using hba
auth_type. Getting below error when starting pgbouncer daemon. Am I
missing something?
[centos@ip-x.x.x.x etc]$ pgbouncer -V
PgBouncer version 1.11.0
[centos
helmed by the Azure, too many options there...
You are correct - I could easily create a Linux VM and install Postgres
and pgbouncer there :-)
But how to create the "cloudliness" then? I.e. how to automatically
launch additional VM instances automatically when the load is
increasing?
You are correct - I could easily create a Linux VM and install Postgres and
pgbouncer there :-)
But how to create the "cloudliness" then? I.e. how to automatically launch
additional VM instances automatically when the load is increasing? (and
still keep the database "in sync")
Regards
Alex
On 6/29/19 12:34 AM, Alexander Farber wrote:
Good morning,
in Microsoft Azure how to add pgbouncer or a similar software enabling
multiple simultaneous connections?
Not from within. Supported extensions:
https://docs.microsoft.com/en-us/azure/postgresql/concepts-extensions
Using search
Good morning,
in Microsoft Azure how to add pgbouncer or a similar software enabling
multiple simultaneous connections?
After reading https://docs.microsoft.com/en-us/azure/postgresql/overview I
could not find such options...
Thank you
Alex
On 4/8/19 7:19 AM, Raghavendra Rao J S V wrote:
Thank you very much for your prompt response.
Could you explain other admin type operations, which are not supported
by pgbouncer?
I would say anything you could not run through psql.
Regards,
Raghavendra Rao.
--
Adrian Klaver
adrian.kla
Thank you very much for your prompt response.
Could you explain other admin type operations, which are not supported by
pgbouncer?
Regards,
Raghavendra Rao.
On Mon, 8 Apr 2019 at 19:16, Scot Kreienkamp
wrote:
> Replication and several other admin type operations must connect directly
>
Basically anything that is not written as a sql query should be connected
directly to PG. PGBouncer is really only meant for SQL query type connections.
From: Raghavendra Rao J S V [mailto:raghavendra...@gmail.com]
Sent: Monday, April 8, 2019 10:19 AM
To: Scot Kreienkamp
Cc: pgsql-general
po 8. 4. 2019 v 15:42 odesílatel Raghavendra Rao J S V <
raghavendra...@gmail.com> napsal:
> Hi All,
>
> We are using PGBOUNCER(connection pool mechanisam). PGBOUNCER uses port
> 5433.
>
> Postgres database port number is 6433. By using port 5433 PGBOUNCER is
> conne
Replication and several other admin type operations must connect directly to
PG. They are not supported through PGBouncer.
From: Raghavendra Rao J S V [mailto:raghavendra...@gmail.com]
Sent: Monday, April 8, 2019 9:21 AM
To: pgsql-general@lists.postgresql.org
Subject: Getting error while
Hi All,
We are using PGBOUNCER(connection pool mechanisam). PGBOUNCER uses port
5433.
Postgres database port number is 6433. By using port 5433 PGBOUNCER is
connecting to postgres port 6433 database.
Now PGBOUNCER is establishing the connections properly but when I try to
run the pg_basebackup
and a new
pgbouncer connection is spawn to the database. Alternatively, the client
cannot be served and has to wait.
I hope my example reported here below will clarify the situation:
---
pgbouncer setting:
test_db = host=... dbname=... user=... pool_size=2
[pgbouncer]
pool_mode
> Hello,
> >> I am a bit confused about the settings in pgbouncer
> >>
> >> What's exactly the pool_size?
> >
> > Roughly, the number of open connections pgbouncer will keep to PostgreSQL.
> >
> >> If I set 3, and I tried to connect from 4 s
> If I set 3, and I tried to connect from 4 shells, I am still able to
connect.
That would be the point - pgbouncer is sharing the 3 connections it
keeps with PostgreSQL between the 4 client connections made to it.
Mmh, my pool_mode is per session. The 4 sessions were active, not doing any
qu
David,
Are you sure? The behaviour I experienced is different from what you described.
On 17/01/2019 16:32, David G. Johnston wrote:
> On Thu, Jan 17, 2019 at 8:18 AM Nicola Contu wrote:
>>
>> Hello,
>> I am a bit confused about the settings in pgbouncer
>>
>
On Thu, Jan 17, 2019 at 8:18 AM Nicola Contu wrote:
>
> Hello,
> I am a bit confused about the settings in pgbouncer
>
> What's exactly the pool_size?
Roughly, the number of open connections pgbouncer will keep to PostgreSQL.
> If I set 3, and I tried to connect from 4
Hello,
I am a bit confused about the settings in pgbouncer
What's exactly the pool_size?
If I set 3, and I tried to connect from 4 shells, I am still able to
connect.
Same thing for max_db_connections. I set this to 1 and I am able to connect
from 2 shells.
This is kind of confusing and I&
Contu wrote:
> Hello,
> is this normal? can anyone help?
>
> Thanks a lot for your help in advance.
>
> Nicola
>
> Il giorno mer 10 ott 2018 alle ore 17:03 Nicola Contu <mailto:nicola.co...@gmail.com>> ha scritto:
>
> Hello,
> we are run
If they are visible in pg_stat_activity then yes. Likewise, if they are only
visible in pgbouncer, then no.
The last query being discard all means that PGBouncer has returned the
connection to the pool to make it available to the next client that needs it.
So what you’re seeing sounds to me
1 - 100 of 128 matches
Mail list logo
