Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 3116A6501C1 for ; Mon, 25 Aug 2008 23:31:39 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 69553-04 for ; Mon, 25 Aug 2008 23:31:28 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outbound.icp-qv1-irony-out2.iinet.net.au (outbound.icp-qv1-irony-out2.iinet.net.au [203.59.1.107]) by postgresql.org (Postfix) with ESMTP id 4012364FD33 for ; Mon, 25 Aug 2008 23:31:33 -0300 (ADT) X-IronPort-Anti-Spam-Filtered: true X-IronPort-Anti-Spam-Result: ArcDAMMHs0jL1iYg/2dsb2JhbACIAINjhTylY4Fr X-IronPort-AV: E=Sophos;i="4.32,267,1217779200"; d="scan'208";a="358712622" Received: from unknown (HELO mail.outtalimits.com.au) ([203.214.38.32]) by outbound.icp-qv1-irony-out2.iinet.net.au with ESMTP; 26 Aug 2008 10:31:27 +0800 Received: from www.outtalimits.com.au (localhost [127.0.0.1]) by mail.outtalimits.com.au (Postfix) with ESMTP id C3E162B6405C; Tue, 26 Aug 2008 12:31:26 +1000 (EST) MIME-Version: 1.0 Date: Tue, 26 Aug 2008 12:31:26 +1000 From: To: Joshua Drake Cc: Steve Holdoway , pgsql-admin@postgresql.org Subject: Re: Logs perms and ownership In-Reply-To: <20080825192245.1a4da5be@jd-laptop> References: <20080826141113.a026a405.steve.holdoway@firetrust.com> <20080825192245.1a4da5be@jd-laptop> Message-ID: <887a955a3d737ab1a5cef95384033522@127.0.0.1> X-Sender: steve@outtalimits.com.au User-Agent: RoundCube Webmail/0.2a Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200808/157 X-Sequence-Number: 30002 Correction, perms are 600. On Mon, 25 Aug 2008 19:22:45 -0700, Joshua Drake wrote: > On Tue, 26 Aug 2008 14:11:13 +1200 > Steve Holdoway wrote: > >> On Tue, 26 Aug 2008 10:42:19 +1000 >> 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 > > > >