From: "Guo, Yun" <YGuo@cvent.com>
To: Albe Laurenz <laurenz.albe@wien.gv.at>, "pgsql-admin@postgresql.org"
 <pgsql-admin@postgresql.org>
Subject: Re: pg_dump not dumping some schemas
Thread-Topic: pg_dump not dumping some schemas
Thread-Index: AQHQmWrG8qD1Kd5wwECxQFQUQc4hUJ2SmSMwgABZZgA=
Date: Fri, 29 May 2015 13:23:42 +0000
Message-ID: <D18DE04B.36C72%yguo@cvent.com>
References: <D18CC6E9.36A0E%yguo@cvent.com>
 <A737B7A37273E048B164557ADEF4A58B36617951@ntex2010i.host.magwien.gv.at>
In-Reply-To: 
 <A737B7A37273E048B164557ADEF4A58B36617951@ntex2010i.host.magwien.gv.at>
Accept-Language: en-US
Content-Language: en-US
user-agent: Microsoft-MacOutlook/14.5.0.150423
Content-Type: text/plain; charset="iso-8859-1"
Content-ID: <E2C05249E24CD64E8EA390F64DCEAFBC@cvent.com>
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

I tried again. It=B9s 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;


On 5/29/15, 4:06 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
>>=20
>> However, the file.sql file includes creation of all the objects in
>>schema test, but not the creation
>> of test schema itself.
>> I executed pg_dump as postgres user, the server and pg_dump are version
>>9.3.5. I suspect it=B9s missing
>> some permissions, but not able to figure out what permissions are
>>missing. Below is the permission on
>> test schema:
>>=20
>> polling_etl=3D# \dn+ test
>>                 List of schemas
>>  Name | Owner | Access privileges | Description
>> ------+-------+-------------------+-------------
>>  test | test  | test=3DUC/test     +|
>>       |       | pb_writer=3DUC/test+|
>>       |       | =3DU/test          +|
>>       |       | postgres=3DU*C/test |
>>=20
>
>It works on my 9.3.6 database:
>
>$ pg_dump -p 1235 -s -n laurenz test|grep 'CREATE SCHEMA'
>CREATE SCHEMA laurenz;
>
>You don't need any permissions to dump a schema, everybody can read the
>information.
>
>Could you double check with a "grep" or so that there is indeed no CREATE
>SCHEMA
>in your dump?
>
>Yours,
>Laurenz Albe


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