From: Tom Lane <tgl@sss.pgh.pa.us>
To: slamp slamp <slackamp@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: pg_log directory
Date: Wed, 20 Aug 2008 21:38:01 -0400
Message-ID: <10859.1219282681@sss.pgh.pa.us> (raw)
In-Reply-To: <78926d250808201343x41e6840cma213c92572ec4268@mail.gmail.com>
References: <78926d250808201343x41e6840cma213c92572ec4268@mail.gmail.com>
"slamp slamp" <slackamp@gmail.com> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, slackamp@gmail.com
Subject: Re: pg_log directory
In-Reply-To: <10859.1219282681@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox