Re: pg_dump not dumping some schemas - Mailing list pgsql-admin

Yun Guo wrote:
> It doesn’t show up in custom format dump either… I begin to wonder if it’s
> a bug in pg_dump.
> 
> 
> -bash-4.1$ pg_dump -s -n test -Fc polling_etl | pg_restore -l | grep SCHEMA
> -bash-4.1$ pg_dump -s -n test2 -Fc polling_etl | pg_restore -l | grep
> SCHEMA
> 7; 2615 1131042 SCHEMA - test2 pb_writer

... or your database is corrupt.

Maybe it helps to issue the queries that pg_dump uses:

SELECT tableoid, oid, nspname, (SELECT rolname FROM pg_catalog.pg_roles WHERE oid = nspowner) AS rolname, nspacl FROM
pg_namespace;

SELECT oid FROM pg_catalog.pg_namespace n WHERE (n.nspname = 'test');

Yours,
Laurenz Albe