Re: pg_dump: error

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
not.

> 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
appears.

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 — https://www.EnterpriseDB.com/