Re: Scary behavior after power failure - Mailing list pgsql-general

From Tom Lane
Subject Re: Scary behavior after power failure
Date
Msg-id 22396.1084543397@sss.pgh.pa.us
Whole thread Raw
In response to Scary behavior after power failure  (John Siracusa <siracusa@mindspring.com>)
List pgsql-general
John Siracusa <siracusa@mindspring.com> writes:
> We had a power failure (and a UPS failure) on our database machine.  It's
> back  up now but some spooky stuff is happening.

I'm wondering if you are using IDE drives that lie about write
completion.  You'd never notice until something like this happens.

> Is there any way I can "sanity check" the remaining tables for craziness
> like this?

dump, initdb, reload would be my suggestion.

            regards, tom lane

pgsql-general by date:

Previous
From: Paolo Tavalazzi
Date:
Subject: slow query if add order by
Next
From: Doug McNaught
Date:
Subject: Re: LISTEN/NOTIFY with JDBC