pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpg_dump: schema with OID 145167 does not exist
4+ messages / 3 participants
[nested] [flat]
* pg_dump: schema with OID 145167 does not exist
@ 2012-03-21 15:23 Paul Wouters <paul.wouters@resilion.be>
0 siblings, 0 replies; 4+ messages in thread
From: Paul Wouters @ 2012-03-21 15:23 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* pg_dump: schema with OID 145167 does not exist
@ 2012-03-22 13:54 Paul Wouters <paul.wouters@resilion.be>
2012-03-22 15:49 ` Re: pg_dump: schema with OID 145167 does not exist Kevin Grittner <Kevin.Grittner@wicourts.gov>
0 siblings, 1 reply; 4+ messages in thread
From: Paul Wouters @ 2012-03-22 13:54 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: pg_dump: schema with OID 145167 does not exist
2012-03-22 13:54 pg_dump: schema with OID 145167 does not exist Paul Wouters <paul.wouters@resilion.be>
@ 2012-03-22 15:49 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
0 siblings, 0 replies; 4+ messages in thread
From: Kevin Grittner @ 2012-03-22 15:49 UTC (permalink / raw)
To: pgsql-admin; Paul Wouters <paul.wouters@resilion.be>
"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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: pg_dump: schema with OID 145167 does not exist
@ 2012-04-25 07:02 Lukasz Brodziak <lukasz.brodziak@gmail.com>
0 siblings, 0 replies; 4+ messages in thread
From: Lukasz Brodziak @ 2012-04-25 07:02 UTC (permalink / raw)
To: Paul Wouters <paul.wouters@resilion.be>; +Cc: pgsql-admin
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 helps.
Regards
Luke
2012/3/21 Paul Wouters <paul.wouters@resilion.be>
> 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****
>
--
Łukasz Brodziak
"Do you bury me when I'm gone
Do you teach me while I'm here
Just as soon I belong
Then it's time I disappear"
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2012-04-25 07:02 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2012-03-21 15:23 pg_dump: schema with OID 145167 does not exist Paul Wouters <paul.wouters@resilion.be>
2012-03-22 13:54 pg_dump: schema with OID 145167 does not exist Paul Wouters <paul.wouters@resilion.be>
2012-03-22 15:49 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
2012-04-25 07:02 Re: pg_dump: schema with OID 145167 does not exist Lukasz Brodziak <lukasz.brodziak@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox