From: Tom Lane <tgl@sss.pgh.pa.us>
To: Guo, Yun <YGuo@cvent.com>
Cc: Albe Laurenz <laurenz.albe@wien.gv.at>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: pg_dump not dumping some schemas
Date: Mon, 01 Jun 2015 09:53:01 -0400
Message-ID: <16441.1433166781@sss.pgh.pa.us> (raw)
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>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
"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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, YGuo@cvent.com, laurenz.albe@wien.gv.at
Subject: Re: pg_dump not dumping some schemas
In-Reply-To: <16441.1433166781@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox