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: <D191D463.3774F%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>
Comments: In-reply-to "Guo, Yun" <YGuo@cvent.com>
 message dated "Mon, 01 Jun 2015 13:21:52 -0000"
Date: Mon, 01 Jun 2015 09:53:01 -0400
Message-ID: <16441.1433166781@sss.pgh.pa.us>
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

"Guo, Yun" <YGuo@cvent.com> writes:
> It doesn’t show up in custom format dump eitherˇ I begin to wonder if it’s
> a bug in pg_dump.

pg_dump's handling of schemas is pretty darn simple; it's hard to see how
it could "miss" a schema like that.  It would be useful to see the output
of these commands executed in the problematic database:

SELECT oid FROM pg_catalog.pg_namespace n
	WHERE n.nspname ~ '^(test)$';
SELECT tableoid, oid, nspname, (SELECT rolname FROM pg_catalog.pg_roles
	WHERE oid = nspowner) AS rolname, nspacl FROM pg_catalog.pg_namespace;

which are pretty much everything pg_dump issues that's directly related
to dumping schemas.

			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