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
3
votes
1 answer

Disabling Connection Pooling in Rails to use PgBouncer

We have a Ruby on Rails 4.2.8 project that accesses a large PostgreSQL database. We are going to add a new server for connection pooling using PgBouncer. Since PgBouncer will handle the db connection pooling, would we need to turn off Rails…
dsmorey
  • 453
  • 1
  • 5
  • 16
3
votes
1 answer

How would I configure PGbouncer to work with SET search_path across queries?

I have a quite large PostgreSQL database with up to 300 connected clients from a web application and some background processing. I'm considering adding PGbouncer as it is my understanding, that postgresql will not continue to scale well with this…
Niels Kristian
  • 8,661
  • 11
  • 59
  • 117
3
votes
1 answer

PGBouncer : Cant connect on the right db

I'm actually facing an issue. I've installed pgbouncer on a production server, on which i've a Odoo instance and postgresql as well. Perhaps : In my logs, i'm having this : 2018-09-10 16:39:16.389 10123 WARNING C-0x1eb5478:…
Vincent COFFIN
  • 31
  • 1
  • 2
3
votes
1 answer

What are other middleware alternatives for PgBouncer and PgPool II?

I am trying to find what are the different middleware available to work with Postgres DB. Every one is recommending about PgBouncer and PgPool II. What are the list of other middleware that I can work with.
Jagadeeswar
  • 311
  • 2
  • 5
  • 14
3
votes
3 answers

pgBouncer on Multiple Ports?

I'm running a Postgres database on 5432, and pgBouncer on 6432. All of my scripts point to 6432, but we have a large legacy code base that points to 5432, which we'd like to have user pgBouncer as well. The best way we've come up with to do this is…
user1517922
  • 1,308
  • 3
  • 15
  • 22
3
votes
1 answer

pgbouncer error: closing because: client unexpected eof (age=0)

My project is written with golang,I use postgresql Database and use pgbouncer as a database pool connection. I did a pressure test after I finished the basic function. It runs well as test by the command(just 1 concurrency): ab -n 1000 -c 1 -p…
M.Mike
  • 663
  • 1
  • 6
  • 12
3
votes
0 answers

pgbouncer ignores pidfile from ini

trying to start pgbouncer I see in log: 2017-04-25 11:18:06.319 7186 FATAL @src/main.c:612 in function check_pidfile(): pidfile exists, another instance running? indeed, it was not deleted by service pgbouncer stop: [root@b ~]# grep pid…
Vao Tsun
  • 47,234
  • 13
  • 100
  • 132
3
votes
0 answers

Which are the pgbouncer limits?

I have a PostgreSQL 9.4 running on Debian 7. My question is simple, there is a connection limit for pgbouncer? if I set a postgres's max_connections to 256. Can I set a pgbouncer with following values: max_client_conn to 4096 or…
Edmundo Robles L
  • 25
  • 3
3
votes
3 answers

How to install PgBouncer on Windows 7 (x64)

I am attempting to install PgBouncer on my computer with no success. In the installation page, im told that PgBouncer has two dependencies GNU Make 3.81+ and libevent 2.0. Never having used or heard of these two software before, Im completely…
Hozeis
  • 1,542
  • 15
  • 36
3
votes
3 answers

Can't compile pgbouncer neither in linux nor in windows

I'm trying compile pgbouncer to use in a PostgreSQL server running in windows server 2008. However I simply can't compile the dll, and the same error appears in linux (ubuntu) and in windows: checking for libevent... configure: error: not found:…
brevleq
  • 2,081
  • 10
  • 53
  • 97
3
votes
1 answer

How to configure postgres+pgbouncer to allow large number of connections

I am in the process of stress testing pgbouncer with 5000 connections. The purpose of the test is to multiplex the connection using pgbouncer i.e. 5000 client connection to 500 db connections. However, I am unable to achieve the target of active 500…
jayanth88
  • 564
  • 1
  • 6
  • 14
3
votes
1 answer

How do you know if PGBouncer is working?

I've set up PGBouncer and configured it to connect to my postgres DB and it all connects just fine, however I'm not sure if its actually working. I have a php script that runs as a daemon and picks up beanstalk jobs. The problem is for every…
TheStoneFox
  • 3,007
  • 3
  • 31
  • 47
2
votes
1 answer

psycopg2 + pgbouncer. Async mode with gevent error

I've got an application psycopg2 + pgbouncer + gevent. Asynchronous application, ie one process serves multiple requests. Asynchronous access to database appeared in the latest version of psycopg2, if rather then 2.2. But just in this release…
exabiche
  • 2,895
  • 2
  • 17
  • 10
2
votes
0 answers

connect to replicated Postgresql through Pg_bouncer deployed on local cluster using Minikube

I'm new to Kubernetes and Helm, I took time to read the docs to understand the concepts to move on with my task which I mentioned in the question's title. I looked for the examples and based on what I see in the docs & values example, I can add…
Jafar
  • 21
  • 2
2
votes
1 answer

Configuring PostgreSQL schema for default Django DB working with PgBouncer connection pool

I need to set the default DB schema for a Django project, so that all tables of all apps (including 3rd party apps) store their tables in the configured PostgreSQL schema. One solution is to use a DB connection option, like this: # in Django…
farzad
  • 8,775
  • 6
  • 32
  • 41
1 2 3
…
19 20