pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Guo, Yun <YGuo@cvent.com>
To: Albe Laurenz <laurenz.albe@wien.gv.at>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: pg_dump not dumping some schemas
Date: Mon, 1 Jun 2015 13:21:52 +0000
Message-ID: <D191D463.3774F%yguo@cvent.com> (raw)
In-Reply-To: <A737B7A37273E048B164557ADEF4A58B36618A43@ntex2010i.host.magwien.gv.at>
References: <D18CC6E9.36A0E%yguo@cvent.com>
	<A737B7A37273E048B164557ADEF4A58B36617951@ntex2010i.host.magwien.gv.at>
	<D18DE04B.36C72%yguo@cvent.com>
	<A737B7A37273E048B164557ADEF4A58B36618A43@ntex2010i.host.magwien.gv.at>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>

It doesn¡¯t show up in custom format dump either¡¦ I begin to wonder if it¡¯s
a bug in pg_dump.


-bash-4.1$ pg_dump -s -n test -Fc polling_etl | pg_restore -l | grep SCHEMA
-bash-4.1$ pg_dump -s -n test2 -Fc polling_etl | pg_restore -l | grep
SCHEMA
7; 2615 1131042 SCHEMA - test2 pb_writer



On 6/1/15, 4:07 AM, "Albe Laurenz" <laurenz.albe@wien.gv.at> wrote:

>Yun Guo wrote:
>>>> I use this command to dump schema:
>>>> pg_dump -s -n test polling_etl  > file.sql
>>>>
>>>> However, the file.sql file includes creation of all the objects in
>>>> schema test, but not the creation of test schema itself.
>
>>>> polling_etl=# \dn+ test
>>>>                 List of schemas
>>>>  Name | Owner | Access privileges | Description
>>>> ------+-------+-------------------+-------------
>>>>  test | test  | test=UC/test     +|
>>>>       |       | pb_writer=UC/test+|
>>>>       |       | =U/test          +|
>>>>       |       | postgres=U*C/test |
>
>> I tried again. It©ös still not dumping CREATE SCHEMA. And weirdly it
>>would
>> work for some other schemas in the same database.
>> 
>> -bash-4.1$ pg_dump -s -n test polling_etl | grep 'CREATE SCHEMA'
>> -bash-4.1$ pg_dump -s -n test2 polling_etl | grep 'CREATE SCHEMA'
>> CREATE SCHEMA test2;
>
>That is disturbing.
>
>Does the schema show up in a custom format dump?
>
>pg_dump -s -n test -Fc polling_etl | pg_restore -l
>
>Yours,
>Laurenz Albe


-- 
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: <D191D463.3774F%yguo@cvent.com>
Permalink:  ../D191D463.3774F%25yguo@cvent.com/
Also on:    postgresql.org/message-id/D191D463.3774F%yguo@cvent.com

 · 

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, laurenz.albe@wien.gv.at
  Subject: Re: pg_dump not dumping some schemas
  In-Reply-To: <D191D463.3774F%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