pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedLogs perms and ownership
5+ messages / 3 participants
[nested] [flat]
* Logs perms and ownership
@ 2008-08-26 00:42 steve@outtalimits.com.au
0 siblings, 1 reply; 5+ messages in thread
From: steve@outtalimits.com.au @ 2008-08-26 00:42 UTC (permalink / raw)
To: pgsql-admin
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
Thanks
Steve
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Logs perms and ownership
@ 2008-08-26 02:11 Steve Holdoway <steve.holdoway@firetrust.com>
parent: steve@outtalimits.com.au
0 siblings, 1 reply; 5+ messages in thread
From: Steve Holdoway @ 2008-08-26 02:11 UTC (permalink / raw)
To: pgsql-admin
On Tue, 26 Aug 2008 10:42:19 +1000
<steve@outtalimits.com.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
>
>
> Thanks
>
> Steve
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
Add that user to the postgres group?
--
Steve Holdoway <steve.holdoway@firetrust.com>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Logs perms and ownership
@ 2008-08-26 02:22 Joshua Drake <jd@commandprompt.com>
parent: Steve Holdoway <steve.holdoway@firetrust.com>
0 siblings, 2 replies; 5+ messages in thread
From: Joshua Drake @ 2008-08-26 02:22 UTC (permalink / raw)
To: Steve Holdoway <steve.holdoway@firetrust.com>; +Cc: pgsql-admin
On Tue, 26 Aug 2008 14:11:13 +1200
Steve Holdoway <steve.holdoway@firetrust.com> wrote:
> On Tue, 26 Aug 2008 10:42:19 +1000
> <steve@outtalimits.com.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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Logs perms and ownership
@ 2008-08-26 02:24 steve@outtalimits.com.au
parent: Joshua Drake <jd@commandprompt.com>
1 sibling, 0 replies; 5+ messages in thread
From: steve@outtalimits.com.au @ 2008-08-26 02:24 UTC (permalink / raw)
To: Joshua Drake <jd@commandprompt.com>; +Cc: Steve Holdoway <steve.holdoway@firetrust.com>; pgsql-admin
Yeah, thought about that but as you said the perms on the logs are 700. on
both stderr and syslogging.
On Mon, 25 Aug 2008 19:22:45 -0700, Joshua Drake <jd@commandprompt.com>
wrote:
> On Tue, 26 Aug 2008 14:11:13 +1200
> Steve Holdoway <steve.holdoway@firetrust.com> wrote:
>
>> On Tue, 26 Aug 2008 10:42:19 +1000
>> <steve@outtalimits.com.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
>
>
>
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Logs perms and ownership
@ 2008-08-26 02:31 steve@outtalimits.com.au
parent: Joshua Drake <jd@commandprompt.com>
1 sibling, 0 replies; 5+ messages in thread
From: steve@outtalimits.com.au @ 2008-08-26 02:31 UTC (permalink / raw)
To: Joshua Drake <jd@commandprompt.com>; +Cc: Steve Holdoway <steve.holdoway@firetrust.com>; pgsql-admin
Correction, perms are 600.
On Mon, 25 Aug 2008 19:22:45 -0700, Joshua Drake <jd@commandprompt.com>
wrote:
> On Tue, 26 Aug 2008 14:11:13 +1200
> Steve Holdoway <steve.holdoway@firetrust.com> wrote:
>
>> On Tue, 26 Aug 2008 10:42:19 +1000
>> <steve@outtalimits.com.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
>
>
>
>
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2008-08-26 02:31 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-08-26 00:42 Logs perms and ownership steve@outtalimits.com.au
2008-08-26 02:11 ` Steve Holdoway <steve.holdoway@firetrust.com>
2008-08-26 02:22 ` Joshua Drake <jd@commandprompt.com>
2008-08-26 02:24 ` steve@outtalimits.com.au
2008-08-26 02:31 ` steve@outtalimits.com.au
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