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

org.postgresql.util.PSQLException: This connection has been closed. error for long running transactions

We are getting "org.postgresql.util.PSQLException: This connection has been closed." on one of our deployments for only long running transactions (more than a few minutes): Caused by: org.hibernate.TransactionException: rollback failed at…
nilgun
  • 10,460
  • 4
  • 46
  • 57
1
vote
2 answers

How pgbouncer care about session parameters in transaction pooling mode

i connect to Postgresql via JDBC through pgbouncer with transaction pooling mode enabled. As far as I know in this mode pgbouncer can share same connection for several client without breaking session. So several clients may work within a single…
user3686075
  • 11
  • 3
1
vote
1 answer

OperationalError: ERROR: pgbouncer cannot connect to server

I'm trying to do python manage.py syncdb on a Django installation, but I keep getting OperationalError: ERROR: pgbouncer cannot connect to server. pgbouncer.log contains lines such as: 2017-09-19 19:44:15.107 1128 LOG C-0x8a9930:…
Hassan Baig
  • 15,055
  • 27
  • 102
  • 205
1
vote
1 answer

Pgbouncer closing connections

I recently set up pgbouncer for connection pooling. My pgbouncer.ini file contains [databases] mydb = host=localhost port=5432 user=user dbname=mydb [pgbouncer] auth_type = any auth_file = /etc/pgbouncer/users.txt listen_addr =…
Jonathan Viccary
  • 722
  • 1
  • 9
  • 27
1
vote
2 answers

Npgsql and PgBouncer polling

We are currently using Pgbouncer(installed on database server) for database connection pooling. At the same time we use Npgsql Library which has its own connection pool. I have read recommendations that we should disable pooling in Npgsql and use…
Marcel Kikta
  • 13
  • 5
1
vote
1 answer

Server cannot connect to pgbouncer (PostgreSQL)

I am trying to set up connectional pooling using pgbouncer 1.7.2 for PostgreSQL 9.6 on Windows 10. Trying to connect to pgbouncer in the cmd psql -p 6432 -h 127.0.0.1 postgres pgbouncer gives the error: psql: server closed the connection…
L Marfell
  • 339
  • 2
  • 4
  • 15
1
vote
1 answer

Find source of query through pgbouncer

I am trying to figure out as much as I can about what host a particular type of update query is coming from. My database is PostgreSQL 9.0.23 locally running pgbouncer for connection pooling. The pooling type is transaction pooling. A trigger in…
btilly
  • 43,296
  • 3
  • 59
  • 88
1
vote
0 answers

pgBouncer does not use all availeable CPUs

I have a Server with multiple cores taht's suppose to run pgBouncer (1.7). It's working pretty well, but it occupies only one cpu. I get pretty high latency values when i doe a load test with pgbench, emulating several Clients. (27ms without…
RootOfProblem
  • 357
  • 1
  • 3
  • 11
1
vote
2 answers

[Postgres Replication]Remote host is not reachable repmgr salve

I am trying to create a postgres replication configuration using two servers. The steps are similar to PostgreSQL 9.4 Replication with RepMgr and PgBouncer on Ubuntu 14.04 . I am using repmgr + pgbouncer as my replication configuration. Say I have…
Mohammed Aadil
  • 153
  • 7
1
vote
2 answers

Sqoop: how switch off Prepared Statements?

I use Sqoop 1.4.5-cdh5.4.2 and Postgresql. If Sqoop connects directly to the database - all right. But need use Sqoop over pgbouncer, and I have problem with this. In pgbouncer you can not do prepared statements transaction mode. ... connect…
Petr Ermakov
  • 11
  • 5
1
vote
0 answers

pgBouncer configuration error using Postgres

When I connect pgBouncer to Postgres using the configuration file pgbouncer.ini, it shows an error as client login timeout < server down> What is the problem?
Bensam Nesh
  • 11
  • 3
1
vote
0 answers

Scrapyd on Heroku can't recognize rewritten DATABASE_URL by heroku-buildpack-pgbouncer

Okay, here is my setup. I'm on Heroku running a scrapyd daemon using the scrapy-heroku package https://github.com/dmclain/scrapy-heroku. I'm having issues running out of database connections. I decided to try pooling the database connections use…
jeffjv
  • 3,461
  • 2
  • 21
  • 28
1
vote
0 answers

How to limit infinitely growing pgbouncer logfile?

My pgbouncer.log grows endlessly. How do I enable filename rollover or limit the logfile size for pgbouncer (Windows) ?
Loonis
  • 115
  • 2
  • 10
1
vote
1 answer

pgbouncer 1.7 with master and slave

I am new in using pgbouncer 1.7 and I want to configure it with master slave configuration. I have configured postgres 9.3 streaming replication using repmgr and I want to use pgbouncer for load balancing and connection pooling so that it…
Mohitd23
  • 1,439
  • 2
  • 12
  • 10
1
vote
1 answer

How to integrate pgbouncer-1.4 with PostgreSQL -9.0 database

enter link description hereI'm new to pgbouncer and postgreSQL database. Trying to integrate pgbouncer with postgreSQL database. After installed successfully pgbouncer, its giving error while starting the pgbouncer. bash-3.2$ ./pgbouncer -d…
Satya
  • 182
  • 2
  • 9
1 2 3
…
19 20