From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
---|---|
To: | Douglas McNaught <doug(at)mcnaught(dot)org> |
Cc: | Glyn Astill <glynastill(at)yahoo(dot)co(dot)uk>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Log file permissions? |
Date: | 2008-01-31 15:00:20 |
Message-ID: | 20080131150020.GD8602@alvh.no-ip.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Chander Ganesan | 2008-01-31 15:00:28 | Re: [GENERAL] Backup |
Previous Message | Douglas McNaught | 2008-01-31 14:53:18 | Re: Log file permissions? |