"Guo, Yun" <YGuo@xxxxxxxxx> writes: > 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. Hm. I'm baffled. If you're handy with gdb you could try walking through the calls of selectDumpableNamespace() and dumpNamespace() to see if they get called at all for the problem schemas and what they do if so. regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin