Re: [ADMIN] pg_dump: schema with OID 145167 does not exist

2012-04-25 Thread Lukasz Brodziak
Hi, Once I had the same problem with not existing schema. In my case removing all the references to the schema worked fine and I had no problems with the db ever since. It wa PG 8.2.1 and since the operation we migrated all the DBs including the one to 9.0.6 and everything works fine. Hope this h

[ADMIN] pg_dump: schema with OID 145167 does not exist

2012-03-23 Thread Paul Wouters
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

Re: [ADMIN] pg_dump: schema with OID 145167 does not exist

2012-03-22 Thread Kevin Grittner
"Paul Wouters" 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 referenc

[ADMIN] pg_dump: schema with OID 145167 does not exist

2012-03-22 Thread Paul Wouters
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