Re: pg_log directory

"slamp slamp" <slackamp(at)gmail(dot)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