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

connect C# to PgBouncer

I am using C# and PostgreSQL. I have connected to PostgreSQL using Npgsql. Everthing is working fine. Now I want to use connection pooling with the help of PgBouncer tool.Database information has been set to PgBouncer. Because now PgBouncer will…
M.Sharma
  • 269
  • 6
  • 18
0
votes
1 answer

HAProxy + pgbouncer server closed the connection unexpectedly

I have an architecture of haproxy on web server which is routing to slave servers, where I have pgbouncer over postgre. HAPoxy config: global log 127.0.0.1 local1 debug user haproxy group haproxy defaults log global retries 3 …
Sephirothus
  • 3
  • 1
  • 4
0
votes
1 answer

pgbouncer vs postgres hba config file

I have postgres with hba configuration file and pgbouncer for connection pooling. I want to connect to pgbouncer (instead of postgres) only by changing the port number of the connection string (6543 instead of 5432). Both postgres and pgbouncer run…
Benjamin Toueg
  • 10,511
  • 7
  • 48
  • 79
0
votes
1 answer

PgBouncer server lifetime over

I have setup a django app with pg_bouncer and default configuration. Tonight, after 3600 mins the log says: 2016-05-06 02:45:00.131 6414 LOG S-0x1290330: test/test@127.0.0.1:5432 closing because: server lifetime over (age=3600) First question: is…
EsseTi
  • 4,079
  • 5
  • 36
  • 63
0
votes
1 answer

Autoscaling limited by RDS connection

I have some nightly jobs that are running on EC2 and the number of machines is scaled by the number of messages in SQS. My process requires reads from a Postgres RDS database. Now these are the issues I am facing. Not able to scale beyond a certain…
najeeb
  • 813
  • 12
  • 25
0
votes
1 answer

Multiple connection pool on same PostgreSQL

My application has 2 sections mainly, User interface written in angular which uses a Django python back end. Heavy map reduce kind of process. Both uses postgres for look up, so my doubt is if I use same connection pool for both, at the time when…
najeeb
  • 813
  • 12
  • 25
0
votes
2 answers

Ssh to AWS RDS Postgres instance

I wanted to install pgbouncer in my postgres rds, but I am not able to access the instance, like the same way we access ec2 instances. So is there a way by which I can ssh to the machine (not psql, it's working fine).
najeeb
  • 813
  • 12
  • 25
0
votes
2 answers

Postgres query run executed using hibernate getting dropped if the query takes a long time without any timeout exception

I am running a postgres query that takes more than two hours. This query is executed using hibernate in a java program. After about 1.5 hours the query stops showing up in the server status in pg_admin. Since, the query disappeared from the list of…
Jijo Mathew
  • 322
  • 2
  • 15
0
votes
1 answer

pgbouncer 1.7 with TLS/SSL client and server connections

With settings borrowed from a similar server running Postgres 9.4.1 & pgbouncer 1.6.1, I have multiple users connecting to the database through pgbouncer on port 6543. I also have a second server running PostgreSQL 9.4.5 where I have verified that…
lalligood
  • 144
  • 8
0
votes
1 answer

Multi-process pgbouncer pooling: out of available connections

My setup: postgresql.conf: max_connections = 100 pgbouncer config: [databases] markets_parser = host=localhost port=5432 dbname=markets_parser user=argon datestyle=ISO connect_query='SELECT 1' [pgbouncer] logfile =…
scythargon
  • 3,363
  • 3
  • 32
  • 62
0
votes
1 answer

Max_connection in postgres

I have postgres server that is limited on 100 max_connections, and in some moment when is application is in heavy use that limit is reached, so i try to increase that number and when i try to restart postgres, wont start, and in log i got message…
Aleksandar
  • 73
  • 1
  • 10
0
votes
1 answer

pgbouncer postgres multiple django sites

I am trying to learn a bit of pgbouncer with postgres and django - but I seem to have a problem when under production. So, I have a django site say site1, which uses the following django database settings.py: SECRET_KEY = "dbpassword" DATABASES = { …
AJW
  • 5,569
  • 10
  • 44
  • 57
0
votes
0 answers

PostgreSQL table lock

I have a PostgreSQL 9.2 database using pgBouncer connection pool in a debian server. In that database, regular users performs queries over a few tables and I have a cron process fetching data and inserting in a table (using a pg/plsql function which…
Lamis IntheSky WithDiamonds
  • 53
  • 1
  • 4
0
votes
1 answer

getting pgbouncer to work on a windows machine

I installed pgbouncer 1.5.4 on my pc so that I could sort out the using to much connections in postgre problem in a way. I need to be able to have many people run a web page that has a map application on it which reads from a postgresql database, I…
Ravyn
  • 157
  • 4
  • 21
0
votes
1 answer

Pooling connection to mysql database server from django application server

I am designing the backend of my ios application. The backend has separate database and application server running mysql and django separately in different machines. Till now, I have connected my application server with my database server in simple…
user2372442
  • 61
  • 6
1 2 3
…
19
20