From paul.wouters@resilion.be Wed Mar 21 15:24:25 2012 Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id 276B12F4278 for ; Wed, 21 Mar 2012 12:24:25 -0300 (ADT) Received: from mail.indicator.cz ([194.7.127.243] helo=imss.indicator.com) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SANOg-0000sC-C7 for pgsql-admin@postgresql.org; Wed, 21 Mar 2012 15:24:24 +0000 Received: from imss.indicator.com (localhost [127.0.0.1]) by smtp4.imss57 (Postfix) with ESMTP id 95F7AE25F320 for ; Wed, 21 Mar 2012 16:15:45 +0100 (CET) Received: from webaccess (unknown [10.100.1.7]) by imss.indicator.com (Postfix) with ESMTP id 8AB61E25F30C for ; Wed, 21 Mar 2012 16:15:45 +0100 (CET) Received: from LAPTPAW ([10.100.101.225]) by webaccess with ESMTP; Wed, 21 Mar 2012 16:24:06 +0100 From: "Paul Wouters" To: Subject: pg_dump: schema with OID 145167 does not exist Date: Wed, 21 Mar 2012 16:23:45 +0100 Message-ID: <000001cd0776$9b20b600$d1622200$@wouters@resilion.be> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0001_01CD077E.FCE51E00" X-Mailer: Microsoft Office Outlook 12.0 Thread-Index: Ac0HdpOoOfWh2jc4S0aU6LDfFxiH2w== Content-Language: nl-be X-Pg-Spam-Score: 0.0 (/) X-Archive-Number: 201203/120 X-Sequence-Number: 39308 This is a multi-part message in MIME format. ------=_NextPart_000_0001_01CD077E.FCE51E00 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 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 ------=_NextPart_000_0001_01CD077E.FCE51E00 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

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 =3D 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

------=_NextPart_000_0001_01CD077E.FCE51E00-- From paul.wouters@resilion.be Thu Mar 22 13:55:15 2012 Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 77758FA6B9C for ; Thu, 22 Mar 2012 10:55:15 -0300 (ADT) Received: from mail.apuntesyconsejos.es ([194.7.127.243] helo=imss.indicator.com) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SAiTx-0005ms-P1 for pgsql-admin@postgresql.org; Thu, 22 Mar 2012 13:55:15 +0000 Received: from imss.indicator.com (localhost [127.0.0.1]) by smtp4.imss57 (Postfix) with ESMTP id E87FBE2649D2 for ; Thu, 22 Mar 2012 14:46:35 +0100 (CET) Received: from webaccess (unknown [10.100.1.7]) by imss.indicator.com (Postfix) with ESMTP id DB526E264973 for ; Thu, 22 Mar 2012 14:46:35 +0100 (CET) Received: from LAPTPAW ([10.100.101.225]) by webaccess with ESMTP; Thu, 22 Mar 2012 14:54:58 +0100 From: "Paul Wouters" To: Subject: pg_dump: schema with OID 145167 does not exist Date: Thu, 22 Mar 2012 14:54:36 +0100 Message-ID: <000001cd0833$5197f580$f4c7e080$@wouters@resilion.be> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0001_01CD083B.B35C5D80" X-Mailer: Microsoft Office Outlook 12.0 Thread-Index: Ac0HdpOoOfWh2jc4S0aU6LDfFxiH2w== Content-Language: nl-be X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201203/113 X-Sequence-Number: 39301 This is a multi-part message in MIME format. ------=_NextPart_000_0001_01CD083B.B35C5D80 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 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 ------=_NextPart_000_0001_01CD083B.B35C5D80 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

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 =3D 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

