326 questions
0
votes
1
answer
212
views
Celery crashes when PgBouncer closes idle connections (idle timeouts enabled) [duplicate]
I’m encountering an issue when running Celery with PgBouncer and PostgreSQL after enabling idle connection timeouts.
My stack includes:
Django (served via Tornado)
Celery (workers + beat)
...
- 43
2
votes
1
answer
177
views
Using pg_try_advisory_xact_lock for events processing with strict ordering
Suppose I am implementing a local Event-Driven service with internal events to decouple logic.
For database we use Postgres 17 and PgBouncer with transactional mode. It's just a single instance.
...
0
votes
0
answers
61
views
apache airflow client connections are failing to connect to pgbouncer sporadically
We are facing occassional errors while airflow workers and scheduler connecting to pgbouncer. We have tried using external postgres server and bitnami postgres available from airflow helm chart, in ...
- 125
0
votes
0
answers
120
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
2
votes
2
answers
43
views
using custom trigram similarities with Django, Postgres and PgBouncer
I want to adjust pg_trgm.similarity_threshold on some of my queries. But since I'm using PgBouncer (in transaction pooling mode) to mediate access to my Postgres database, I want to be sure that when ...
- 10.5k
0
votes
0
answers
53
views
Heroku installs extra Python package
I have a Python/Django app which uses Pipfile and Pipfile.lock running on Heroku-22 stack with classic buildpacks.
requirements.txt is not part of the code base, thus e.g. Heroku: ModuleNotFoundError :...
- 10k
0
votes
1
answer
79
views
Relation does not exist When using Hibernate EntityManager.createNativeQuery() and PgBouncer
I'm quite new to Postgres and PgBouncer as well, not a complete newbie, but still lacking experience.
I'm using Postgres + PgBouncer, spring and hibernate as tech stack.
We have multiple microservices ...
0
votes
0
answers
322
views
Why is max_prepared_statements = 1 allowing multiple prepared statements in PgBouncer?
I set max_prepared_statements = 1 in PgBouncer and attempted to create multiple prepared statements within a single transaction.
Expected Behavior:
PgBouncer should either prevent more than one ...
- 41
3
votes
1
answer
373
views
Intermittent Pooler Error in django app server
facing intermittent Pooler Error: server conn crashed? in my http server. Tried searching and fixing long running transaction in my system but didn't help. Also this happens very randomly at any point ...
- 567
1
vote
1
answer
540
views
My database connection closes in middle of operations
I am running FastApi with SQlAlchemy and PGBouncer, I keep getting asyncpg.exceptions.ConnectionDoesNotExistError: connection was closed in the middle of operation. This happens randomly and I have ...
- 138
0
votes
0
answers
299
views
received unencrypted data after SSL request while ssl is off
Our upstream Go client connect to PostgreSQL through pgbouncer, the PostgreSQL server has not enabled SSL. There are no SSL settings set in pgbouncer, and according to the documentation, the default ...
2
votes
0
answers
438
views
Setting up PgBouncer with Google Compute Engine and Cloud SQL PostgreSQL: Security Concerns, Multiple Databases, and User Management
I am working on setting up PgBouncer on Google Compute Engine (GCE) instances to manage connections to a Cloud SQL PostgreSQL database. My setup involves multiple databases hosted on the same Cloud ...
2
votes
1
answer
324
views
Using Doctrine ORM with Postgres and PGBounder connection pooling
Does anybody have experience of configuring Doctrine ORM against a Postgres DB with PGBouncer connection pooling? We use a Digital Ocean managed Postgres database, and are permitted 22 concurrent DB ...
- 225
1
vote
0
answers
97
views
My pgbouncer on docker container is not working properly
I have running containers and they are working properly. But for some reason, the requests are not distributed to pgbouncerc.
After command "docker logs " I am getting this output though I ...
- 13
0
votes
1
answer
342
views
pgbouncer trust authentication failed
I am trying to create a spring application that connects to a postgresql database. The application works fine when connecting to the db directly but when I try to connect to it through pgbouncer the ...
