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: (view raw, whole thread or download thread mbox)
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:
>                        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


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-2017 The PostgreSQL Global Development Group