------=_NextPart_000_0001_01CD083B.B35C5D80-- From Kevin.Grittner@wicourts.gov Thu Mar 22 15:49:42 2012 Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 01D614248 for ; Thu, 22 Mar 2012 12:49:42 -0300 (ADT) Received: from gwmta.wicourts.gov ([165.219.244.99] helo=gw.wicourts.gov) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SAkGi-0007s7-TP for pgsql-admin@postgresql.org; Thu, 22 Mar 2012 15:49:41 +0000 Received: from Courts-MTA by gw.wicourts.gov with Novell_GroupWise; Thu, 22 Mar 2012 10:49:28 -0500 Message-Id: <4F6B03AE02000025000465D5@gw.wicourts.gov> X-Mailer: Novell GroupWise Internet Agent 8.0.2 Date: Thu, 22 Mar 2012 10:49:18 -0500 From: "Kevin Grittner" To: , "Paul Wouters" Subject: Re: pg_dump: schema with OID 145167 does not exist References: <000001cd0833$5197f580$f4c7e080$@wouters@resilion.be> In-Reply-To: <000001cd0833$5197f580$f4c7e080$@wouters@resilion.be> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Pg-Spam-Score: -4.2 (----) X-Archive-Number: 201203/115 X-Sequence-Number: 39303 "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 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 From lukasz.brodziak@gmail.com Wed Apr 25 07:02:29 2012 Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id 67FEF1E62E80 for ; Wed, 25 Apr 2012 04:02:29 -0300 (ADT) Received: from mail-yx0-f174.google.com ([209.85.213.174]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SMwF8-0007nF-3Z for pgsql-admin@postgresql.org; Wed, 25 Apr 2012 07:02:28 +0000 Received: by yenl12 with SMTP id l12so926313yen.19 for ; Wed, 25 Apr 2012 00:02:12 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; bh=IVTMXoDptAcxUlj/QRxxiNM+f6SL8yJCMRCZPpm0++c=; b=pKaH1hxFSOclwkS1JoyXjI6N5DePmh216RYu91WTl4tRtd+qqWC07ZP8uqyokXvN0E kIO/yM5aNC2fzxE+BXpBLcvN/lDGqp4N1ouMIQhRu8YLMWyU0i0om32NfIZplkm1Qi+4 GUi1XBohq1SYy6YgMKdHNj74xNd+XNIyJhUcBe56CTFzEcD9bkaLofjrlNx5zCl7Nour bvWsJA5bkQRHublLfS16++LkDW2ds2jlY1H+IhVCPB9OX0dWWxeN6TQDPAoa7LLWZiEj 3NSlea4yyqYpctWF5bdwBakrLtTduOKUftASyxJ+LnyNUFGDNeViPHQ7gNvcTLEOIAEV 0bgw== MIME-Version: 1.0 Received: by 10.236.125.168 with SMTP id z28mr1221492yhh.120.1335337332785; Wed, 25 Apr 2012 00:02:12 -0700 (PDT) Received: by 10.101.32.19 with HTTP; Wed, 25 Apr 2012 00:02:12 -0700 (PDT) In-Reply-To: <4f6c9713.249cec0a.1c3e.ffffa709SMTPIN_ADDED@mx.google.com> References: <4f6c9713.249cec0a.1c3e.ffffa709SMTPIN_ADDED@mx.google.com> Date: Wed, 25 Apr 2012 09:02:12 +0200 Message-ID: Subject: Re: pg_dump: schema with OID 145167 does not exist From: Lukasz Brodziak To: Paul Wouters Cc: pgsql-admin@postgresql.org Content-Type: multipart/alternative; boundary=20cf3036388b60442e04be7b731b X-Pg-Spam-Score: -2.7 (--) X-Archive-Number: 201204/127 X-Sequence-Number: 39463 --20cf3036388b60442e04be7b731b Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable 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 > 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 th= e > row in the pg_type, I get an error:**** > > Error: Invalid input syntax for type oid: =E2=80=9Crecord_in=E2=80=9D**** > > ** ** > > select * from pg_type where typnamespace =3D 145167;**** > > typname | typnamespace | typowner | typlen | typbyval | typtype = | > typisdefined | typdelim | typrelid | typelem | typinput | typoutput | > typreceive | typsend | typanalyze | typalign | typstorage | typnotnu= ll > | 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**** > --=20 =C5=81ukasz 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" --20cf3036388b60442e04be7b731b Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi,

Once I had the same problem with not existing sche= ma. 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 operat= ion we migrated all the DBs including the one to 9.0.6 and everything works= fine.

Hope this h= elps.

= Regards=C2=A0
Luke

2012/3/21 Paul Wouters <paul.wouters@resilion.be><= /span>

Hello,

=C2=A0

We have some problems using pg_= dump. We get the following error:

pg_dump: schema with OID 145167 does not exist

=C2=A0

=

I found one entry in the pg_typ= e and another one in the pg_class.

I was able to remove the one in the pg_class bu= t when we try to remove the row in the pg_type, I get an error:

Error: Invalid input syntax for= type oid: =E2=80=9Crecord_in=E2=80=9D

=C2=A0

select * from pg_type where typnamespace = =3D 145167;

=C2=A0=C2=A0=C2=A0=C2=A0 typnam= e=C2=A0=C2=A0=C2=A0=C2=A0 | typnamespace | typowner | typlen | typbyval | t= yptype | typisdefined | typdelim | typrelid | typelem | typinput=C2=A0 | ty= poutput=C2=A0 | typreceive =C2=A0|=C2=A0=C2=A0 typsend=C2=A0=C2=A0 | typana= lyze | typalign | typstorage | typnotnull | typbasetype | typtypmod | typnd= ims | typdefaultbin | typdefault

-----------------+-------------= -+----------+--------+----------+---------+--------------+----------+------= ----+---------+-----------+------------+-------------+-------------+-------= -----+----------+------------+------------+-------------+-----------+------= ----+---------------+------------

trainings0rrtop |=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0 145167 |=C2=A0=C2=A0=C2=A0 25488 |=C2=A0=C2=A0=C2= =A0=C2=A0 -1 | f=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 | c=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0 | t=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0 | ,=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 |=C2=A0= =C2=A0 145208 |=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 0 | record_in | record_= out | record_recv | record_send | -=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0 | d=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 | x=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 | f=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 |=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0 0 |=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 -1 |=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 0 |=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 | =

(1 row)

=C2=A0

In the table pg_depend I have = also e reference to 124208

Can I Also remove that dependen= cy?

= =C2=A0

We = are using the 8.2.5 version of PG.

=C2=A0

=

Kind regards

Paul




--
=C5=81ukasz= Brodziak
"Do you bury me when I'm gone
Do you teach me whi= le I'm here
Just as soon I belong
Then it's time I disappear"
--20cf3036388b60442e04be7b731b--