337 questions
0
votes
0
answers
18
views
Using pgBouncer on DigitalOcean with Node.js pg Pool and Kysely – Can They Coexist?
I'm running a Node.js application that connects to my PostgreSQL database using Kysely and the pg Pool. Here's the snippet of my current DB connection logic.
I have deployed my database on ...
- 1,081
0
votes
1
answer
27
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
17
views
Why is PgBouncer v1.21 Assigning Different Names to the Same Prepared Statement?
I'm trying to use prepared statements with PgBouncer v1.21 in transaction mode for PostgreSQL 14.3. While enabling prepared statements via PgBouncer, I followed this blog and used the sample code ...
- 21
0
votes
0
answers
60
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 ...
- 21
0
votes
1
answer
151
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 ...
- 828
0
votes
0
answers
80
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 ...
- 128
0
votes
0
answers
84
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
104
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
54
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 ...
- 205
0
votes
0
answers
92
views
How to configure postgres / pgbouncer in a serverless environment
i read several articles/posts but for me it is not very clear what is important for the configuration of a selfhosted postgres + pgbouncer when using a serverless approach for the application itself.
...
- 53
1
vote
0
answers
62
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
161
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 ...
1
vote
0
answers
114
views
Pgbouncer Sidecar: Addressing connection pooling and load balancing issues
I'm currently using TypeORM with RDS Aurora PostgreSQL, and I'm considering introducing PgBouncer to address the following two issues:
The node-postgres library used by TypeORM doesn't support the ...
- 11
0
votes
0
answers
26
views
connect to admin panel PGBOUNCER from odbc
For monitoring from zabbix via ODBC (I don’t want to install an agent on the server). I want to connect to the pgbouncer admin panel from ODBC. I can easily connect to any database except the special ...
- 99
1
vote
0
answers
168
views
Production SQLX and PgBouncer's Prepared Statement Issue
In production i got multiple SQL Servers where i have to use connection pooler like pgbouncer and i got high traffic so i am thinking of transaction mode.
In pgbouncer i changed the number of allowed ...
- 257
0
votes
1
answer
399
views
Problem with PgBouncer auth method not same type
I have some issues with the auth method in PgBouncer and Postgresql.
Error:
2024-09-28 10:49:28.750 UTC [120] LOG process up: PgBouncer 1.23.1, libevent 2.1.12-stable (epoll), adns: evdns2, tls: ...
- 135
0
votes
0
answers
24
views
dns resolution not updating on changes
I have a database set to connect to a host, say, example.test.com. That domain is configured through AWS Route 53 as a failover configuration such that when the health check is positive it points to ...
- 1,677
0
votes
1
answer
39
views
PGbouncer locking template1
I have pgbouncer setup in front of 3 postgresql servers. Everything is running fine and pgbouncer is handling the pools. However, when I go to create a database, I get an error that template1 is in ...
- 723
0
votes
0
answers
52
views
Can I configure multiple timeouts for pgbouncer from my django settings?
I am trying to add pgbouncer to my architecture. I know that I can set various pgbouncer configuration settings in the pgbouncer.ini file. I want to replace postgresql with pgbouncer in my django ...
- 13
1
vote
1
answer
446
views
Prisma with postgresql + pgbouncer connection limit
I'm deploying a service that uses Prisma with postgresql and pgbouncer. What I would like to know is what to set the Prisma's connection_limit url parameter to, given that my database supports only 22 ...
- 1,607
0
votes
0
answers
84
views
Pgbouncer: Transactions not committed
We are building a multi-tenant spring boot application with pgbouncer as the middleware connection pooler and PostgreSQL as our database. We are facing an issue with pgbouncer( specifically bitnami ...
0
votes
0
answers
395
views
Authentication problem with Auth Query - PGBouncer
I am using PG Version 14.3 and Bouncer 1.20v. I am trying to use auth query for authentication and connection via bouncer. I created a auth user as 'pgbouncer' and it's password is encrypted as scram-...
- 21
1
vote
0
answers
197
views
Vercel serverless functions timing out after X amount of time due to DB connections
Logs on Vercel are overflowing with errors ("Task timed out after 15.02 seconds"). About 2k per hour.
To give you an understanding of the architecture, I host a Next.js 14 app on Vercel (pro ...
- 611
0
votes
0
answers
442
views
port 6432 failed: FATAL: SASL authentication failed
I am a beginner in postgresql. I want to manage connections to my postgresql database using pgbouncer. I have done all the necessary configuration but I get this error:
**psql: error: connection to ...
0
votes
1
answer
1k
views
why am I getting "FATAL: bouncer config error" on wrong username?
I'm trying to set up simple authentication with pgbouncer using scram-sha-256.
Here is my pgbouncer.ini:
[databases]
* = host=localhost port=5432 auth_user=pgbouncer
[pgbouncer]
listen_port = 6432
...
- 25
0
votes
0
answers
166
views
Attempt to connect to the read replica via pgbouncer intermittent failure
We’re encountering an issue with the Read Replica setup in Open Telecom Cloud, which is somewhat similar to AWS but with fewer features. We’re seeking any insights into potential causes of this ...
- 675
0
votes
0
answers
84
views
TLS setup failed: failed to load certificate file "/etc/letsencrypt/live/domain.se/fullchain.pem": (null)
I have a client with ssl=require
I have PgBouncer pgbouncer.ini
# SSL/TLS configuration for client connections
client_tls_sslmode = require
client_tls_key_file = /etc/letsencrypt/live/domain.se/...
- 2,238
1
vote
0
answers
205
views
Maximize database pooler TPS
I'm trying to maximize pooler and DB resources to ensure highest throughput.
Specs:
Postgres DB: 8CPUs 64GB Memory
VM for PGbouncer: 16CPU 64GB Memory
Both servers are on the same location.
As I'm ...
- 1,471
0
votes
1
answer
77
views
WARNING server login failed: FATAL Peer authentication failed for user
I am using PgBouncer. Main concept is to authenticate connections only at PgBouncer side and trust between PgBouncer <-> PostgreSQL connections. My pg_hba.conf:
local all all trust
My pgbouncer....
- 29
1
vote
0
answers
82
views
PgBouncer - Trying to connect to ipv6 localhost
I have postgresql 12 and pgboucner 1.22-1. I am getting the following warning message in pgbouncer.log constantly:
WARNING sbuf_connect failed to connect to [::1]:5432: No route to host
I have in ...
- 301
0
votes
1
answer
386
views
How can I resolve "Segmentation Fault" in PostgreSQL with pgbouncer?
I installed and configured pgbouncer, but when I enter the psql command, a segmentation fault error occurs.
[postgres@test:/pgdata/pg-15/data]$ psql -U [myusername] -h localhost -d pgbouncer -p 6432
...
0
votes
0
answers
287
views
Spring boot 3.x version not able to clear the stale connections, giving error"org.postgressql.util.PSQLException :This connection has been closed"
Currently I have developed a microservice using the latest spring boot version ( 3.2.4/3.3 ) with JDK 21 which is connecting to the database ( PostGreSQL ) and used JPA Repository to run the prepared ...
- 1
0
votes
0
answers
266
views
Pgbouncer Server Connection Crashed Error
Pgbouncer returns this error frequently on many of my database connections. I can't figure out what exactly is causing this error.
2024-06-12 13:02:23.005 +03 [2865569] LOG C-0x56059d2f0410: db_name/...
0
votes
0
answers
72
views
CPU jumps vs Single threaded process
We have bee running Pgbouncer instance on centos7 for PostgreSQL connection pooling. Recently after routing some connections through pgbouncer we have been noticing high CPU jumps associated with ...
- 194
0
votes
0
answers
227
views
How to connect with pgbouncer using typeorm client?
We are using pgbouncer for connection pooling for our postgres database.
How do we connect it with typeorm client.
I couldnot find any documentation related to this.
I am not able to find any relevant ...
3
votes
1
answer
960
views
How to implement a connection pool on Cloud Run and Cloud SQL
I have an application running within the Cloud Run infrastructure. It was built with FastAPI and SQLAlchemy. The database is a Postgres, managed by Cloud SQL.
At a certain point, the database alerts ...
- 8,374
0
votes
0
answers
39
views
Partitions are getting repeated in spring batch
I am using partition in spring batch and pgbouncer (Connection pooler for postgre) and I am creating the Partition in my code using following code -
public Map<String, ExecutionContext> ...
- 23
0
votes
0
answers
368
views
Postgresql - Pgbouncer Connection and Query Performance Problem
We are using prepared transactions in PostgreSQL.
We use pgbouncer as our pooling software. From time to time, I encountered connection issues in my database sessions, and to resolve them, I had to ...
0
votes
1
answer
973
views
Can login with Pgbouncer but cannot access any database
I am trying to configure pgbouncer as connection pooler for my postgres instances. For my use case I tried to work with auth_query authentication method to let users connect to postgres instances ...
- 377
0
votes
0
answers
98
views
How to create a global function for a PostgreSQL instance
I have a use case where I want to create a function which i can use on every database available on my PostgreSQL instance so I can give execute grant to a non-super user.
Task of this function would ...
- 377
0
votes
0
answers
256
views
Failed to connect to docker container running Postgres via pgbouncer
Trying to create connection pool using pgbouncer. Here is the docker-compose.yml file.
version: '3'
services:
db:
image: postgres:12
volumes:
- pg_data:/var/lib/postgresql/data
-...
- 2,649
0
votes
0
answers
88
views
How to Install PgBouncer as a software if possible
I want to use Pgbouncer on my windows machine. Is there any way so that I can download it as a software and simply provide it's URL in place of my DB url in Quarkus and spring boot application or how ...
- 23
0
votes
0
answers
86
views
I am facing problem in connection pgbouncer with postgresql in django
for the configuration of pgbouncer with postgresql in pgbouncer.ini file i have done
mydb= dbname=mydb host=**.**.**.** port=5432
listen_addr = *
listen_port = 6432
unix_socket_dir = /var/run/...
0
votes
0
answers
165
views
Retry connection in case of pgbouncer client login timeout error for gevent celery worker
Platform: GNU/Linux
Celery, gevent(24.2.1), sqlalchemy, psycogreen, psycopg2, pgbouncer, postgresql
I am getting occasional client login timeout error in celery workers, which works fine after retries....
0
votes
1
answer
201
views
PgBouncer keep so much connections with auth_user
I am using PgBouncer with Postgresql.
Besides connections from users. PgBouncer still keeps so much connections from auth_user.
These connections have no other information than query infomation: ...
- 21
0
votes
1
answer
145
views
Why Posgresql give 30% connections for auth_user of PgBouncer
I have a problem with Postgresql use PgBouncer Pool
I have 40 DB
My app just use 1 user to connect to DB (userA). But when I query pg_stat_activiy, I found about 230 connections idle from user with ...
- 21
0
votes
2
answers
1k
views
pgbouncer login failed no such database
Currently having a problem with my pgbouncer setup.
I am using pgbouncer with Odoo and Odoo requires connecting to postgres database for framework purposes.
Below is the log I received from pgbouncer. ...
- 4,174
0
votes
1
answer
343
views
SSL Mode=Require causes an error in Npgsql when connecting to pgBouncer
I have an old application which uses Npgsql Version 4.1.12
I am connecting to an Azure database which requires an SSL connection.
I can connect to the database using the string:
Server=xxxxx.postgres....
- 438
3
votes
1
answer
630
views
Using a temp PostgreSQL table in a connection from pgbouncer pool
I want to create temp PostgreSQL table each time on client http request to my Rails 7.1 server or in per one background sidekiq job.
I have active record connection to my postgresql 15 database ...
- 61
0
votes
2
answers
431
views
PgBouncer peer & host authentication for the same database
I have a PgBouncer installed on the same host with postgres server and I have several scenarios for it:
Monitoring(pgwatch2) should connect with peer authentication to the postgres(for example) ...
- 35