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

From Guo, Yun
Subject Re: pg_dump not dumping some schemas
Date
Msg-id 2DB6C5478F692C4C983B3129CC1AEB14CA65E8E0@HQ08HQMX002.cvent.net
Whole thread Raw
In response to Re: pg_dump not dumping some schemas  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Thanks Tom.
I've never dealt with gdb before. But it's a great opportunity to start learning. Will keep you updated with my
findings.


-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Monday, June 01, 2015 10:12 AM
To: Guo, Yun
Cc: Albe Laurenz; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] pg_dump not dumping some schemas

"Guo, Yun" <YGuo@cvent.com> 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


pgsql-admin by date:

Previous
From: "Guo, Yun"
Date:
Subject: Re: pg_dump not dumping some schemas
Next
From: Tom Lane
Date:
Subject: Re: pg_dump not dumping some schemas