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

From: "Bhella Paramjeet-PFCW67" <PBhella(at)Motorola(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-admin(at)postgresql(dot)org>, "Subbiah Stalin-XCGF84" <SSubbiah(at)Motorola(dot)com>
Subject: Re: Postgres database is not logging any messages after the reboot
Date: 2007-10-11 22:34:53
Message-ID: C84662912D280D4AB5C50100A100F0C502D9CE21@ct11exm61.ds.mot.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Thursday, October 11, 2007 7:30 AM
To: Bhella Paramjeet-PFCW67
Cc: pgsql-admin(at)postgresql(dot)org; Subbiah Stalin-XCGF84
Subject: Re: [ADMIN] Postgres database is not logging any messages after
the reboot

"Bhella Paramjeet-PFCW67" <PBhella(at)Motorola(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2007-10-11 22:38:41 Re: Postgres database is not logging any messages after the reboot
Previous Message Agustin Ignacio Genoves 2007-10-11 20:13:06 Re: how to create an user with ONLY select permission and nothing else?