Re: log file permissions?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
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:21:47
Message-ID: 7816.1174062107@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Gerardo Herzig <gherzig(at)fmed(dot)uba(dot)ar> writes:
> 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)?

You'd have to change the code --- the syslogger process inherits umask
077 from the postmaster.

regards, tom lane

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Reece Hart 2007-03-16 17:18:56 Re: [SQL] PostgreSQL to Oracle
Previous Message Steve Crawford 2007-03-16 16:18:33 Re: log file permissions?