Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M44077=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1YzQRa-0006q5-7H
 for pgsql-admin@arkaria.postgresql.org; Mon, 01 Jun 2015 14:11:58 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M44077=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1YzQRY-0005s6-B9
 for pgsql-admin@arkaria.postgresql.org; Mon, 01 Jun 2015 14:11:56 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
 by malur.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA256:256)
 (Exim 4.80) (envelope-from <tgl@sss.pgh.pa.us>) id 1YzQRR-0005hU-48
 for pgsql-admin@postgresql.org; Mon, 01 Jun 2015 14:11:49 +0000
Received: from sss.pgh.pa.us ([66.207.139.130])
 by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
 (Exim 4.84) (envelope-from <tgl@sss.pgh.pa.us>) id 1YzQRN-00028w-Fl
 for pgsql-admin@postgresql.org; Mon, 01 Jun 2015 14:11:47 +0000
Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1])
 by sss.pgh.pa.us (8.14.4/8.14.4) with ESMTP id t51EBh2K016967;
 Mon, 1 Jun 2015 10:11:43 -0400
From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Guo, Yun" <YGuo@cvent.com>
cc: Albe Laurenz <laurenz.albe@wien.gv.at>,
 "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: Re: pg_dump not dumping some schemas
In-reply-to: <D191DD67.3776F%yguo@cvent.com>
References: <D18CC6E9.36A0E%yguo@cvent.com>
 <A737B7A37273E048B164557ADEF4A58B36617951@ntex2010i.host.magwien.gv.at>
 <D18DE04B.36C72%yguo@cvent.com>
 <A737B7A37273E048B164557ADEF4A58B36618A43@ntex2010i.host.magwien.gv.at>
 <D191D463.3774F%yguo@cvent.com> <16441.1433166781@sss.pgh.pa.us>
 <D191DD67.3776F%yguo@cvent.com>
Comments: In-reply-to "Guo, Yun" <YGuo@cvent.com>
 message dated "Mon, 01 Jun 2015 14:04:57 -0000"
Date: Mon, 01 Jun 2015 10:11:43 -0400
Message-ID: <16966.1433167903@sss.pgh.pa.us>
X-Pg-Spam-Score: -1.5 (-)
List-Archive: <http://archives.postgresql.org/pgsql-admin>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-admin.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@postgresql.org>
List-Post: <mailto:pgsql-admin@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-admin>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
X-Mailing-List: pgsql-admin
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

"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


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin