Douglas McNaught wrote: > On 1/31/08, Glyn Astill <glynastill@xxxxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
