Just checking...

From: Enzo Daddario <enzo(at)pienetworks(dot)com>
To: PGADMIN <pgsql-admin(at)postgresql(dot)org>
Subject: Just checking...
Date: 2006-07-07 00:23:17
Message-ID: 1152231797.2849.19.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Browse pgsql-admin by date

  From Date Subject
Next Message adey 2006-07-07 00:25:36 PGAdmin "Jobs"
Previous Message Moritz Bayer 2006-07-06 21:14:25 Need Help with Logfile Entry