[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-admin
Subject: Re: [ADMIN] pg_dump: schema with OID 145167 does not exist
From: Lukasz Brodziak <lukasz.brodziak () gmail ! com>
Date: 2012-04-25 7:02:12
Message-ID: CAGWYGjUdFA-UKSptper9nx8dV4C2uz+CvczU6=oO2teZ6m6GdQ () mail ! gmail ! com
[Download RAW message or body]
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"
[Attachment #3 (text/html)]
<div class="gmail_extra">Hi,</div><div class="gmail_extra"><br></div><div \
class="gmail_extra">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.</div> <div \
class="gmail_extra"><br></div><div class="gmail_extra">Hope this helps.</div><div \
class="gmail_extra"><br></div><div class="gmail_extra">Regards </div><div \
class="gmail_extra">Luke<br><br><div class="gmail_quote">2012/3/21 Paul Wouters <span \
dir="ltr"><<a href="mailto:paul.wouters@resilion.be" \
target="_blank">paul.wouters@resilion.be</a>></span><br> <blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"><div lang="NL-BE" link="blue" vlink="purple"><div><p \
class="MsoNormal">Hello,<u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></p> \
<p class="MsoNormal"><span lang="EN-US">We have some problems using pg_dump. We get \
the following error:<u></u><u></u></span></p><p class="MsoNormal"><span \
lang="EN-US">pg_dump: schema with OID 145167 does not exist<u></u><u></u></span></p> \
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p><p \
class="MsoNormal"><span lang="EN-US">I found one entry in the pg_type and another one \
in the pg_class.<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US">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:<u></u><u></u></span></p> <p class="MsoNormal"><span \
lang="EN-US">Error: Invalid input syntax for type oid: \
"record_in"<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US"><u></u> \
<u></u></span></p><p class="MsoNormal"><span lang="EN-US">select * from pg_type where \
typnamespace = 145167;<u></u><u></u></span></p> <p class="MsoNormal"><span \
lang="EN-US"> typname | typnamespace | typowner | typlen | typbyval | \
typtype | typisdefined | typdelim | typrelid | typelem | typinput | typoutput | \
typreceive | typsend | typanalyze | typalign | typstorage | typnotnull | \
typbasetype | typtypmod | typndims | typdefaultbin | typdefault \
<u></u><u></u></span></p> <p class="MsoNormal"><span \
lang="EN-US">-----------------+--------------+----------+--------+----------+--------- \
+--------------+----------+----------+---------+-----------+------------+------------- \
+-------------+------------+----------+------------+------------+-------------+-----------+----------+---------------+------------<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> trainings0rrtop | 145167 | \
25488 | -1 | f | c | t | , \
| 145208 | 0 | record_in | record_out | record_recv | record_send | - \
| d | x | f | 0 \
| -1 | 0 | | \
<u></u><u></u></span></p> <p class="MsoNormal"><span lang="EN-US">(1 \
row)<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US"><u></u> \
<u></u></span></p><p class="MsoNormal"><span lang="EN-US">In the table pg_depend I \
have also e reference to 124208<u></u><u></u></span></p> <p class="MsoNormal"><span \
lang="EN-US">Can I Also remove that dependency?<u></u><u></u></span></p><p \
class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p><p \
class="MsoNormal"><span lang="EN-US">We are using the 8.2.5 version of \
PG.<u></u><u></u></span></p> <p class="MsoNormal"><span lang="EN-US"><u></u> \
<u></u></span></p><p class="MsoNormal"><span lang="EN-US">Kind regards<span \
class="HOEnZb"><font color="#888888"><u></u><u></u></font></span></span></p><span \
class="HOEnZb"><font color="#888888"><p class="MsoNormal"> <span \
lang="EN-US">Paul<u></u><u></u></span></p></font></span></div></div></blockquote></div><br><br \
clear="all"><div><br></div>-- <br>Łukasz Brodziak<br>"Do you bury me when \
I'm gone<br> Do you teach me while I'm here<br> Just as soon I belong<br> \
Then it's time I disappear"<br> </div>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic