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

How do I analyze what is hanging my Flask application

I have a Python Flask web application, which uses a Postgresql database. When I put a load on my application, it stops to respond. This only happens when I request pages which uses the database. My setup: nginx frontend (although in my test…
doekman
  • 18,750
  • 20
  • 65
  • 86
0
votes
1 answer

Correct usage sqlalchemy pools with pgbouncer

there! I use PgBouncer with Sqlalchemy for getting connections. For my understanding, I would like to clarify the following points: I use the sqlalchemy default pool (QueuePool) and take connections from my pgbouncer. After the transaction is…
SmokyICE
  • 63
  • 1
  • 6
0
votes
0 answers

Postgres 11. Authentication using pg_bouncer + kerberos

We've got Postgres 11 server and Kerberos authentication. My teammates asked to find out if we can also use pg_bouncer with Kerberos. Does anyone use with combination (Kerberos + pg_bouncer). Or where can I find settings?
Gerzzog
  • 95
  • 7
0
votes
0 answers

TLS/SSL in pgbouncer - FATAL TLS setup failed: failed to load CA

I'm trying to set up pgbouncer to require a TLS/SSL connection from the applications connecting to it, but it throws an error "FATAL TLS setup failed: failed to load CA" This is my pgbouncer.ini: [databases] * = host=${postgres_host} port=5432 …
Domenico
  • 1
0
votes
1 answer

knexfile settings when using PgBouncer

We have a setup where multiple Node processes write into the same database (different tables), and as a result, when using Knex, we end up with more connections to the database than desirable. So, I was thinking of using PgBouncer as a middleware…
ankush981
  • 5,159
  • 8
  • 51
  • 96
0
votes
1 answer

How to understand pg-bouncer is working properly with postgres?

I have already configured one of our server with pg-bouncer.pg-bouncer is listening to 6432 port and postgres is listening to 5432 port. Using like below command I can access pg-bouncer which is giving proxy to postgres 5432 port. psql -p 6432 -U…
Shahariar Ashik
  • 1
  • 2
0
votes
1 answer

PgBouncer - Server DNS lookup failed

I am trying to test PgBouncer connection with pgbench on a PostgreSQL server. But I'm getting error as closing because: server DNS lookup failed and at pgbench getting this message: pgbench -c 10 -t 10 -C -f…
yugck
  • 11
  • 3
0
votes
0 answers

does primary postgres need open ACLs to secondary when connections come through midware

I want to setup postgres replication, we had a midware called pgbouncer -- which handles connection and read/write requests. so for primary pgsql we have connections allows pgbouncer to connect, pgbouncer allows secondary postgres to connect, do i…
Siki shen
  • 53
  • 1
  • 4
0
votes
0 answers

high percentage of network I/O in Dynatrace when using pgbouncer with Postgres 12

We are running some tests in Google Cloud and we are using CloudSQL Postgres 12 with cloudsqlproxy and pgbouncer. [x ] bug report Describe the issue When we run tests in Google cloud using K8s and CloudSQL Postgres 12 with cloudsql authproxy and…
iamtulipin
  • 1
  • 1
0
votes
0 answers

Does pgBouncer support different auth mechanisms for client and server?

Is it possible to have trust based authentication from client to pgbouncer (1.17.0) and certificate authentication from pgbouncer to postgres (14) server in a system?
Aaak
  • 1
  • 1
0
votes
0 answers

certificate based auth from client to pgbouncer failure

we are facing an issue with enabling cert based authentication between client and pgbouncer 1.17.0. Pgbouncer 1.17.0 and postgresql 14 are on the same host in different containers. There is TLS enabled between client and pgbouncer. The issue is…
Aaak
  • 1
  • 1
0
votes
1 answer

PgBouncer configure auth_user without plain text password

I am working on configuration of pgBouncer and I was able to make it work with auth_query. Is it possible to somehow encrypt password for auth_user? Initially I tried to use SCRAM hash but then connections would fail. I've read that md5 is possible,…
gluetornado
  • 35
  • 5
0
votes
0 answers

Containerized repmgr with pgbouncer

I am using docker containers bitnami/postgresql-repmgr:13.3.0-debian-10-r22 in order to enable automatic failover for PostgreSql (I have 2 containers on 2 servers, one is the primary, the other a standby). Our application (using springboot) is using…
Tamar
  • 145
  • 4
  • 15
0
votes
0 answers

Terraform issue in deleting server parameter Postgresql flexi server

Getting error:waiting for deletion of Flexible Server Configuration (pgbouncer.enabled) Once I change the configuration from portal the script works. azurerm_postgresql_flexible_server_configuration" "pgbouncer" { name = "pgbouncer.enabled" value…
Askandsolve
  • 1
  • 1
0
votes
2 answers

Is Spring Integration transaction isolation serialized required or can I also use read committed?

I using spring integration with JdbcChannelMessageStore backed up with postgres using pgbouncer. I have multiple jvms running, and got: Could not serialize access due to concurrent delete (or update) Is this a problem? Can/should I switch to read…
wdk
  • 373
  • 2
  • 8
1 2 3
…
19 20