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