Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id D40029F9D84 for ; Mon, 13 Aug 2007 16:43:06 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 93034-02 for ; Mon, 13 Aug 2007 16:43:03 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 639C09F9D9A for ; Mon, 13 Aug 2007 16:42:33 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id l7DJgTli020246; Mon, 13 Aug 2007 15:42:29 -0400 (EDT) To: "Tena Sakai" cc: "Joshua D. Drake" , pgsql-admin@postgresql.org Subject: Re: entries in serverlog file In-reply-to: References: <46BB8ABB.8090503@commandprompt.com> Comments: In-reply-to "Tena Sakai" message dated "Mon, 13 Aug 2007 12:00:02 -0700" Date: Mon, 13 Aug 2007 15:42:29 -0400 Message-ID: <20245.1187034149@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/137 X-Sequence-Number: 26468 "Tena Sakai" writes: > Can I just uncomment log_line_prefix entry and stick what I want > (such as %u, %d, %m, etc) into the quotes and expect to see the > logged lines be prefixed with username, database name, timestamp, > etc with all other things intact? Sure; you will however regret by and by that you didn't turn on redirect_stderr, because there is no way to rotate the logfile (other than restarting the postmaster) when it's simply going straight to stderr. The more verbose you make the log, the sooner its bulk is going to become a problem... regards, tom lane