"slamp slamp" <slackamp@xxxxxxxxx> 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
