pg.ddx.io pgsql-admin@postgresql.org mailing list archive help / color / mirror / Atom feed From: Guo, Yun <YGuo@cvent.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
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, 1 Jun 2015 14:04:57 +0000
Message-ID: <D191DD67.3776F%yguo@cvent.com> (raw )
In-Reply-To: <16441.1433166781@sss.pgh.pa.us >
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 >
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Here¹s the output:
polling_etl=# SELECT oid FROM pg_catalog.pg_namespace n
polling_etl-# WHERE n.nspname ~ '^(test)$';
oid
-------
17972
(1 row)
polling_etl=# SELECT tableoid, oid, nspname, (SELECT rolname FROM
pg_catalog.pg_roles
WHERE oid = nspowner) AS rolname, nspacl FROM pg_catalog.pg_namespace;
tableoid | oid | nspname | rolname |
nspacl
----------+---------+--------------------+-----------+---------------------
-----------------------------------------------------------
2615 | 99 | pg_toast | postgres |
2615 | 11215 | pg_temp_1 | postgres |
2615 | 11216 | pg_toast_temp_1 | postgres |
2615 | 11 | pg_catalog | postgres |
{postgres=UC/postgres,=U/postgres}
2615 | 2200 | public | postgres |
{postgres=UC/postgres,=UC/postgres}
2615 | 12348 | information_schema | postgres |
{postgres=UC/postgres,=U/postgres}
2615 | 1131042 | test2 | pb_writer |
{pb_writer=UC/pb_writer,test2=U/pb_writer}
2615 | 16389 | polling_etl | pb_writer |
{pb_writer=UC/pb_writer,polling_etl=UC/pb_writer}
2615 | 17944 | mdev1 | pb_writer |
{pb_writer=UC/pb_writer,=U/pb_writer,postgres=U*C/pb_writer,mdev1=U/pb_writ
er}
2615 | 17946 | mdev2 | pb_writer |
{pb_writer=UC/pb_writer,=U/pb_writer,postgres=U*C/pb_writer,mdev2=U/pb_writ
er}
2615 | 17957 | mdev3 | pb_writer |
{pb_writer=UC/pb_writer,=U/pb_writer,postgres=U*C/pb_writer,mdev3=U/pb_writ
er}
2615 | 17970 | mdev4 | pb_writer |
{pb_writer=UC/pb_writer,=U/pb_writer,postgres=U*C/pb_writer,mdev4=U/pb_writ
er}
2615 | 17972 | test | pb_writer |
{pb_writer=UC/pb_writer,=U/pb_writer,postgres=U*C/pb_writer,test=U/pb_write
r}
(13 rows)
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.
On 6/1/15, 9:53 AM, "Tom Lane" <tgl@sss.pgh.pa.us> wrote:
>
>SELECT oid FROM pg_catalog.pg_namespace n
> WHERE n.nspname ~ '^(test)$';
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
view thread (19+ messages) latest in thread
Message-ID: <D191DD67.3776F%yguo@cvent.com>
Permalink: ../D191DD67.3776F%25yguo@cvent.com/
Also on: postgresql.org/message-id/D191DD67.3776F%yguo@cvent.com
copy link · copy postgr.es
reply 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: YGuo@cvent.com, tgl@sss.pgh.pa.us, laurenz.albe@wien.gv.at
Subject: Re: pg_dump not dumping some schemas
In-Reply-To: <D191DD67.3776F%yguo@cvent.com>
* 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