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

Format of pg_auth/pg_pwd file

When setting up pgbouncer, you need to create an auth file, "The file format is the same as the PostgreSQL pg_auth/pg_pwd file". What is this format? Trying to google yields pages of this sentence.…
Skylar Saveland
  • 11,116
  • 9
  • 75
  • 91
0
votes
1 answer

What do you think is the best approach for creating a data mapping layer in python?

I would appreciate hearing some opinions on the best approach to creating a light-weight data mapping layer between some python objects and a postgres database. I'm using the psycopg2 library, and plan to use pgbouncer. I looked at this:…
Jaigus
  • 1,422
  • 1
  • 16
  • 31
-1
votes
0 answers

Can I use a non-plaintext different password to authenticate to pgbouncer than the postgreSQL server?

I don't want to keep any plaintext password in my pgbouncer config. Can I use a non-plaintext different password to authenticate to pgbouncer than the postgreSQL server? E.g use scram password to auth against pgbouncer and then some other password…
Paku
  • 455
  • 1
  • 4
  • 15
-1
votes
1 answer

How configure Kubernetes with external servers?

I have external Postgres and I want connect hem with me Kubernetes claster throuth pgbouncer. What i need configure Kubernetes claster with Postgres?.
-1
votes
2 answers

Pgbouncer - Can I use pgbouncer for load balancing the request in postgres cluster?

Currently, I am using pgbouncer for connection pooling in the postgresql cluster. I just want to make sure, Whether it is possible to load balance request between the nodes in the postgresql cluster using pgbouncer.
Akil Kumar
  • 38
  • 1
  • 4
-2
votes
0 answers

Handling PostgreSQL restarts with PgBouncer

I'm exploring the use of PgBouncer as a connection pooler for my PostgreSQL database. While it's been promising so far, I've encountered a challenge: if the database goes down or restarts during an operation, PgBouncer doesn't seem to handle it…
Dakait
  • 2,531
  • 1
  • 25
  • 43
1 2 3
19
20