From: Enzo Daddario <enzo@pienetworks.com>
To: PGADMIN <pgsql-admin@postgresql.org>
Subject: Just checking...
Date: Fri, 07 Jul 2006 08:23:17 +0800
Message-ID: <1152231797.2849.19.camel@localhost.localdomain> (raw)
Hi All,
This morning our DB server (running postgres 8.1.4) went down
unexpectedly during a pg_dump(definitely not saying that this was the
cause) and the server required a hard reboot (unfortunately I was left
with no other choice)...
When I restarted, everything seemed to be OK, however I noticed a couple
of messages in the postgres logs that I am unsure of. The log is as
follows:
<snip>
ERROR: relation pg_toast_17183 does not exist
...
...
...
LOG: database system was interrupted at 2006-07-07 04:38:11 WST
LOG: checkpoint record is at 41/35458E18
LOG: redo record is at 41/35458E18; undo record is at 0/0; shutdown
FALSE
LOG: next transaction ID: 312814968; next OID: 141469
LOG: next MultiXactId: 34508; next MultiXactOffset: 71080
LOG: database system was not properly shut down; automatic recovery in
progress
LOG: redo starts at 41/35458E5C
LOG: record with zero length at 41/355743DC
LOG: redo done at 41/355743B4
LOG: could not truncate directory "pg_multixact/members": apparent
wraparound
LOG: database system is ready
LOG: transaction ID wrap limit is 1374623292, limited by database
"piearchive"
</snip>
I am particularly concerned with a couple of lines:
LOG: could not truncate directory "pg_multixact/members": apparent
wraparound
ERROR: relation pg_toast_17183 does not exist
Should I be concerned about either of the above messages, and if so,
what should I do???
--------------------------------------------------------------------
On another note, as part of regular VACUUMING should I also be doing the
template0, template1 & postgres databases???
--------------------------------------------------------------------
Thanks in advance...
Enzo...
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: enzo@pienetworks.com
Subject: Re: Just checking...
In-Reply-To: <1152231797.2849.19.camel@localhost.localdomain>
References: <1152231797.2849.19.camel@localhost.localdomain>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox