File: /volume1/@appstore/SynologyPhotos/etc/pgbouncer.ini
[databases]
synofoto = host=/var/run/postgresql port=5432 user=SynologyPhotos
[pgbouncer]
user = SynologyPhotos
unix_socket_dir = /run/synofoto
unix_socket_mode = 0700
unix_socket_group = SynologyPhotos
listen_port = 5432
auth_type = any
pool_mode = session
server_reset_query = DISCARD ALL
max_client_conn = 65535
default_pool_size = 20
max_db_connections = 20
logfile = /var/packages/SynologyPhotos/var/log/synofoto-pgbouncer.log
log_connections = 0
log_disconnections = 0
log_pooler_errors = 1
# verbose = 1
# stats_period = 30
stats_period = 8640000
server_lifetime = 600
server_idle_timeout = 10
query_wait_timeout = 600