X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 3637FD1B1EC for ; Mon, 31 May 2004 09:24:17 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 76921-01 for ; Mon, 31 May 2004 09:24:18 -0300 (ADT) Received: from webmail-outgoing.us4.outblaze.com (webmail-outgoing.us4.outblaze.com [205.158.62.67]) by svr1.postgresql.org (Postfix) with ESMTP id 81013D1B196 for ; Mon, 31 May 2004 09:24:14 -0300 (ADT) Received: from wfilter.us4.outblaze.com (wfilter.us4.outblaze.com [205.158.62.180]) by webmail-outgoing.us4.outblaze.com (Postfix) with QMQP id 2668618013C0 for ; Mon, 31 May 2004 12:24:18 +0000 (GMT) X-OB-Received: from unknown (205.158.62.92) by wfilter.us4.outblaze.com; 31 May 2004 12:23:54 -0000 Received: by ws3-2.us4.outblaze.com (Postfix, from userid 1001) id 12AFC3740C4; Mon, 31 May 2004 12:24:18 +0000 (GMT) Content-Type: text/plain; charset="iso-8859-1" Content-Disposition: inline Content-Transfer-Encoding: 7bit MIME-Version: 1.0 X-Mailer: MIME-tools 5.41 (Entity 5.404) Received: from [203.193.141.53] by ws3-2.us4.outblaze.com with http for shivaprasadp@dellmail.com; Mon, 31 May 2004 20:24:17 +0800 From: "Shivaprasad Pavoor" To: pgsql-admin@postgresql.org Date: Mon, 31 May 2004 20:24:17 +0800 Subject: Re: how do i log events for postgresql 7.0.3 X-Originating-Ip: 203.193.141.53 X-Originating-Server: ws3-2.us4.outblaze.com Message-Id: <20040531122418.12AFC3740C4@ws3-2.us4.outblaze.com> X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200405/340 X-Sequence-Number: 13656 hi all, following are the stpe thru which i cud log postgres's activity to a log file. however, it is not final....coz whn i restarted my linux box, it was no more logging. so anyone idea to overcome this is most welcome... here are the steps, 1. Create a file name postgres.log in /var/log (or wherever you want to create) and change ownership to postgres:postgres (thinking that postgres is using the file to log events. if i'm worng PLZ correct me) 2. stop postgresql server 3.login as root and su – postgres 4. postmaster -D /var/lib/pgsql/data >/var/log/postgres.log 2>&1 & 5. CTRL+D and restart postgresql server (why restart becoz, when i issued postmaster command in step 4 the ostgres server has started....any comments..?) any comments...? rgds, sHIVAPRASADp ----- Original Message ----- From: "Shivaprasad Pavoor" Date: Sat, 29 May 2004 04:23:14 +0800 To: pgsql-admin@postgresql.org Subject: [ADMIN] how do i log events for postgresql 7.0.3 > hi all, > > i have RH7.1 box with postgres 7.0.3. i searched the internet for above mentioned subject in vain. now i'm totally confused about postgres.conf (i'm not able to find in my installation) and pg_options. cud anybody let me know how do i setup logging of postgres. > > thanks in advance. > > Shivaprasad P > -- > _______________________________________________ > Get your free email from http://www.dellmail.com > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 8: explain analyze is your friend > -- _______________________________________________ Get your free email from http://www.dellmail.com