Server Fault
Server Fault

Questions tagged [pgbouncer]

Lightweight connection pooler for the PostgreSQL database server.

pgbouncer is a PostgreSQL connection pooler. Any target application can be connected to pgbouncer as if it were a PostgreSQL server, and pgbouncer will create a connection to the actual server, or it will reuse one of its existing connections.

The aim of pgbouncer is to lower the performance impact of opening new connections to PostgreSQL.

8 questions
2
votes
1 answer

Posgres : perf decreased although server is better :(

I've changed my VPS hosting for the better and saw a significative performance decrease. Before : AMD 8 cores@2.8Ghz, 16 GB RAM, Ubuntu 14.04, Postgres 9.4, Pgbouncer 1.7, SSD 80Mb/s After: Haswell 4 cores@2.4Ghz, 24 GB RAM, Ubuntu 16.04, Postgres…
Benjamin Toueg
  • 123
1
vote
1 answer

pgbouncer:is it OK putting on localhost or it's better on another server?

I'm about to migrate my (tiny) server farm to Google Cloud Platform and so giving the architecture a small restyling. One of the changes I'm about to commit is the introduction of pgBouncer, to manage pooling (ATM I'm having only one DB server with…
Morenz
  • 23
1
vote
1 answer

pgbouncer - failed to restart

I am logged in to a server and trying to restart pgbouncer. $ /sbin/service pgbouncer restart Stopping pgbouncer service: [FAILED] pgbouncer already running [FAILED] When I call for…
hackg
  • 13
1
vote
0 answers

Setting up a Django + Postgres + PgBouncer through Docker

I have an existing Django app where Django runs in a Docker container (served through uvicorn), and Postgres runs in another Docker container. In my settings.py I have DATABASES = { "default": { "ENGINE":…
Titandrake
  • 111
0
votes
0 answers

How can I find LDAP lookup string for the user?

I want to configure pgBouncer with LDAP and the documentation[1] says we need to Create the users.txt PgBouncer authentication file. The first field is the user name and the second is the LDAP or Active Directory lookup string for the…
LifeLongStudent
  • 101
0
votes
1 answer

PgBouncer not listening with no errors in logs

I currently have Postgres working on my server want to move to connection pooling. Looking around and PgBouncer seems to be the tool of choice. I have set it up and it claims to start fine with the log file looking like [databases] xxxx =…
Rudiger
  • 191
0
votes
0 answers

Pgbouncer to postgresql auth failures

I have deployed the airflow Version: "2.9.3" in kind cluster using Airflow official latest helm chart. I have configured PostgreSQL and Pgbouncer both to use md5 password encryption pgbouncer-custom-config [databases] airflow-db =…
Just curious
  • 1
0
votes
1 answer

Patroni Haproxy and pg-bouncer architecture

I'm building a patroni postgres cluster, however, I can't decide which is better architecture App > HAproxy > Pgbouncer > PostgreSQL (patroni) App > PGBouncer > HAproxy > PostgreSQL (patroni) I can't seem to get an answer upon my search and a lot of…
Nullyinthesky
  • 1