Re: validating database integrity - Mailing list pgsql-admin

From lst_hoe02@kwsoft.de
Subject Re: validating database integrity
Date
Msg-id 20110427103838.17521a37t5wp1atc@webmail.kwsoft.de
Whole thread Raw
In response to validating database integrity  (Scott Ribe <scott_ribe@elevated-dev.com>)
List pgsql-admin
Zitat von Scott Ribe <scott_ribe@elevated-dev.com>:

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

I would say a full dump will let you know, at least for the data.

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

Or the battery is leaking :-)

Regards

Andreas



Attachment

pgsql-admin by date:

Previous
From: lst_hoe02@kwsoft.de
Date:
Subject: Re: Scaling
Next
From: Mark Stosberg
Date:
Subject: best practice for moving millions of rows to child table when setting up partitioning?