Friday, January 13, 2017

PostgreSQL: rotate pgbouncer logs

Simplest method: switch to syslog
vi /etc/pgbouncer/pgbouncer.ini
; logfile = /var/log/pgbouncer.log
syslog = 1
psql -p6432 -Upostgres -d pgbouncer -c reload