Обсуждение: pg_dump: schema with OID 145167 does not exist
Hello,
We have some problems using pg_dump. We get the following error:
pg_dump: schema with OID 145167 does not exist
I found one entry in the pg_type and another one in the pg_class.
I was able to remove the one in the pg_class but when we try to remove the row in the pg_type, I get an error:
Error: Invalid input syntax for type oid: “record_in”
select * from pg_type where typnamespace = 145167;
typname | typnamespace | typowner | typlen | typbyval | typtype | typisdefined | typdelim | typrelid | typelem | typinput | typoutput | typreceive | typsend | typanalyze | typalign | typstorage | typnotnull | typbasetype | typtypmod | typndims | typdefaultbin | typdefault
-----------------+--------------+----------+--------+----------+---------+--------------+----------+----------+---------+-----------+------------+-------------+-------------+------------+----------+------------+------------+-------------+-----------+----------+---------------+------------
trainings0rrtop | 145167 | 25488 | -1 | f | c | t | , | 145208 | 0 | record_in | record_out | record_recv | record_send | - | d | x | f | 0 | -1 | 0 | |
(1 row)
In the table pg_depend I have also e reference to 124208
Can I Also remove that dependency?
We are using the 8.2.5 version of PG.
Kind regards
Paul
"Paul Wouters" <paul.wouters@resilion.be> wrote: > We have some problems using pg_dump. We get the following error: > > pg_dump: schema with OID 145167 does not exist Make sure you have a copy of the entire PostgreSQL data directory tree before trying to fix corruption. > In the table pg_depend I have also e reference to 124208 > > Can I Also remove that dependency? You might need to delete those, after making that backup. > We are using the 8.2.5 version of PG. For starters you should upgrade to the last version of the now-out-of-support 8.2 release. After getting past the immediate issue with the dump, you should look at upgrading to a supported release. www.postgresql.org/support/versioning/ -Kevin