X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4553AD7B40 for ; Tue, 13 Sep 2005 12:10:32 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 84974-06 for ; Tue, 13 Sep 2005 15:10:28 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 97D9DD6D9D for ; Tue, 13 Sep 2005 12:10:26 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j8DFA7Ce023287; Tue, 13 Sep 2005 11:10:08 -0400 (EDT) To: "Yogvinder Singh" Cc: pgsql-admin@postgresql.org Subject: Re: Log file Query In-reply-to: <011101c5b82e$bde82040$5605a8c0@ng3054> References: <011101c5b82e$bde82040$5605a8c0@ng3054> Comments: In-reply-to "Yogvinder Singh" message dated "Tue, 13 Sep 2005 12:15:21 +0530" Date: Tue, 13 Sep 2005 11:10:07 -0400 Message-ID: <23286.1126624207@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 required=5 tests=[AWL=0.006] X-Spam-Level: X-Archive-Number: 200509/137 X-Sequence-Number: 18874 "Yogvinder Singh" writes: > I am using postgres7.3 version. I am unable to find any log. = In 7.3 your best bet is to log via syslog. Set syslog to 2 in postgresql.conf and adjust the other settings if needed, then make sure your syslog daemon is configured to put the messages where you want them. What is probably happening right now is that the postmaster is set to send log messages to stderr but the start script you are using is redirecting postmaster stderr to /dev/null. While you could modify the start script, I don't recommend it for production purposes because 7.3 doesn't have any support for rotating log files that way. syslog is the only production-grade logging approach in that version. regards, tom lane