validating database integrity

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: "[ADMIN]" <pgsql-admin(at)postgresql(dot)org>
Subject: validating database integrity
Date: 2011-04-25 20:14:14
Message-ID: EC39C29B-87B7-4298-8A71-579FD5F94BAD@elevated-dev.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Just had a hard crash, and pg came back looking ok. However, crash was in the driver for the (battery-backed) RAID card, and I know for a fact that one file that was written to the (journaled) file system before the crash was not there after reboot. So, what steps are recommended to make sure pg files are ok?

Yeah, battery-backed cache does no good if the driver is crap...

--
Scott Ribe
scott_ribe(at)elevated-dev(dot)com
http://www.elevated-dev.com/
(303) 722-0567 voice

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Willy-Bas Loos 2011-04-26 15:36:49 [GENERAL]auto vacuum during restore
Previous Message Robert Haas 2011-04-25 19:57:17 Re: [BUGS] [JDBC] Missing documentation for error code: 80S01