Re: pg_dump: error

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]


CCing pgsql-admin, removed -bugs.

On 2023-Feb-22, Alessandro Papa - Infolab wrote:

> Hi, i have a PostgreSQL db with 9.8 version,

You'll have to figure out exactly what version it is, because 9.8 it is

> When I try to make a backup I get this error:
> <pg_dump: error: schema with OID 2535211008 does not exist>
> I had already searched on the table "pg_conversion" but didn't find that OID, idem on "pg_namespace" or "pg_type"
> I had searched on forum but I have not found anything.

A reference to a schema could come from almost any other catalog, not
just pg_conversion.  (Note that a "namespace" is essentially the same as
a "schema" in our usage).  That particular error in the 9.6.24 pg_dump
source could come from 

   1   4218  /pgsql/source/REL9_6_STABLE/src/bin/pg_dump/pg_dump.c <<getTypes>>
   2   4432  /pgsql/source/REL9_6_STABLE/src/bin/pg_dump/pg_dump.c <<getOperators>>
   3   4519  /pgsql/source/REL9_6_STABLE/src/bin/pg_dump/pg_dump.c <<getCollations>>
   4   4600  /pgsql/source/REL9_6_STABLE/src/bin/pg_dump/pg_dump.c <<getConversions>>
   5   4765  /pgsql/source/REL9_6_STABLE/src/bin/pg_dump/pg_dump.c <<getOpclasses>>
   6   4853  /pgsql/source/REL9_6_STABLE/src/bin/pg_dump/pg_dump.c <<getOpfamilies>>
   7   5060  /pgsql/source/REL9_6_STABLE/src/bin/pg_dump/pg_dump.c <<getAggregates>>
   8   5328  /pgsql/source/REL9_6_STABLE/src/bin/pg_dump/pg_dump.c <<getFuncs>>
   9   6114  /pgsql/source/REL9_6_STABLE/src/bin/pg_dump/pg_dump.c <<getTables>>
  10   8450  /pgsql/source/REL9_6_STABLE/src/bin/pg_dump/pg_dump.c <<getTSParsers>>
  11   8534  /pgsql/source/REL9_6_STABLE/src/bin/pg_dump/pg_dump.c <<getTSDictionaries>>
  12   8615  /pgsql/source/REL9_6_STABLE/src/bin/pg_dump/pg_dump.c <<getTSTemplates>>
  13   8693  /pgsql/source/REL9_6_STABLE/src/bin/pg_dump/pg_dump.c <<getTSConfigurations>>
  14   9142  /pgsql/source/REL9_6_STABLE/src/bin/pg_dump/pg_dump.c <<getDefaultACLs>>

which are the places that call findNamespace, where the error message

Give that a look and see if any clues arise.  You can follow up here
afterwards for more ...

Álvaro Herrera               48°01'N 7°57'E  —

[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux