Re: Log file permissions?

[Alvaro Herrera <alvherre(at)commandprompt(dot)com>]

Douglas McNaught wrote:
> On 1/31/08, Glyn Astill <glynastill(at)yahoo(dot)co(dot)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