Re: Logs perms and ownership

On Tue, 26 Aug 2008 14:11:13 +1200
Steve Holdoway <steve(dot)holdoway(at)firetrust(dot)com> wrote:

> On Tue, 26 Aug 2008 10:42:19 +1000
> <steve(at)outtalimits(dot)com(dot)au> wrote:
>
> > Hi all,
> >
> > Is there a way to make the postgres logs readable by other users or
> > a group apart from postgres:postgres?
> > I am on postgres 8.1
> >
> > I cannot see any feature to allow setting perms or ownership
> >

>
> Add that user to the postgres group?
>

Actually that may or may not work. If the log directory is under
$PGDATA then it won't because $PGDATA must be 0700. If the log
directory is elsewhere or he is using syslog he can get around it.

Sincerely,

Joshua D. Drake

--
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.postgresqlconference.org/
United States PostgreSQL Association: http://www.postgresql.us/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate