Re: validating database integrity

From: lst_hoe02(at)kwsoft(dot)de
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: validating database integrity
Date: 2011-04-27 08:38:38
Message-ID: 20110427103838.17521a37t5wp1atc@webmail.kwsoft.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Zitat von Scott Ribe <scott_ribe(at)elevated-dev(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Suprabhat 2011-04-27 11:55:13 BUG #5995: connection pooling not working
Previous Message lst_hoe02 2011-04-27 08:33:30 Re: Scaling