Re: could not read block... how could I identify/fix - Mailing list pgsql-general

From Naoko Reeves
Subject Re: could not read block... how could I identify/fix
Date
Msg-id CAGoos16tusr9v_EaCbEeD8LAERSX=NjtLqbgCrx4XTkF+DmgRA@mail.gmail.com
Whole thread Raw
In response to Re: could not read block... how could I identify/fix  (Vick Khera <vivek@khera.org>)
Responses Re: could not read block... how could I identify/fix
List pgsql-general
Vick,
Thank you very much. Yes, I just go ahead did what you said and all appears to be fine.


On Thu, Mar 29, 2012 at 7:08 AM, Vick Khera <vivek@khera.org> wrote:
On Wed, Mar 28, 2012 at 6:31 PM, Naoko Reeves <naokoreeves@gmail.com> wrote:
> Do you think this should be the next step I might take?
> Could you give me an advice of how I could identify corrupted error.

It seems to me that since you can successfully dump the table (I
assume you validated the data was all there somehow), you should go
ahead and dump your whole DB, delete the current one, create it again,
then restore it from scratch.

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



--
Naoko Reeves

pgsql-general by date:

Previous
From: Bret Stern
Date:
Subject: Re: Move Tables From One Database to Another
Next
From: leaf_yxj
Date:
Subject: Re: system catalog privilege and create privilege ??? how to control them?? thanks