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.albe@xxxxxxxxxx> 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
