Re: FW: Serverlog 100GB

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Randy How" <rhow(at)i3(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: FW: Serverlog 100GB
Date: 2006-08-25 04:36:41
Message-ID: 18476.1156480601@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Randy How" <rhow(at)i3(dot)com> writes:
> We're running PostGres on linux, version 8.1.x. on a new server for a few
> weeks. And the serverlog just consumed the rest of the disk space - 100GB
> log file. Wow, that's a personal record.

Perhaps choose less verbose logging settings? But really the correct
answer to this is to set up a logfile rotation schedule, which you can
easily do with either syslog or redirect_stderr log methods. I'd lean
to the latter myself.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rafal Pietrak 2006-08-25 05:57:52 multimpe records output from a 'no-table' source
Previous Message Tom Lane 2006-08-25 04:24:37 Re: lock table problem