Re: pg_dump not dumping some schemas

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;

On 5/29/15, 4:06 AM, "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)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.
>> I executed pg_dump as postgres user, the server and pg_dump are version
>>9.3.5. I suspect it¹s missing
>> some permissions, but not able to figure out what permissions are
>>missing. Below is the permission on
>> test schema:
>>
>> 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 |
>>
>
>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