Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 7B8FC47611A for ; Wed, 25 Sep 2002 14:18:41 -0400 (EDT) Received: from birch.ipaper.com (mx01.ipaper.com [141.129.1.7]) by postgresql.org (Postfix) with ESMTP id CA4D7476108 for ; Wed, 25 Sep 2002 14:18:40 -0400 (EDT) Received: from swmta1.ipaper.com (swmta1.ipaper.com [164.103.62.7]) by birch.ipaper.com (8.10.2+Sun/8.10.2) with ESMTP id g8PEH1S28663 for ; Wed, 25 Sep 2002 09:17:04 -0500 (CDT) Received: from swmta1.ipaper.com (swmta1.ipaper.com [164.103.62.7]) by birch.ipaper.com (8.10.2+Sun/8.10.2) with ESMTP id g8P0ZhS00384 for ; Tue, 24 Sep 2002 19:35:46 -0500 (CDT) X-Mailer: Lotus Notes Release 5.0.6a January 17, 2001 MIME-Version: 1.0 Subject: logging To: Message-ID: From: "Devinder K Rajput" Date: Wed, 25 Sep 2002 09:14:36 -0500 X-MIMETrack: Serialize by Router on SWMTA1.ipaper.com/IPAPER(Release 5.0.8 |June 18, 2001) at 09/25/2002 09:14:41 AM Content-type: text/plain; charset=us-ascii X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200209/267 X-Sequence-Number: 5806 Hi all, I am trying to setup logging. I have updated the postgresql.conf by making the following changes: #debug_level = 0 # range 0-16 debug_level = 2 # range 0-16 #debug_print_query = false debug_print_query = true ... # Syslog # #ifdef ENABLE_SYSLOG #syslog = 0 # range 0-2 syslog = 2 # range 0-2 I have also update the postgresql script that we use to start postmaster to redirect output to a log file rather than /dev/null. I get the following in the log file: postmaster successfully started invoking IpcMemoryCreate(size=1236992) FindExec: found "/usr/bin/postmaster" using argv[0] /usr/bin/postmaster: reaping dead processes... /usr/bin/postmaster: ServerLoop: handling reading 5 /usr/bin/postmaster: ServerLoop: handling reading 5 /usr/bin/postmaster: ServerLoop: handling reading 5 /usr/bin/postmaster: ServerLoop: handling reading 5 /usr/bin/postmaster: ServerLoop: handling writing 5 /usr/bin/postmaster: BackendStartup: pid 30039 user postgres db dioh socket 5 /usr/bin/postmaster child[30039]: starting with (postgres -d2 -v131072 -p dioh ) FindExec: found "/usr/bin/postgres" using argv[0] /usr/bin/postmaster: reaping dead processes... /usr/bin/postmaster: CleanupProc: pid 30039 exited with status 0 /usr/bin/postmaster: ServerLoop: handling reading 5 /usr/bin/postmaster: ServerLoop: handling reading 5 /usr/bin/postmaster: ServerLoop: handling reading 5 /usr/bin/postmaster: ServerLoop: handling reading 5 /usr/bin/postmaster: ServerLoop: handling writing 5 /usr/bin/postmaster: BackendStartup: pid 30054 user postgres db counterpoint soc ket 5 /usr/bin/postmaster child[30054]: starting with (postgres -d2 -v131072 -p counte rpoint ) .... I want the log file to show activity that occurs when queries are executed. But this seems to be only showing output when I open a psql session or log out of it. Could you please kindly let me know what I am missing. Thank you. p.s. The whole reason for turning on logging is that we are processing sales data from about 100 locations to generate inventory numbers. The program runs fine for all but 1 store. The problem is that postmaster keeps on running for about 3 days processing something when it only should take about 30 mintues. I figured maybe logging will show what postmaster is doing while it's on its 3 day cruise. Devinder Rajput Stores Division Corporate Offices Chicago, IL (773) 442-6474