Questions tagged [pgbouncer]
For questions about PgBouncer, a connection pooler for PostgreSQL.
85 questions
0
votes
0
answers
48
views
Fast query got "cancelling statement" on replica
I'll say in advance that I've seen similar questions on this topic, but I just couldn't find an answer because they concerned long queries, while mine, on the contrary, executes the query in less than ...
- 101
0
votes
0
answers
40
views
Prepared statements not working with Psycopg3 + PgBouncer (transaction pooling)
I'm running into unexpected behavior when trying to use prepared statements with TimescaleDB through PgBouncer in transaction pooling mode.
According to the Psycopg3 docs on prepared statements and ...
- 1
0
votes
0
answers
128
views
Pgbouncer Certificate Users Error with Scram SHA-256
While the connection method is “md5”, I can manage pgbouncer connections with two different connection methods: users connected with certificate and users connected with password.
Postgresql Version:
...
1
vote
0
answers
120
views
Acquiring conneciton from pgxpool takes longer with PGBouncer
My web server is deployed on Kubernetes with horizontal pod scaling and a separate, non auto-scaling, PostgreSQL service which runs a both a master and readonly replica nodes, with high-availability ...
- 229
0
votes
0
answers
405
views
I keep getting asyncpg.exceptions.ConnectionDoesNotExistError: connection was closed in the middle of operation in my Sqlalchemy application
I have SQLAlchemy setup with pgbouncer, my pgboucer is configured to use session mode and my sqlalchemy engine config is as follows:
engine = create_async_engine(
url=db_url,
echo=False,
...
- 3
0
votes
2
answers
99
views
Remove application pool when installer PgBouncer?
We have 2 applications with ~10 instances of each.
All these instances are connected to the same Postgres database.
The applications uses a client pool (some applicative ORM providing a connection ...
- 291
0
votes
1
answer
87
views
Transaction query runs for days in PostgreSQL with PGBouncer
I'm running a PostgreSQL cluster with PGBouncer and very often I see in pg_stat_activity that an app is connected to the database and stays in "idle in transaction" state for days. Obviously,...
- 101
0
votes
1
answer
125
views
Pgbouncer: Can pgbouncer take reserve_pool_timeout in milliseconds?
Is it possible to specify pgbouncer reserve_pool_timeout in milliseconds, I have tried specifying it with '500 ms' but throwing an error and then tried specifying 0.5, this time no error but unable ...
- 700
0
votes
0
answers
142
views
Installing pgBouncer for postgres 14
Please note: I'm still learning a lot of things about postgres. I'm asking for advice to install pgBouncer, but if you have any better suggestions what I could do, please tell me.
I have a nodejs ...
- 141
0
votes
0
answers
372
views
Pgbouncer: got packet 'E' from server when not linked
Does anyone knows what this error below means? We running pgbouncer 1.21 on centos using transaction pooling mode.
2024-04-29 15:00:02.378 CST [9680] WARNING S-0x197b028: db/[email protected]:5432 got ...
- 700
0
votes
1
answer
207
views
PostgreSQL: Database Layer Pooling v/s Application Layer pooling
I would like to have some recommendations about connection pooling in PostgreSQL. We already have connection pooling using Pgbouncer behind an Azure LB. The pgbouncer itself is working pretty much ...
- 700
0
votes
1
answer
877
views
pooler error: query_wait_timeout in pgbouncer logs
I am getting pooler error: query_wait_timeout for different databases in the pgbouncer log 6 to 7 times a day . When the error occurs for masterdata database , it gives me a timeout in the ...
0
votes
2
answers
3k
views
PostgreSQL: Pgbouncer authentication
We are using authentication file mode in pgbouncer. The authentication part of Pgbouncer is so confusing. Would be helpful if anybody can throw some light on my below queries.
Are Pgbouncer ...
- 700
0
votes
1
answer
139
views
How to add information about two same named databases on different hosts in PgBouncer config file?
I want to add details for databases in a config file of pgbouncer.
I have two same database names but their hosts are different, as there is no information about server endpoints in the config file, ...
0
votes
0
answers
75
views
How to configure database specific settings with PgBouncer?
We have a server running multiple services and we would want to use pretty short client_idle_timeout for one backend database and unlimited client_idle_timeout for another backend database. However, ...
- 1,119