pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedlog file permissions?
3+ messages / 3 participants
[nested] [flat]
* log file permissions?
@ 2007-03-16 15:50 Gerardo Herzig <gherzig@fmed.uba.ar>
0 siblings, 2 replies; 3+ messages in thread
From: Gerardo Herzig @ 2007-03-16 15:50 UTC (permalink / raw)
To: pgsql-sql
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)?
Thanks!
Gerardo
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: log file permissions?
@ 2007-03-16 16:18 Steve Crawford <scrawford@pinpointresearch.com>
parent: Gerardo Herzig <gherzig@fmed.uba.ar>
1 sibling, 0 replies; 3+ messages in thread
From: Steve Crawford @ 2007-03-16 16:18 UTC (permalink / raw)
To: Gerardo Herzig <gherzig@fmed.uba.ar>; +Cc: 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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: log file permissions?
@ 2007-03-16 16:21 Tom Lane <tgl@sss.pgh.pa.us>
parent: Gerardo Herzig <gherzig@fmed.uba.ar>
1 sibling, 0 replies; 3+ messages in thread
From: Tom Lane @ 2007-03-16 16:21 UTC (permalink / raw)
To: Gerardo Herzig <gherzig@fmed.uba.ar>; +Cc: pgsql-sql
Gerardo Herzig <gherzig@fmed.uba.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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2007-03-16 16:21 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-03-16 15:50 log file permissions? Gerardo Herzig <gherzig@fmed.uba.ar>
2007-03-16 16:18 ` Steve Crawford <scrawford@pinpointresearch.com>
2007-03-16 16:21 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox