Re: pg_dump not dumping some schemas

Here¹s the output:

polling_etl=# SELECT oid FROM pg_catalog.pg_namespace n
polling_etl-# WHERE n.nspname ~ '^(test)$';
oid
-------
17972
(1 row)
polling_etl=# SELECT tableoid, oid, nspname, (SELECT rolname FROM
pg_catalog.pg_roles
WHERE oid = nspowner) AS rolname, nspacl FROM pg_catalog.pg_namespace;
tableoid | oid | nspname | rolname |
nspacl
----------+---------+--------------------+-----------+---------------------
-----------------------------------------------------------
2615 | 99 | pg_toast | postgres |
2615 | 11215 | pg_temp_1 | postgres |
2615 | 11216 | pg_toast_temp_1 | postgres |
2615 | 11 | pg_catalog | postgres |
{postgres=UC/postgres,=U/postgres}
2615 | 2200 | public | postgres |
{postgres=UC/postgres,=UC/postgres}
2615 | 12348 | information_schema | postgres |
{postgres=UC/postgres,=U/postgres}
2615 | 1131042 | test2 | pb_writer |
{pb_writer=UC/pb_writer,test2=U/pb_writer}
2615 | 16389 | polling_etl | pb_writer |
{pb_writer=UC/pb_writer,polling_etl=UC/pb_writer}
2615 | 17944 | mdev1 | pb_writer |
{pb_writer=UC/pb_writer,=U/pb_writer,postgres=U*C/pb_writer,mdev1=U/pb_writ
er}
2615 | 17946 | mdev2 | pb_writer |
{pb_writer=UC/pb_writer,=U/pb_writer,postgres=U*C/pb_writer,mdev2=U/pb_writ
er}
2615 | 17957 | mdev3 | pb_writer |
{pb_writer=UC/pb_writer,=U/pb_writer,postgres=U*C/pb_writer,mdev3=U/pb_writ
er}
2615 | 17970 | mdev4 | pb_writer |
{pb_writer=UC/pb_writer,=U/pb_writer,postgres=U*C/pb_writer,mdev4=U/pb_writ
er}
2615 | 17972 | test | pb_writer |
{pb_writer=UC/pb_writer,=U/pb_writer,postgres=U*C/pb_writer,test=U/pb_write
r}
(13 rows)

pg_dump is missing 5 schemas: mdev1, mdev2, mdev3, mdev4, and test. It
doesn¹t look like much different between those 5 schemas and the other 2.

On 6/1/15, 9:53 AM, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

>
>SELECT oid FROM pg_catalog.pg_namespace n
> WHERE n.nspname ~ '^(test)$';