Re: [GENERAL] log sql? - Mailing list pgsql-admin

From Andrew Sullivan
Subject Re: [GENERAL] log sql?
Date
Msg-id 20020730140939.E16703@mail.libertyrms.com
Whole thread Raw
In response to Re: [GENERAL] log sql?  (Laurette Cisneros <laurette@nextbus.com>)
Responses Re: [GENERAL] log sql?  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-admin
On Tue, Jul 30, 2002 at 09:53:23AM -0700, Laurette Cisneros wrote:
> Yes indeed...the size has reach 9.6M in 15 minutes...it is spewing a lot of
> info.  Hmmm....

You really need some mechanism for rotating your logs if you are
going to use them.  Otherwise, they become too unwieldy.

> > once you do that keep an eye over the log file size..
> > i rember messing up once on this,, postmaster will core dump
> > once size(log_file)> 2.1 GB.

I'll bet that's system-dependent.  Probably on a filesystem that
handles files larger than 2G, it doesn't crash.  Not that you'd want
to have to manage a 2 gig log file.

A

--
----
Andrew Sullivan                               87 Mowat Avenue
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M6K 3E3
                                         +1 416 646 3304 x110


pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: newbie admin question: postgresql server crashes
Next
From: joe.f.miller@wcom.com (Joe)
Date:
Subject: Re: Could not connect to remote socket