Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 35A0A64FD33 for ; Mon, 25 Aug 2008 23:25:14 -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 61468-03 for ; Mon, 25 Aug 2008 23:25:04 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outbound.icp-qv1-irony-out3.iinet.net.au (outbound.icp-qv1-irony-out3.iinet.net.au [203.59.1.148]) by postgresql.org (Postfix) with ESMTP id CD65264FD15 for ; Mon, 25 Aug 2008 23:25:09 -0300 (ADT) X-IronPort-Anti-Spam-Filtered: true X-IronPort-Anti-Spam-Result: ArcDANMGs0jL1iYg/2dsb2JhbACIAINjhTylWoFr X-IronPort-AV: E=Sophos;i="4.32,267,1217779200"; d="scan'208";a="306267651" Received: from unknown (HELO mail.outtalimits.com.au) ([203.214.38.32]) by outbound.icp-qv1-irony-out3.iinet.net.au with ESMTP; 26 Aug 2008 10:24:54 +0800 Received: from www.outtalimits.com.au (localhost [127.0.0.1]) by mail.outtalimits.com.au (Postfix) with ESMTP id 687B42B6405C; Tue, 26 Aug 2008 12:24:54 +1000 (EST) MIME-Version: 1.0 Date: Tue, 26 Aug 2008 12:24:54 +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: <476e1480e2e8eac14baae88edff7800f@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/156 X-Sequence-Number: 30001 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 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 > > > >