| From: | Andrew Sullivan <andrew(at)libertyrms(dot)info> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: [GENERAL] log sql? |
| Date: | 2002-07-30 18:09:39 |
| Message-ID: | 20020730140939.E16703@mail.libertyrms.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general |
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(at)libertyrms(dot)info> M6K 3E3
+1 416 646 3304 x110
| From | Date | Subject | |
|---|---|---|---|
| Next Message | scott.marlowe | 2002-07-30 18:32:50 | Re: [GENERAL] log sql? |
| Previous Message | Laurette Cisneros | 2002-07-30 16:53:23 | Re: [GENERAL] log sql? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Phil Glatz | 2002-07-30 18:13:42 | sorting by week? |
| Previous Message | Seum-Lim Gan | 2002-07-30 17:53:26 | PosgreSQL 10 things to know about ? |