1 year ago
#202640
khajlk
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, etc.
I have also connected Geoserver to the postgres via pgbouncer. Since geoserver also has an internal connection pool given by the following options (while adding postgis store), my question is, how do I handle these settings? For the time being, I have kept the default options. But, should these settings (e.g. max_connections, idle) be aligned with the pgbouncer configuration?
postgresql
geoserver
pgbouncer
0 Answers
Your Answer