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 E5CF2D7E26 for ; Tue, 13 Sep 2005 03:46:29 -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 64035-10 for ; Tue, 13 Sep 2005 06:46:11 +0000 (GMT) Received: from newgen.co.in (mx.newgen.co.in [202.131.146.227]) by svr1.postgresql.org (Postfix) with SMTP id 98884D84A3 for ; Tue, 13 Sep 2005 03:46:06 -0300 (ADT) Received: (qmail 20561 invoked by uid 507); 13 Sep 2005 06:46:05 -0000 Received: from 202.140.41.205 by mx.newgen.co.in (envelope-from , uid 501) with qmail-scanner-1.25 (fireav: ???. spamassassin: 3.0.3. Clear:RC:0(202.140.41.205):SA:0(-99.4/5.0):. Processed in 4.107054 secs); 13 Sep 2005 06:46:05 -0000 Received: from unknown (HELO ngmail.newgen.co.in) (okhlaoffice@202.140.41.205) by mx.newgen.co.in with SMTP; 13 Sep 2005 06:46:01 -0000 Received: (qmail 5416 invoked by uid 504); 13 Sep 2005 06:52:24 -0000 Received: from yogvinder@newgen.co.in by ngmail.newgen.co.in by uid 501 with qmail-scanner-1.21 (fireav: ???. Clear:RC:1(192.168.5.86):. Processed in 3.031863 secs); 13 Sep 2005 06:52:24 -0000 Received: from unknown (HELO ng3054) (192.168.5.86) by 192.168.5.243 with SMTP; 13 Sep 2005 06:52:21 -0000 Message-ID: <011101c5b82e$bde82040$5605a8c0@ng3054> From: "Yogvinder Singh" To: Subject: Log file Query Date: Tue, 13 Sep 2005 12:15:21 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_010E_01C5B85C.CFAB76F0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Virus-Scanned: by amavisd-new at hub.org X-Amavis-Alert: BAD HEADER MIME error: error: part did not end with expected boundary X-Spam-Status: No, hits=1.108 required=5 tests=[AWL=0.836, HTML_MESSAGE=0.001, MIME_MISSING_BOUNDARY=0.247, RCVD_BY_IP=0.024] X-Spam-Level: * X-Archive-Number: 200509/123 X-Sequence-Number: 18860 This is a multi-part message in MIME format. ------=_NextPart_000_010E_01C5B85C.CFAB76F0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable hi ppl, I am using postgres7.3 version. I am unable to find any log. = all the files=20 1) /usr/local/pgsql/data/serverlog 2) /var/log/pgsql etc are empty pg_xlog and pg_clog directory files dont seem to be = meaningful. i tried=20 log_connections =3D true log_pid =3D true log_statement =3D true log_duration =3D true log_timestamp =3D true log_min_error_statement =3D debug5 but where this log_statement log will go... Moreover where databaseserver log is made=20 i m starting postgres as: service postgresql start i mean when database server is improperly shutdown or some other error = condition etc must be logged somewhere is it in the serverlog file.?? Moreover i want to log all the steps that postmaster makes at startup... can anyone help me on this=20 =20 ------=_NextPart_000_010E_01C5B85C.CFAB76F0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
hi ppl,
       =20     I am using postgres7.3 version. I am unable to find any log.
       =20     all the files 
          &nbs= p; 1)=20 /usr/local/pgsql/data/serverlog
       =20     2) /var/log/pgsql
       =20     etc are empty
          &nbs= p;=20 pg_xlog and pg_clog directory files dont seem to be = meaningful.
 
i tried
log_connections =3D true
log_pid =3D = true
log_statement =3D true
log_duration =3D true
log_timestamp = =3D=20 true
log_min_error_statement =3D = debug5
 
 
but where this log_statement log will=20 go...
 
Moreover where databaseserver log = is made=20
i m starting postgres as:
service postgresql start
 
i mean when database server is = improperly shutdown=20 or some other error condition etc must be logged somewhere
is it in the serverlog = file.??
Moreover i want to log all the steps = that=20 postmaster makes at startup...
 
 
can anyone help me on this =
 
 
 
 
 
 

 
 
 
 
 
 
 
       =20    
 
 
       =20    
------=_NextPart_000_010E_01C5B85C.CFAB76F0--