mirror of
https://github.com/neondatabase/neon.git
synced 2026-01-04 12:02:55 +00:00
83069f6ca1
## Problem PgBouncer does not terminate connections on a suspend: https://github.com/neondatabase/cloud/issues/16282 ## Summary of changes 1. Adds a pid file to store the pid of PgBouncer 2. Terminates connections on a compute suspend --------- Co-authored-by: Alexey Kondratov <kondratov.aleksey@gmail.com>
33 lines
1.1 KiB
INI
33 lines
1.1 KiB
INI
[databases]
|
|
;; pgbouncer propagates application_name (if it's specified) to the server, but some
|
|
;; clients don't set it. We set default application_name=pgbouncer to make it
|
|
;; easier to identify pgbouncer connections in Postgres. If client sets
|
|
;; application_name, it will be used instead.
|
|
*=host=localhost port=5432 auth_user=cloud_admin application_name=pgbouncer
|
|
[pgbouncer]
|
|
listen_port=6432
|
|
listen_addr=0.0.0.0
|
|
auth_type=scram-sha-256
|
|
auth_user=cloud_admin
|
|
auth_dbname=postgres
|
|
client_tls_sslmode=disable
|
|
server_tls_sslmode=disable
|
|
pool_mode=transaction
|
|
max_client_conn=10000
|
|
default_pool_size=64
|
|
max_prepared_statements=0
|
|
admin_users=postgres
|
|
unix_socket_dir=/tmp/
|
|
unix_socket_mode=0777
|
|
; required for pgbouncer_exporter
|
|
ignore_startup_parameters=extra_float_digits
|
|
; pidfile for graceful termination
|
|
pidfile=/tmp/pgbouncer.pid
|
|
|
|
;; Disable connection logging. It produces a lot of logs that no one looks at,
|
|
;; and we can get similar log entries from the proxy too. We had incidents in
|
|
;; the past where the logging significantly stressed the log device or pgbouncer
|
|
;; itself.
|
|
log_connections=0
|
|
log_disconnections=0
|