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

PDO throws connection error about "trust" authentication when using pgbouncer for one database, but not another. Settings are identical

This problem is driving me batty. I have a PHP script which connects to a postgresql database, and I have pgbouncer running for connection pooling. I've tested it using two databases, and it works just fine for both when I connect directly. Here is…
cazort
  • 516
  • 6
  • 19
0
votes
1 answer

Does Pgbouncer answer to kill command?

I have configured Pgbouncer as a sidecar pattern in one of my pods in Azure Kubernetes based on Azure Oss Db Tools Pgbouncer Sidecar documentation. It has the following container lifecycle hook: lifecycle: preStop: exec: command:…
Eranga Heshan
  • 5,133
  • 4
  • 25
  • 48
0
votes
1 answer

why does connection pooling slow down the sql queries in flask

Connection pooling is supposed to improve the throughput of postgres or at least this is what everyone says when googling what is pooling and its benefits, however whenever I experiment with connection pooling in flask the result is always that it…
Antony
  • 263
  • 1
  • 2
  • 5
0
votes
0 answers

How improve postgres / pgbouncer performance

I have a server with postgresql database and pgbouncer connexion pooler. I testing with jmeter my server with different settings of pgbouncer and I managed to execute 5000 "simultaneous" requests without having any error. This result is good for…
mmmmmmm
  • 67
  • 1
  • 7
0
votes
1 answer

pgbouncer throws Pooler Error: Auth Failed when using datagrip but NOT when using pgadmin

I have a postgres database (version 9.2) running on Centos 6.9. I am running pgbouncer version 1.6.1 When I try connect to postgres using datagrip from my Mac, I get: 08P01: Error: Auth Failed And I get on the…
Mamun
  • 2,322
  • 4
  • 27
  • 41
0
votes
1 answer

Postgres Connection drops after 15 mins of idleness

We have a java application that uses Postgres v11 along with PgBouncer for connection pooling. When we keep the application idle for 15 mins, the connection drops(JDBC). The database is hosted on Amazon AWS The same is observed in Pgadmin. We tried…
Rawfodog
  • 13
  • 4
0
votes
0 answers

pgbouncer doens't keep server connections opened

I recently installed a Pgbouncer because our database received lots of connexions. (web / api activities). The problem is : apparently, the pgb doesn't keep opened connexions in his pool to reuse them after. I think this is what's happen because…
Enialis
  • 173
  • 1
  • 9
0
votes
1 answer

How to install multiple PG Bouncers in single servers with different pool_mode

How can we Install multiple PG bouncer with different pool mode on a single server(Ubuntu18.04)? when I tried to second time install it says already installed? Is there any other way to install with a different port?
nikhil raj
  • 55
  • 1
  • 10
0
votes
1 answer

Pgbouncer graceful termination quits with dropped inserts

We have a Postgres and PgBouncer setup and use SIGINT for graceful termination based on the pgbouncer docs: SIGINT Safe shutdown. Same as issuing PAUSE and SHUTDOWN on the console. The pre stop hook script looks like this: kill -INT 1; sleep…
wwang
  • 59
  • 3
0
votes
1 answer

Confusion with default_pool_size and max_connection on PgBouncer

I have a single database and user pair with following configuration. I am confused when setting up default pool size for the pgbouncer. Can anyone explain what its about ? I have 300 max_connection set for database. Core count is 0 as its shared cpu…
Mr.A.N
  • 31
  • 7
0
votes
1 answer

Is server side pooling necessary for Sequlize pool to work?

I have a nodejs application and I am using sequelize as ORM with Postgres. As explained in documentation of sequelize, here is my code for pooling. const sequelize = new Sequelize(/* ... */, { // ... pool: { max: 10, min: 0, acquire:…
Nazim
  • 209
  • 5
  • 17
0
votes
0 answers

Cannot execute update in a read only transaction

As a database we use PostgreSQL. Application uses spring libraries, and transaction is managed by spring. Transactional annotation is used correctly, where it is needed as read-only, and where it is used with write abilities. But in logs we…
ernestk
  • 72
  • 6
0
votes
1 answer

spring postgresql jpa jta Transaction interleaving not supporting

I used spring jpa(hibernate) atomikos jta transaction.Connection closes in 1 minute after first statement execute on the database side(automatically pgbouncer).But Spring transaction continues. First query execute then call ws or another work do (1…
sss
  • 11
  • 1
0
votes
1 answer

postgres redirect queries to standby?

I am trying to create a connection pooling system with load balancing. From what I unsderstand PGbouncer doesn't have a load balancing option and all I can do is to create a file with all the users+pass and configure the dbs/clusters. but in this…
hello
  • 11
  • 1
0
votes
1 answer

Is PgBouncer needed for .NET Core applications with Entity Framework (Npgsql)?

EF registers as scoped service, which means it creates many short connections to database. One http request - one connection. PostgreSQL doesn't handle a lot of concurrent connections very well. Like a maximum of 100. Is PgBouncer needed for .NET…
Bogdan Rudnytskyi
  • 45
  • 7
1 2 3
…
19 20