Thread: truncate/rotate pgbouncer log using .ini settings

truncate/rotate pgbouncer log using .ini settings

From

Venkat Kaushik

Date:

27 September 2013, 00:25:36

I have setup pgbouncer successfully on CentOS6, PG9.2
pgbouncer.x86_64 1.5.4-1.rhel6 @pgdg92

I have a question regarding logging:
Currently I have 17MB of log and its growing.

17M -rw-rw-r--. 1 pgbouncer pgbouncer 17M Sep 26 12:17 /var/log/pgbouncer/pgbouncer.log

a) Is there a way (from pgbouncer.ini) to curtail/truncate/rotate logs?

b) If answer to (a) is NO, then I will come up with alternate solution,
but wanted to ask.

Thanks,
Venkat

Re: truncate/rotate pgbouncer log using .ini settings

From

Sergey Konoplev

Date:

28 September 2013, 02:34:38

On Thu, Sep 26, 2013 at 2:25 PM, Venkat Kaushik <venkat.pguser@gmail.com> wrote:
> a) Is there a way (from pgbouncer.ini) to curtail/truncate/rotate logs?

http://pgbouncer.projects.pgfoundry.org/doc/config.html#_log_settings

You can configure it to log to syslog and then configure your logging
daemon to rotate it.

--
Kind regards,
Sergey Konoplev
PostgreSQL Consultant and DBA

http://www.linkedin.com/in/grayhemp
+1 (415) 867-9984, +7 (901) 903-0499, +7 (988) 888-1979
gray.ru@gmail.com