Hi, I am facing an issue with PgBouncer-Postgres setup,
*PgBouncer (PgBouncer 1.23.1 running on VM instance FreeBSD 14.2) and PostgreSQL DB cluster on a virtual machine (PG version 16.0, RHEL 9.4) *. My application backend is nodeJS which throws the following Error in the nodejs console log: when connecting through pgbouncer to the backend database server... ERROR thrown: my-node>* Failed to connect to PostgreSQL database transaction_db : unsupported startup parameter: statement_timeout *{"code":"08P01", "length":69, "name": "error", xx xx my-node> error:[object Object ] {"timestamp":"15-07-2025 10:14:26"} x x xx Note: The nodejs apps earlier directly establishing connections to the PostgreSQL DB ( no such errors) now redirected via Pgbouncer throws this error. *The config parameters for pgbouncer as follows(correct me if any mistakes made)* [root@pgbouncer ~]# grep ^[^';;;'] /usr/local/etc/pgbouncer.ini [databases] transaction_db = host=dbmain.mydomain.com port=5444 dbname=transaction_db [users] [pgbouncer] Logfile = /var/log/pgbouncer/pgbouncer.log pidfile = /var/run/pgbouncer/pgbouncer.pid listen_addr = * listen_port = 5444 auth_type = md5 auth_file = /usr/local/etc/pgbouncer.users admin_users = adminuser stats_users = adminuser, pool_mode = transaction server_reset_query = DISCARD ALL server_reset_query_always = 1 ignore_startup_parameters = extra_float_digits // I have added this also or can I add these options too in the following line ? ;; ignore_startup_parameters = extra_float_digits, options, statement_timeout, idle_in_transaction_session_timeout // doubt options supported in latest versions ? max_client_conn = 5000 // can I give this much high value ? default_pool_size = 20 min_pool_size = 10 reserve_pool_size = 10 reserve_pool_timeout = 5 max_db_connections = 100 max_user_connections = 30 server_lifetime = 3600 server_idle_timeout = 600 // is this a low value or need to be increased ? [root@pgbouncer ~]# The config params of N*odeJS application which uses nodejs connection pooling in* code as follows the Node JS application using the following nodejs pooling configurations for the application level *cat app_10072025/config/pg-pool-config.js* ....... *const poolOptions = { max: 10, min: 2, idleTimeoutMillis: 600000, //Idle for 5Min connectionTimeoutMillis: 10000, //Reconnect 10sec statement_timeout: 60000, //Query executiion 1 min acquire: 20000, maxUses: 1000 //reconnect after 1000 queries};* const pools = { transaction_db: new Pool({ connectionString: `postgresql://${DB_USER}:${DB_PASSWORD}@ ${DB_HOST}:${DB_PORT}/${DB_NAME_TRANSACTION_DB}`, ...poolOptions, }), }; .................................. Any hints and suggestions in the config params are most welcome. Thank you, Krishane