Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id A19419FBEF0 for ; Fri, 16 Mar 2007 13:18:56 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 16269-01 for ; Fri, 16 Mar 2007 13:18:38 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from polaris.pinpointresearch.com (66-7-238-130.static-ip.telepacific.net [66.7.238.130]) by postgresql.org (Postfix) with ESMTP id 7DAEC9FBF2C for ; Fri, 16 Mar 2007 13:18:38 -0300 (ADT) Received: from [192.168.1.179] (betelgeuse.pinpointresearch.com [192.168.1.179]) by polaris.pinpointresearch.com (Postfix) with ESMTP id 18376E00EC80; Fri, 16 Mar 2007 09:18:37 -0700 (PDT) Message-ID: <45FAC359.8020000@pinpointresearch.com> Date: Fri, 16 Mar 2007 09:18:33 -0700 From: Steve Crawford User-Agent: Thunderbird 1.5.0.9 (X11/20060911) MIME-Version: 1.0 To: Gerardo Herzig CC: pgsql-sql@postgresql.org Subject: Re: log file permissions? References: <45FABCC8.3090901@fmed.uba.ar> In-Reply-To: <45FABCC8.3090901@fmed.uba.ar> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/233 X-Sequence-Number: 27871 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