X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 7C57B9F97C2 for ; Thu, 6 Jul 2006 21:52:59 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 54975-08 for ; Thu, 6 Jul 2006 21:52:49 -0300 (ADT) X-Greylist: delayed 00:29:15.927134 by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id EBBCD9FA65C for ; Thu, 6 Jul 2006 21:52:49 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from mail.pienetworks.com (unknown [210.9.196.17]) by svr4.postgresql.org (Postfix) with ESMTP id 4D1FC5AF042 for ; Fri, 7 Jul 2006 00:23:31 +0000 (GMT) Received: by mail.pienetworks.com (Postfix, from userid 521) id 67CAD5F4EEE; Fri, 7 Jul 2006 08:23:20 +0800 (WST) Received: from tuppy.pienetworks.com (tuppy.pienetworks.com [192.168.1.72]) by mail.pienetworks.com (Postfix) with ESMTP id D2CDD5F4EED for ; Fri, 7 Jul 2006 08:23:17 +0800 (WST) Subject: Just checking... From: Enzo Daddario To: PGADMIN Content-Type: text/plain Date: Fri, 07 Jul 2006 08:23:17 +0800 Message-Id: <1152231797.2849.19.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.0.4 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/39 X-Sequence-Number: 22285 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: 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" 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...