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

2007-10-19 Thread Alvaro Herrera
Bhella Paramjeet-PFCW67 wrote: > Hi > > The server that hosts our production postgres databases had to be > rebooted last night as the file systems got remounted as read only. > After the reboot we re-started the databases but now nothing is getting > logged into the pglogs. Can you please assist

[ADMIN] Postgres database is not logging any messages after the reboot

2007-10-19 Thread Bhella Paramjeet-PFCW67
Hi The server that hosts our production postgres databases had to be rebooted last night as the file systems got remounted as read only. After the reboot we re-started the databases but now nothing is getting logged into the pglogs. Can you please assist us in figuring out the problem and help re

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

2007-10-11 Thread Tom Lane
"Bhella Paramjeet-PFCW67" <[EMAIL PROTECTED]> writes: > After the server reboot nothing is getting logged by the postgres > database into pg_log like messages about archived log, autovacuum, > panic, alerts etc. Sounds to me like you changed your logging settings... regard

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

2007-10-11 Thread Bhella Paramjeet-PFCW67
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" <[EMAIL PROTECTED]> writes: > Here are the messages from the pg_log before and after server reboot.

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

2007-10-11 Thread Tom Lane
"Bhella Paramjeet-PFCW67" <[EMAIL PROTECTED]> 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". Wha

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

2007-10-11 Thread Bhella Paramjeet-PFCW67
Here are the messages from the pg_log before and after server reboot. 2007-10-10 06:22:50 CDT LOG: archived transaction log file "000100700090" 2007-10-10 06:29:04 CDT LOG: autovacuum: processing database "nsc" 2007-10-10 06:34:58 CDT LOG: archived transaction log file "000

[ADMIN] Postgres database is not logging any messages after the reboot

2007-10-11 Thread Bhella Paramjeet-PFCW67
Hi The server that hosts our production postgres databases had to be rebooted last night as the file systems got remounted as read only. After the reboot we re-started the databases but now nothing is getting logged into the pglogs. Can you please assist us in figuring out the problem and help re