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
1
vote
0 answers

django, pgBouncer and CONN_MAX_AGE

Similar but unanswered question Ideal settings for pgbouncer with Django's CONN_MAX_AGE I wonder if using both is really beneficial, or should we use only one of them?
eugene
  • 39,839
  • 68
  • 255
  • 489
1
vote
1 answer

Pgbouncer timeouts

I try to use pgBouncer to eliminate short network disconnects. I did a test, where I had Clinet->pgBouncer->Postgresql. When connection is made from Client, I disconnect network cable, if I connect it back faster than in ~15 sec it still works. If…
Lukas Radvilavicius
  • 19
  • 1
  • 1
  • 2
1
vote
1 answer

Best place to install pgBouncer for best performance (webserver or database)

I have the following scenario: 2 to 5 WebServers Apache + php connecting on a single postgresql database. (the number of server's can variate to the traffic). Dedicated PostgreSQL (9.3) installed on the same network. What is the best place to…
brownstone666
  • 41
  • 3
1
vote
1 answer

how to restrict specific hosts from connecting to pgbouncer?

I am running my postgres-9.2 on 6432 port and pgbouncer on 5432 port. Few of my colleagues client machines have the firewall connection permissions on 5432 port on server machine. But as a DB admin, I wanted to restrict some IP addresses from…
Shashikanth Komandoor
  • 781
  • 1
  • 11
  • 29
1
vote
2 answers

Doctrine. Turn off prepare statement

I using symfony2 with doctrine for my project. How I can turn off prepare statement for every sql query? I need it because, I use pgbouncer for PostgreSQL connect and prepare statement doesn't support.
Eugene Babushkin
  • 41
  • 2
1
vote
1 answer

Postgres ignoring search_path parameter

I have a C# app connecting to a postgres database, through pg_bouncer, using Npgsql. In my connection string, I include SearchPath. Npgsql picks this up and sets the search_path parameter in the startup packet. Pg_bouncer seems to not like that…
Cuthbert
  • 1,202
  • 1
  • 12
  • 18
1
vote
4 answers

Why is the PostgreSQL JDBC driver sending a bad packet header to the server during authentication?

Important Note -- Had a breakthrough in Edit #2 at the end, so be sure to read that as well. I'm in clojure, trying to use JDBC to connect to our company PostgreSQL server. The server is using pgBouncer. Here are my project dependencies: …
Aaron Johnson
  • 795
  • 1
  • 8
  • 16
1
vote
2 answers

Is it possible to detect that PHP is connecting to a PostgreSQL database through a PgBouncer pool?

On an admin dashboard page of a PHP web application, I would like to display details about the database connection. Depending on the local setup, the connection may be direct, or it may be brokered by PgBouncer. Is it possible to detect exactly what…
Zilk
  • 8,917
  • 7
  • 36
  • 44
1
vote
0 answers

Improving connection speed between postgresql and php

I have a setup for connecting to a postgresql database the works like this: Apache PHP pg_connect prepared_statement ip address to server pg_bouncer unix socket return queried data When I return the query without PHP it takes 900 milliseconds to…
Devin Dixon
  • 11,553
  • 24
  • 86
  • 167
1
vote
3 answers

pgbouncer can't connect to local postgresql database (timeout)

Im trying to get pgbouncer to work on my standalone postgresql server, but when I try to connect to the database using the pgbouncer port, I get an timeout error. Postgresql: 9.1.8 pgBouncer: 1.4.2 OS: Ubuntu 12.04.2 LTS (GNU/Linux…
Tomas Jacobsen
  • 2,368
  • 6
  • 37
  • 81
0
votes
1 answer

Example psql command for pgbouncer connect with SCRAM-SHA-256 and multiple DBs

What would be a valid example psql command for connecting to pgbouncer in case of valid auth_file: "testuser" "SCRAM-SHA-256......blablaExample" For the following conf: auth_type=scram-sha-256 ... [databases] targetdb = host=1.1.1.1 dbname=testdb…
Paku
  • 455
  • 1
  • 4
  • 15
0
votes
0 answers

PGBouncer only shows Postgres database and not others

We are trying to monitor a number of connections to the Azure for Postgres Flexible server, by a specific user and/or specific database (connection pool, making sure it does not exceed a threshold). To accomplish this, PGBouncer was set up and…
Alex V
  • 305
  • 2
  • 7
0
votes
0 answers

How to configure Pgbouncer in Airflow

I have been configuring Airflow Helm using the official documentation found at the following link: https://airflow.apache.org/docs/helm-chart/stable/production-guide.html. In my Airflow Helm configuration (values.yaml), I encountered a conflict…
Adil Blanco
  • 616
  • 2
  • 6
  • 23
0
votes
1 answer

pgbouncer long cl_waiting for specific connections

I have a pgbouncer service that sits in front of a datawarehouse type setup and manages high volume API requests coming in from other services. It has been running for a long time pretty much without an issue. One day we started seeing long…
Alexi Theodore
  • 1,177
  • 10
  • 16
0
votes
0 answers

I have issue with pgbouncer metrics

I have the below pgbouncer metric set in my environment, now am receiving alert for the metric but i have not been resolve the issue. pgbouncer_pools_client_maxwait_seconds : we set this metric to above 40 (pgbouncer_pools_client_maxwait_seconds >…
adeife adekunbi
  • 1
  • 1
1 2 3
…
19 20