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/
