server crash

Поиск
Список
Период
Сортировка
От Medora Schauer
Тема server crash
Дата
Msg-id 906E2C446A276048A1BE283F17BCB12C01BA8E2B@encounter.fairind.fairfield.com
обсуждение исходный текст
Ответы Re: server crash  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin

OS: linux 2.4.18

h/w: moto 5100 SBC

PG: 7.3

 

We have a recurring problem with the pg server crashing.  It doesn’t happen often (once every couple of months or so) but we require 24/7 up time.  Attached is the  pg.log from the last time it crashed.  The stuff towards the end seems to indicate some kind of serious problem but beyond that it means little to me.  I’m hoping it will be more meaningful to someone on this list.  Suggestions about how to obtain more information would also be welcome.

 

Is there any way to get timestamps in the log file?  It would be helpful to know which of the messages are related in a time sense at least.

 

Is there a description of the various postmaster debug levels?  I might try upping the level but since the crash doesn’t happen very often I would be helpful if I knew which level would yield the most useful information without clogging the file with unneeded detail.

 

Any help will be greatly appreciated,

 

Medora Schauer

 

Вложения

В списке pgsql-admin по дате отправления:

Предыдущее
От: Francisco Jose Bernabe Pellicer
Дата:
Сообщение: Re: Where is postgresql??
Следующее
От: Tom Lane
Дата:
Сообщение: Re: server crash