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@xxxxxxxxxxx>
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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
