Re: Failed sanity check?

Yes, it seems like I can do anything to this database except run
pg_dump against it.  When this first happened, I copied all the data
out of the tables.  I've just finished manually rebuilding the tables
in schema and copying the data into most of the tables in a test
database.  I was able to copy the data into the new tables in all but
three cases.  Two of the three were text search tables that have
function names in them.  The functions are not in the new database
yet.  The third has some records with Asian characters.  I think,
because this database is designated as SQL_ASCII encoding, that the
pipe delimiter was confused on these records with other characters.
One other thing that may be a problem is that the database had two
tables that have sequences with the same name.  I was unable to
recreate that situation and I don't know how the user did it.

Thank you very much for your help.

Carol

On Feb 4, 2009, at 7:03 PM, Lee Azzarello wrote:

> Can you perform queries against tables in that database? You may have
> to poke around in the systems tables for the object ids in question.
>
> -lee
>
> On Wed, Feb 4, 2009 at 2:32 PM, Carol Walter <walterc@indiana.edu>
> wrote:
>> Hello,
>>
>> I'm getting this message when I try to back up one of my
>> databases.  Is
>> there something I can do about this?
>>
>> bash-3.00# pg_dump -U postgres citesrch > /pgdump/citesrch_bk.sql
>> pg_dump: failed sanity check, parent table OID 131956046 of
>> pg_rewrite entry
>> OID 131956048 not found
>>
>> Thanks,
>>
>> Carol
>>
>> --
>> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-admin
>>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin