Skip site navigation (1) Skip section navigation (2)

Re: pg_log directory

From: "slamp slamp" <slackamp(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_log directory
Date: 2008-08-21 13:25:07
Message-ID: 78926d250808210625m222d1fbcn229d238ab37e7507@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
On Wed, Aug 20, 2008 at 9:38 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> 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
>

I am using the PGDG rpms. So it has the default logging configs. its
rotating daily but i have files there since 2007. is there a config
option to delete these files? i looked at the manual and i guess i
must be missing the option i want.

In response to

Responses

pgsql-admin by date

Next:From: Tom LaneDate: 2008-08-21 14:02:09
Subject: Re: pg_log directory
Previous:From: dkeeneyDate: 2008-08-21 12:35:26
Subject: privilege shedding

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group