Stack Overflow
Stack Overflow

Questions tagged [pgbouncer]

pgbouncer is a lightweight connection pooler for PostgreSQL

pgbouncer is a lightweight connection pooler for PostgreSQL. Its development status is 5 - Production/Stable, available under a BSD License for Windows and POSIX operating systems and is is written in C.

292 questions
0
votes
1 answer

PostgreSQL FDW over pgBouncer drops connection to PostgreSQL

we have a PostgreSQL setup where we directed FDW (Forward Data Wrapper) connection to other databases over pgBouncer. Once we execute the query to FDW schema, connection from FDW to pgBouncer to another PostgreSQL server is opened correctly but once…
khorvat
  • 1,630
  • 2
  • 20
  • 31
0
votes
1 answer

How to manage connection pooling to a database when using multiple compute instances?

I'm pretty familiar with setting up Express servers and running a connection pool on that one instance, usually just a simple VPS which connects to an outside database (AWS RDS). The connection pool on the instance would have near the max…
Jose Valerio
  • 45
  • 5
0
votes
2 answers

PgBouncer and idle connections

I'm trying to scale my infrastructure. There is a Php 7.4 app which uses persistent connections. There is a PgBouncer which the app connects to with the default parameters. /pgbouncer.ini [databases] XXXXXXX [pgbouncer] listen_addr =…
NathanVss
  • 634
  • 5
  • 16
0
votes
0 answers

TLS1.3 is being communicated even if TLS1.2 is specified in ini file pgbouncer

I specify the configuration as TLSv1.2 and it still resorts to TLSv1.3. The configurations are listed below. server_tls_protocols = tlsv1.2 server_tls_sslmode = verify-ca Log: SSL established: TLSv1.3/TLS_AES_256_GCM_SHA384/ECDH=prime256v1 I get…
scarvish
  • 58
  • 1
  • 7
0
votes
1 answer

Is it advisable to call script after user creation in relational database?

I need to add users to pgbouncer dynamically when users are created in postgres. Is it advisable to use triggers to invoke shell script which add entry in userslist.txt of pgbouncer on pg_catalog.authid insertion event or call shell scrip directly…
preethi
  • 59
  • 1
  • 2
  • 7
0
votes
0 answers

PgBouncer with spring boot and postgres

I researched for spring boot, PostgreSQL and pgbouncer example and cannot find anywhere. Do you know can we integrate pgbouncer with spring javax.sql.DataSource? Can you share with me any page that can I take reference. When I look to Pgbouncer page…
Muhammed şahsuvaroğlu
  • 479
  • 2
  • 7
  • 20
0
votes
0 answers

How to use Django with PGBouncer?

I have an application launched in Django, which has a very high traffic of requests and queries to the databases. I am having problems and I have read that with PGBouncer and some settings in Django I can solve the problem. The question is how to…
Jeisson Manrique
  • 1
0
votes
1 answer

Problem when socket_setup call fcntl(sock, F_SETFD, FD_CLOEXEC)

I try to make pgbouncer in windows They have usual library (libusual) for work with ip-sokets. When pgbouncer tune socket, it calls socket_setup from usual library socket_setup call res = fcntl(sock, F_SETFD, FD_CLOEXEC); and res is -1 now. How…
Adel Chepkunov
  • 79
  • 1
  • 9
0
votes
1 answer

Unable to connect to PgBouncer admin console

I'm unable to connect to my PgBouncer admin console. Below is my pgbouncer.ini configuration. ################## Auto generated ################## [databases] * = host=postgresql.default.svc.cluster.local port=5432…
Souvik Dey
  • 653
  • 1
  • 9
  • 18
0
votes
1 answer

PostgreSQL hangs on 'rollback transaction' with serializable transaction?

We have a web service where all user facing read/write transactions are executed with isolation level SERIALIZABLE. However, we have been having problems where the transaction length of some connections goes through the roof and it seems that in…
Mikko Rantalainen
  • 14,132
  • 10
  • 74
  • 112
0
votes
1 answer

PgBouncer too many client connections for select()

I have created PostgreSql v12(port 5432) and pgbouncer v1.9(port 6432). Then I have created a new test database on the pgbouncer server. I followed these steps: pgbench -h localhost -p 6432 -U postgres -i -s 150 test it has created pgbench…
Onur Bostancıoğlu
  • 3
  • 4
0
votes
1 answer

PgBouncer transaction mode does not support prepared-statements even with prepareThreshold=0

I am using PgBouncer in "transaction" mode for connection pooling. Our code already have PreparedStatements used at multiple places. Even though FAQ on PgBouncer…
Alok Bhandari
  • 41
  • 1
  • 3
0
votes
1 answer

pgbouncer - could not connect to server: Address already in use (0x00002740/10048)

I have an app using libpq to connect to postgresql server and using pgbouncer as connection pool if (pconn == nullptr) { pconn = PQconnectdb(chrConnectStr); } if (PQstatus(pconn) == CONNECTION_BAD) { //If it fails, try…
Ryo
  • 995
  • 2
  • 25
  • 41
0
votes
1 answer

PgBouncer in Ruby on Rails app and advisory locks

I've been using advisory locks extensively in multiple apps and now, am looking into introducing a connection pooler due to the huge number of DB connections. I'm considering pgbouncer with transaction pool_mode and from the initial research, not…
karol.galanciak
  • 51
  • 1
  • 4
0
votes
1 answer

pgbouncer does not start with ldap

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]$…
nmakb
  • 1,069
  • 1
  • 17
  • 35
1 2 3
…
19 20