Douglas McNaught wrote:
> On 1/31/08, Glyn Astill <glynastill@yahoo.co.uk> wrote:
> > I've noticed that by default postgres writes its log files read/write
> > only by the postgres user.
> >
> > I have a nagios user I want to be able to analyse the logs.
> >
> > Is there a way to make postgres output them so they can be read by a
> > group? Or am I going to have to write a script?
>
> PG itself only writes to stdout/stderr or uses syslog(). The way logs
> are generated and stored is distro-specific, so you need to look at
> how your distro does things (perhaps modifying the startup script).
Actually, as of 8.0 there is specialized process that captures stderr
and saves it to log files.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support