On Wed, Mar 28, 2012 at 6:31 PM, Naoko Reeves <naokoreeves@xxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general