Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 37455650193 for ; Wed, 20 Aug 2008 22:40:17 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 17962-03-4 for ; Wed, 20 Aug 2008 22:39:41 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 5C451650129 for ; Wed, 20 Aug 2008 22:38:04 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id m7L1c1BX010860; Wed, 20 Aug 2008 21:38:01 -0400 (EDT) To: "slamp slamp" cc: pgsql-admin@postgresql.org Subject: Re: pg_log directory In-reply-to: <78926d250808201343x41e6840cma213c92572ec4268@mail.gmail.com> References: <78926d250808201343x41e6840cma213c92572ec4268@mail.gmail.com> Comments: In-reply-to "slamp slamp" message dated "Wed, 20 Aug 2008 16:43:06 -0400" Date: Wed, 20 Aug 2008 21:38:01 -0400 Message-ID: <10859.1219282681@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200808/96 X-Sequence-Number: 29941 "slamp slamp" writes: > I am running postgresql-8.2.4 on rhel5. Do I need the files in pg_log? > When I look at one of the files, it shows INSERT, UPDATE and SELECT > statements. Reason I asked is because the folder is about 40GB. It is > half the size of my /var/lib/pgsql directory. That's just the server message log. While you could blow away the files without any ill effect, soon enough you'd have another 40GB. You need to either dial down the verbosity of your what-to-log settings, or modify the where-to-log settings to recycle log files more frequently, or both. In particular it sounds like you have set log_statement = all without, perhaps, understanding the consequences. Read the fine manual here: http://www.postgresql.org/docs/8.2/static/runtime-config-logging.html regards, tom lane