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

help / color / mirror / Atom feed

From: Guo, Yun <YGuo@cvent.com>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: pg_dump not dumping some schemas
Date: Thu, 28 May 2015 17:21:46 +0000
Message-ID: <D18CC6E9.36A0E%yguo@cvent.com> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>

Hi,

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 |


Thanks

Yun

view thread (19+ messages)  latest in thread

Message-ID: <D18CC6E9.36A0E%yguo@cvent.com>
Permalink:  ../D18CC6E9.36A0E%25yguo@cvent.com/
Also on:    postgresql.org/message-id/D18CC6E9.36A0E%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
  Subject: Re: pg_dump not dumping some schemas
  In-Reply-To: <D18CC6E9.36A0E%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