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
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
"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
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.
"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
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
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