Question : I installed and configured pgbouncer 1.5.4 on Ubuntu 14.04 LTS and I have a hard time interpreting log […]
Tag: pgbouncer
Should PgBouncer be installed on web application server or database server?
Question : I have a django website where the application and database server are different. I need to install pgbouncer […]
Reusing the same connection to read uncommited transaction
Question : My question is similar to: how to spy on a transaction that is not yet committed in postgres […]
pgbouncer and ssl connection
Question : I have three Servers, two of whom are running postgres 9.5.3 and the third runs pgbouncer 1.7.2. i […]
How to do automatic failover for PostgreSQL with application automatic switch?
Question : There are two ways to try. Method 1 Use JDBC connect the PostgreSQL cluster (primary, standby 2 servers […]
Why can’t start pgbouncer process when setting logfile to /var/log/ path?
Question : This pgbouncer.ini setting can’t start pgbouncer: [databases] mydb = host=127.0.0.1 port=5432 dbname=mydb [pgbouncer] listen_port = 6432 listen_addr = […]
How expensive is a connection to pgbouncer?
Question : Is a connection to pgbouncer cheaper than a connection to PostgreSQL (assuming pgbouncer has already established a connection […]
Is it possible to make a high availability PostgreSQL database cluster by open source softwares?
Question : If use these tools can make a great modern database cluster with full features: pgbouncer (with HAProxy for […]
Is it possible to configure pgbouncer to distribute queries among master and slave?
Question : We have master (write-read) and slave (readonly) Postgres 10 databases. Slave is online replication from master. Now our […]
starting pgbouncer on startup
Question : I installed pgbouncer and configured it and it starts only via using this command pgbouncer /etc/pgbouncer/pgbouncer.ini however using […]