Re: Cannot pg_dump_all anymore... - Mailing list pgsql-general

From Greg Sabino Mullane
Subject Re: Cannot pg_dump_all anymore...
Date
Msg-id CAKAnmmJ=OupUu_4N3nQWYAfwCN6aT4s1PKQypHmpPLnX5Bz6qg@mail.gmail.com
Whole thread Raw
In response to Cannot pg_dump_all anymore...  (E-BLOKOS <infos@e-blokos.com>)
Responses Re: Cannot pg_dump_all anymore...
Re: Cannot pg_dump_all anymore...
List pgsql-general
First figure out which database is having that issue, by using pg_dump --schema-only on each database in turn. Then run this SQL on the database giving the error to see if the type exists, or what is nearby:

select oid, typname, typtype, typnamespace::regnamespace from pg_type where oid <= 794978 order by 1 desc limit 3;

Also let us know the version of pg_dump and the version of Postgres being dumped.


Cheers,
Greg

--
Enterprise Postgres Software Products & Tech Support

pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: Re: Cannot pg_dump_all anymore...
Next
From: Evgeniy Ratkov
Date:
Subject: Re: BUG #18575: Sometimes pg_rewind mistakenly assumes that nothing needs to be done.