Re: pg_dump fails pg_rewrite entry not found

I am terribly sorry. I was sinked in this for about 2 days and just a
few minutes after i posted this a was told by a 3rd person that I am
using datbase postgres instead of eb3_nz to searched for pending OID in
pg_rewrite. So the common delete from pg_rewrite where oid = 1001837 worked.
Thanks a lot.

On 03/14/2014 03:11 PM, Adrian Klaver wrote:
> On 03/14/2014 06:56 AM, Jakub Can wrote:
>> Hello, our database suddenly went broken somehow. We still dont know if
>> it is becouse of hw failure etc., anyway, when I try to make dump using
>> pg_dump or pg_dumpall I have got error message like this:
>>
>> pg_dump: failed sanity check, parent table OID 1001834 of pg_rewrite
>> entry OID 1001837 not found
>> pg_dumpall: pg_dump failed on database "eb3_nz", exiting
>>
>> I have tried to search for such an error and have found a lot of
>> solution suggestions, but nothing worked for me, because I did not found
>> any record in pg_class, or pg_rewrite, etc. referencing to those OIDs
>> 1001834 or 1001837 . The version of postgres is 9.2.2
>>
>> Please is there any other place, where to look for the error?
>
> So 'select * from pg_rewrite where oid = 1001837' finds nothing?
>
>>
>> Thank you in advance,
>> Jakub.
>>
>>
>
>