Re: log file permissions?

From: Steve Crawford <scrawford(at)pinpointresearch(dot)com>
To: Gerardo Herzig <gherzig(at)fmed(dot)uba(dot)ar>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: log file permissions?
Date: 2007-03-16 16:18:33
Message-ID: 45FAC359.8020000@pinpointresearch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Gerardo Herzig wrote:
> Hi dudes. I have my pg log file rotation configured so i have a
> psql_`today`.log. The thing is, can i configure postgres so the file
> permissions (today is 600) could by 640, so developers could login and
> tailf the logfile (without using the postgres superuser, course)?

This really belongs over in admin.

Are you logging through syslog or stdout (ie. what are the following
settings in postgresql.conf and are they in any way overridden by your
startup scripts)?:
syslog =
syslog_facility =
syslog_ident =

If your are logging through syslog, then postgres has no control over
those permissions. You will have to look at your syslog daemon
configuration.

Cheers,
Steve

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2007-03-16 16:21:47 Re: log file permissions?
Previous Message Tom Lane 2007-03-16 16:17:41 Re: Grabbing Newest Records From Duplicates