Re: Postgres database is not logging any messages after the reboot

Поиск
Список
Период
Сортировка
От Bhella Paramjeet-PFCW67
Тема Re: Postgres database is not logging any messages after the reboot
Дата
Msg-id C84662912D280D4AB5C50100A100F0C502D9CE21@ct11exm61.ds.mot.com
обсуждение исходный текст
Ответ на Re: Postgres database is not logging any messages after the reboot  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Postgres database is not logging any messages after the reboot  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
Hi Tom

After the server reboot nothing is getting logged by the postgres
database into pg_log like messages about archived log, autovacuum,
panic, alerts etc. The alerts from the pglogs get forwarded to our cell
phones and since no messages are getting logged we will not get notified
in case of a problem with database. This is the first time we have seen
this strange behaviour. Your help in resolving the issue will be highly
appreciated.

Thanks
Paramjeet Kaur

-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Thursday, October 11, 2007 7:30 AM
To: Bhella Paramjeet-PFCW67
Cc: pgsql-admin@postgresql.org; Subbiah Stalin-XCGF84
Subject: Re: [ADMIN] Postgres database is not logging any messages after
the reboot

"Bhella Paramjeet-PFCW67" <PBhella@Motorola.com> writes:
> Here are the messages from the pg_log before and after server reboot.

Uh, I don't see the problem?  That looks like a perfectly normal
crash-recovery process, and it certainly doesn't seem to be the case
that "nothing is getting logged".  What were you expecting to see?

            regards, tom lane

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

Предыдущее
От: "Agustin Ignacio Genoves"
Дата:
Сообщение: Re: how to create an user with ONLY select permission and nothing else?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Postgres database is not logging any messages after the reboot