Re: [GENERAL] log sql?

Поиск
Список
Период
Сортировка
От Andrew Sullivan
Тема Re: [GENERAL] log sql?
Дата
Msg-id 20020730140939.E16703@mail.libertyrms.com
обсуждение исходный текст
Ответ на Re: [GENERAL] log sql?  (Laurette Cisneros <laurette@nextbus.com>)
Ответы Re: [GENERAL] log sql?  ("scott.marlowe" <scott.marlowe@ihs.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: newbie admin question: postgresql server crashes
Следующее
От: joe.f.miller@wcom.com (Joe)
Дата:
Сообщение: Re: Could not connect to remote socket