"ERROR: could not read block 4459549 in file "base/16384/16956.34": Result too large" - Mailing list pgsql-general

From wetter wetterana
Subject "ERROR: could not read block 4459549 in file "base/16384/16956.34": Result too large"
Date
Msg-id CAMPbDaXxUp_vHdMmrYAhHWdFhJtD1sy7PyJhE37qfrXFJ9imHw@mail.gmail.com
Whole thread Raw
Responses Re: "ERROR: could not read block 4459549 in file "base/16384/16956.34": Result too large"
List pgsql-general
Hey, 

I got a huge database which I am populating in batches. One of the tables seemed to got 'corrupted.' I cannot query it anymore. I'm pretty sure that I could identify the batch of rows where the mistake must be, so if I could somehow revert it to an earlier state or temporary query it, I could try to delete the last batch of records I added, which might solve the problem.

I already tried to add "zero_damaged_pages = on"  to the postgresql.conf as suggested in another post here, but even then I wasn't able to query the table. 

Any help would be much appreciate, especially since I'm a psql novice ;)

Thanks!

Ana

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: ON_ERROR_ROLLBACK
Next
From: Suresh Raja
Date:
Subject: Re: localtime(0)