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
6
votes
0 answers

Can't connect to database through pgbouncer from a remote place

I'm developing .net application with connection to postgresql (npgsql). Due to a large amount of idle connections (npgsql can't terminate it) I had to install pgbouncer. I wrote a config file and set an auth_user_file. pgbouncer…
user3044984
  • 71
  • 3
6
votes
1 answer

How to get PGBouncer auto start on reboot on Linux?

On Ubuntu 12.04 (precise) in a Windows Azure VM I have postgres and pgbouncer running on the same machine. Everything is setup and works however when the VM is rebooted pgbouncer doesn't automatically startup. How do I make it so that it starts on…
thames
  • 5,833
  • 6
  • 38
  • 45
5
votes
1 answer

"No such database" error on pgAdmin when connecting through pgbouncer

I have configured pgbouncer on server A(port 6432, host addr: 10.XX.XX.92) that will accept the connections for postgres server running on server B(port 5433, host addr:10.XX.XX.90). This postgres server has 2 databases.(postgres and db1) I have 2…
Esha
  • 63
  • 1
  • 3
5
votes
1 answer

Do I realy need Idle Connection in Postgres?

I have a project in Spring Boot (1.5.1.RELEASE) which is using Postgres DB (9.1-901-1). While I am running this application in production it will create upto 100 number of Idle connection in DB. So I override the default configuration to control…
Satz
  • 307
  • 3
  • 19
5
votes
1 answer

connect_query setting in PGBouncer + JDBC

I'm configuring PGBouncer as the database connection pool for my application. I'm also using it with the session pool mode. Due to some application requirements I need to keep a temporary table during the usage of each connection. What I'm currently…
caristu
  • 115
  • 1
  • 5
5
votes
1 answer

Advantage of PgBouncer with WildFly/Application Server connection pool?

Many application servers have connection pools integrated, and even standalone applications can be configured for use one like HikariCP, Apache DBCP, etc. So what is the advantage of using PgBouncer when the application already have a connection…
JorSol
  • 450
  • 1
  • 4
  • 14
5
votes
1 answer

Pgbouncer log shows only 0 req/s

It's my first stackoverflow post so I wanted so say hi! ;) I have question regarding pgbouncer. I just started using that together with my django app and postgres. I though everything is set up correctly, but I get only such information in log: "LOG…
StarTrekFan
  • 73
  • 4
5
votes
1 answer

explaining pgbouncer log entries in django project

I'm using pgbouncer in a Django web app of mine. The application server and the database server are two separate VMs. pgbouncer is installed on the application server. Pertinent settings in pgbouncer.ini are: [databases] dbname = host=80.211.128.113…
Hassan Baig
  • 15,055
  • 27
  • 102
  • 205
5
votes
2 answers

Golang - pgbouncer and transaction usage

Tech Detail go version 1.2 postrgres library for go bmizerany/pq This issue is driving me mad and I'm hoping someone will be able to help. I have developed an application in golang to read data from a postgres database and for each record make an…
nathj07
  • 685
  • 1
  • 11
  • 23
4
votes
1 answer

Connecting to postgres on supabase via pgBouncer from prisma

Problem running out of database connections in prod leading to errors like this; Error: Invalid `prisma.queryRaw()` invocation: Timed out fetching a new connection from the connection pool. More info: http://pris.ly/d/connection-pool (Current…
sauntimo
  • 1,531
  • 1
  • 17
  • 28
4
votes
0 answers

Pool Cloud SQL PostgreSQL connections using PgBouncer

We are new to Google Cloud SQL and have been trying to integrate pgbouncer with Google Cloud SQl Postgres and authenticate database users with SECURITY DEFINER function (which queries pg_shadow) Our Configuration: Server -> Pgbouncer + Cloud sql…
Devesh Poojari
  • 53
  • 1
  • 8
4
votes
1 answer

PGBouncer IDLE Connections not Closing on Postgres

We have a setup where we are running 6 PgBouncer processes and our performance benchmarks degrade linearly with time. The longer PgBouncer has been running, the longer the connections to Postgres exist results in slower response times for the…
user1442883
  • 73
  • 1
  • 6
4
votes
1 answer

Rails PgBouncer client_idle_timeout

my problem is a pgbouncer which is dropping connections. Sysadmin set the client_idle_timeout to 60 seconds. Is there any solve on rails side for this? I mean, is there a possibility (a gem, or settings) to connect and drop connection…
mbruszewski
  • 41
  • 2
4
votes
1 answer

What causes pgbouncer's avg_wait_time to be > 0?

The docs describe avg_wait_time as: Time spent by clients waiting for a server in microseconds (average per second). We see occasional spikes in avg_wait_time (normally it's 0). During those spikes, best I can tell, there are available/idle…
Mark Fletcher
  • 701
  • 1
  • 14
  • 36
4
votes
1 answer

Successfully connecting postgreSQL 9.6.5 to pgbouncer 1.7.2

Question: I'm struggling to connect pgbouncer 1.7.2 to an operational postgresql 9.6.5 database (Django/Python web app, Ubuntu 14.04 OS). Can you help me troubleshoot this? Background: PostgreSQL is working perfectly without pgbouncer. I'm using…
Hassan Baig
  • 15,055
  • 27
  • 102
  • 205
1 2
3
…
19 20