Yeah, I use FreeBSD's wonderful newsyslog utility, and I do my logging like
this:
su -l pgsql -c '[ -d ${PGDATA} ] && exec /usr/local/bin/pg_ctl
start -s -w -o "-i" -l /var/log/pgsql.log'
And my /etc/newsyslog.conf entry:
/var/log/pgsql.log pgsql:pgsql 600 3 4096 * Z
Chris
> -----Original Message-----
> From: pgsql-hackers-owner@postgresql.org
> [mailto:pgsql-hackers-owner@postgresql.org]On Behalf Of Peter Eisentraut
> Sent: Thursday, 6 September 2001 6:04 PM
> To: Christopher Kings-Lynne
> Cc: PostgreSQL Development
> Subject: Re: [HACKERS] Log rotation?
>
>
> Christopher Kings-Lynne writes:
>
> > What's the problem with using newsyslog or logrotate at the
> moment? (ie.
> > use the system log rotator)
>
> The postmaster will never close the output file, so you can rotate all you
> want, the original file will never be abandoned.
>
> --
> Peter Eisentraut peter_e@gmx.net http://funkturm.homeip.net/~peter
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://www.postgresql.org/search.mpl
>