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

PGBouncer connection pooling for Multiple Spring boot Applications connecting to same Postgres DB?

Just want to validate if this scenario of PG bouncer Connection pooling is possible Have A and B spring boot application connecting to the same DB (only read operations) Does PGbouncer share connection pools across multiple instances of the same…
Badri
  • 33
  • 1
  • 5
0
votes
1 answer

Where can I find information about roadmap "pgbouncer", "Etcd", "patroni"?

Could you please tell me if there is information about the update schedule(when support for different versions ends, when new ones are planned to be released). Is there a link to this information(graph, table) ? Thanks
Nik238ss
  • 1
  • 1
0
votes
0 answers

Unable fetch metrics from postgresql://pgbouncer:***@vsaxx:6432/pgbouncer", "exception": "invalid integer value \"xxx\" for connection option \"port\"

I am deploying the prometheus-pgbouncer-exporter to kubernetes by helm chart. Although pods in this namespace is running, the log of pods always show this error message, which failed to collecting metrics and these pgbouncer servers could be shown…
jzl
  • 1
  • 1
0
votes
0 answers

Authentication issue when connecting to PostgreSQL via PgBouncer

Before involving PgBouncer between my application and PostgreSQL, the pg_hba.conf is like(the reason I configure this is to skip the password typing and does not store the database password in plaintext): hostssl user db 0.0.0.0/0 cert…
joker57
  • 110
  • 7
0
votes
0 answers

Geoserver connection to Postgres via pgBouncer

I have PostgreSQL 12, pgbouncer, and Geoserver 2.21.0 running on my Ubuntu 20.04 Virtual Machine (VM). Postgres is behind pgbouncer (connection pooling) and pgbouncer.ini, among other things, specifies the max number of connections, idle timeouts,…
khajlk
  • 791
  • 1
  • 12
  • 32
0
votes
0 answers

Postgres Table experiencing AccessShareLock which reduce the throughput of the system

I have a Postgres Function which performs select query on a table to perform an arithmetic operation and calculate the result. I have setup pgbouncer before the postgresql server for better throughput. The System configurations are as follows. NGINX…
Dinesh
  • 11
  • 1
  • 3
0
votes
2 answers

Possible JMeter bug when using JDBC Connection over SSH?

I need to perform a load test against a pgbouncer. All the clients perform an SSH Tunnel before enstablishing a database connection to the database (through the pgbouncer). It's something like this: sshpass -p 'MY_PSW' ssh -o…
Federico Loro
  • 65
  • 1
  • 6
0
votes
1 answer

Can I use the PostgreSQL simple query mode with PHP/PDO?

Postgres supports both a simple and extended "query mode". With JDBC I can use preferQueryMode=simple to force the driver to use simple mode when issuing queries. How can I do the same with PDO and the PDO_PGSQL extension in PHP? The server I am…
Adam Williams
  • 1,712
  • 3
  • 17
  • 30
0
votes
1 answer

Go sql package, PostgreSQL and PgBouncer with behavior on retry

Let's imaging that we have PostgreSQL and PgBouncer (with Transaction mode). Also we are planning to execute following transaction: BEGIN; UPDATE a ...; UPDATE b ...; SELECT c ...; UPDATE d ...; COMMIT; When transaction begins, PgBouncer gives us…
Serhii Koberniuk
  • 129
  • 1
  • 7
0
votes
0 answers

psql: ERROR: no pg_hba.conf entry for host "x.x.x.x", user "cp", database "abcd", SSL off PGBOUNCER Issue

I am trying to connect to database using pgbouncer. Our db is POSTGRESQL which run on the managed service given by AZURE. Now after configuring Pgbouncer.ini file on Ubuntu 18.04 LTS I am facing the following issue: Whenever I try connecting using…
Aniket Maithani
  • 845
  • 1
  • 10
  • 24
0
votes
0 answers

Handling at least 200 Concurrent requests per second for a Laravel REST API with NGINX

I have developed a REST API with laravel 8 and configured the backend with PostgreSQL/PostGIS. My main aim is to handle atleast 200 concurrent requests per second for the API which should return the result within a second for all 200 concurrent…
Dinesh
  • 11
  • 1
  • 3
0
votes
1 answer

Set GUC parameter or use PGOPTIONS environment variable with PgBouncer

Can I make PgBouncer preserve the PGOPTIONS environment variable in transaction pooling to configure GUC parameters? Or is there another way to configure these parameters in PgBouncer so that it applies to all connections? I specifically need to set…
Frederik Baetens
  • 781
  • 1
  • 9
  • 20
0
votes
0 answers

What is a recommended formula for tweaking pgBouncer configuration settings

Being thrown into the DBA deep end, I am trying to wrap by head around pgBouncer and PostgreSQL. For a little bit of context, we have deployed a Moodle LMS with PostgreSQL on Google Cloud. The VM (16VCPU, 64GB RAM) and Database (8VCPU, 32GB RAM) are…
realnsleo
  • 709
  • 2
  • 12
  • 29
0
votes
0 answers

Reading a PostgreSQL BLOB using JDBC in several transactions: "ERROR: invalid large-object descriptor: 0"

I have a database storing big blobs, some of them >1GB, behind pg_bouncer with transaction pooling. I frequently get query_wait_timeout errors from pg_bouncer, and I've found the root cause to be the time it takes to read large blobs. Simply, all…
annitaq
  • 31
  • 2
0
votes
0 answers

postgresql with pgbouncer tables not showing

I tried implementing pgbouncer and found unusual behavior that I cannot solve. Here is my implementation using docker. version: '3.5' services: dev8_web: container_name: dev8_web_1 image: xcgd/odoo:8.0 depends_on: -…
strike_noir
  • 4,080
  • 11
  • 57
  • 100
1 2 3
…
19 20