X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id A0F2D11F623F for ; Wed, 26 Apr 2006 13:39:50 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 50832-04-2 for ; Wed, 26 Apr 2006 13:39:29 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from prod01.jerrysievers.com (adsl-64-118-249-70.netrox.net [64.118.249.70]) by postgresql.org (Postfix) with ESMTP id B290C11F623A for ; Wed, 26 Apr 2006 13:39:28 -0300 (ADT) Received: (from gsievers@localhost) by prod01.jerrysievers.com (8.11.0/8.11.0) id k3QGdQj04674; Wed, 26 Apr 2006 12:39:26 -0400 To: pgsql-admin@postgresql.org Subject: Postmaster log perms and line suffix From: Jerry Sievers Date: 26 Apr 2006 12:39:26 -0400 Message-ID: Lines: 30 X-Mailer: Gnus v5.7/Emacs 20.7 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200604/279 X-Sequence-Number: 21448 Pgadmins, 2 loosly related questions 1. We have need to let developers view the postmaster logs on some of our environments and wish NOT to give them access to the postgres Unix acct if possible. It looks though as if log file perms are determined by the global umask set in postmaster.c and is not changeable without either changing the umask or adding some chmod lines to syslogger.c. Q: Am I missing an easier way to do this? I realize the risks involved here. 2. We have a fairly elaborate and very useful log file parser/analyzer running that gathers and reports on long-running-queries, error messages and other logged data. Splitting the log files into records is a bit tricky however due to multi-line log records. Q: Has anyone else wished for a config parm as "log_line_suffix" or similar that would let us place an arbitrary record seperator string trailing each log file entry? Prefix can be used for this but seems a bit non-intuitive. Comments appreciated. Thx -- ------------------------------------------------------------------------------- Jerry Sievers 305 854-3001 (home) WWW ECommerce Consultant 305 321-1144 (mobile http://www.JerrySievers.com/