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@xxxxxxxxxxxxx] Sent: Thursday, October 11, 2007 7:30 AM To: Bhella Paramjeet-PFCW67 Cc: pgsql-admin@xxxxxxxxxxxxxx; Subbiah Stalin-XCGF84 Subject: Re: Postgres database is not logging any messages after the reboot "Bhella Paramjeet-PFCW67" <PBhella@xxxxxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
