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

Viewing parameterized query logs in PostgreSQL & Pg-Bouncer?

In my PostgreSQL logs (I'm using PG-BOUNCER, too). I'm not able to view the query that is causing me issues. I have not tried anything too specific at this time as I'm wondering if there's a good way to do this with PG-BOUNCER. Here's the…
nilpop
  • 1
  • 2
0
votes
1 answer

how-to connect to pgbouncer internal database

would you be so kind to advise how to connect to pgbouncer's internal database ? I try to follow the community instructions here: https://www.depesz.com/2012/12/02/what-is-the-point-of-bouncing/ and more specifically: $ sudo -i -u postgres [sudo]…
nskalis
  • 2,232
  • 8
  • 30
  • 49
0
votes
1 answer

pgbouncer - auroraDB cluster not load balancing correctly

I as using AuroraDB cluster with 2 readers and pgBouncer to maintain a connection pool. My application is very read intensive and fires a lot of select queries. the problem I am facing is my 2 read replicas are not getting used completely in…
Abhijeet Kale
  • 1,656
  • 1
  • 16
  • 34
0
votes
1 answer

How to connect in spring boot to PGbouncer?

I'm tring to connect my spring boot app to PGbouncer connection pool on digital ocean cloud. But I get the error "prepared statement "S_1" already exists". As I understand the issue is Hikari connection pool. Should I turn it off? If yes how to do…
Illia
  • 158
  • 1
  • 10
0
votes
1 answer

Best practise for Talking from mobile app to postgres?

I am building a mobile app and am talking to postgres in the cloud. Imagine if my app ends up being a success, what is the recommended pattern to talk to the postgres database in the cloud - Is it a) Mobile App -> (some sort of authentication…
Illusionist
  • 5,204
  • 11
  • 46
  • 76
0
votes
2 answers

PG::ConnectionBad with rails and pgbouncer

I have rails and pgBouncer, and I have reconnect: true in the database.yml but I keep getting this in the console: ActiveRecord::StatementInvalid: PG::ConnectionBad: PQconsumeInput() server closed the connection unexpectedly The same error happens…
MaicolBen
  • 840
  • 1
  • 6
  • 20
0
votes
1 answer

Connection to PgBouncer Admin Database

I am trying to connect to the Pgbouncer Admin Database but I am little confused where the Admi user is stored. Below my pgbouncer.ini configuration. [databases] alias_prod = host=abc.com.br port=5432 dbname=edf user=akl…
p.magalhaes
  • 7,595
  • 10
  • 53
  • 108
0
votes
1 answer

pgbouncer-rr is failing in query rewrite

I am using pgbouncer-rr to do query rewrite in a redshift cluster (pgbouncer calls rewrite_query.py to do the rewrites and here is the link for more info on this project - https://github.com/awslabs/pgbouncer-rr-patch). Pgbouncer-rr is based on…
nmakb
  • 1,069
  • 1
  • 17
  • 35
0
votes
2 answers

Access pgbouncer instance for redshift

I am using pgbouncer on redshift cluster. When I use pgbouncer on Postgres I can login into pgbouncer instance using psql -h localhost -p xxxx pgbouncer. But how do I login into pgbouncer setup for redshift? pgbouncer is running on an ec2 instance…
nmakb
  • 1,069
  • 1
  • 17
  • 35
0
votes
1 answer

pgbouncer works even with the wrong password

I just realized today that I can connect to my pgbouncer with the wrong password. I did try without going through port 5432 (directly to postgresql) and I do get a password authentication error, but when I use port 6432 (going through pgbouncer)…
Arya
  • 8,473
  • 27
  • 105
  • 175
0
votes
1 answer

Average query duration goes high between pgbouncer to pgbouncer

I have a setup of two layers of pgbouncers (v 1.8 uptil PR 147) connecting to the postgresql database. The first layer of pgbouncer receives requests from multiple services trying to connect to multiple databases. These requests are pooled by the…
lumena
  • 1
  • 2
0
votes
0 answers

PG Bouncer is not able to handle 1000 concurrent requests

I am using PostgreSQL along with the PGBouncer. But PGBouncer is not able to handle even the 1000 concurrent requests. Am I missing any configuration because of which it is happening? Has anyone faced the similar situation? Is there any way to…
Abhishek
  • 3,304
  • 4
  • 30
  • 44
0
votes
1 answer

PgBouncer - Can users in "admin_users" use "auth_query" to connect instead of userlist.txt?

I am trying to authenticate the users listed in "admin_users" by using the "auth_query" instead of hardcoding the passwords in userlist.txt... but I don't think this is possible in the latest version of pgbouncer (v1.8.1). Please someone tell me I'm…
Greg Clough
  • 1
  • 2
0
votes
0 answers

pgBouncer - 2k memory optimization

I wanted to ask if this 2k optimization made by pgBouncer and mentioned in the docs: Low memory requirements (2k per connection by default) means it's the memory cost of connecting to postgres or pgBouncer? I mean if the architecture looks like:…
HWid
  • 85
  • 1
  • 6
0
votes
1 answer

pgbouncer free_servers - how to increase them

current setting of a pgbouncer server is the following - and what I don't understand is the 'free_servers' info given by the show lists command when connecting to pgbouncer. Is it a (soft or hard) limit on the number of connexion to the postgresql…
Enialis
  • 173
  • 1
  • 9
1 2 3
…
19 20