Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M44059=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1Yy1VI-0007h4-N3
 for pgsql-admin@arkaria.postgresql.org; Thu, 28 May 2015 17:22:01 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M44059=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1Yy1VI-0001qT-6R
 for pgsql-admin@arkaria.postgresql.org; Thu, 28 May 2015 17:22:00 +0000
Received: from makus.postgresql.org ([174.143.35.229])
 by malur.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA256:256)
 (Exim 4.80) (envelope-from <YGuo@cvent.com>) id 1Yy1VE-0001jx-AF
 for pgsql-admin@postgresql.org; Thu, 28 May 2015 17:21:56 +0000
Received: from smtp2.cvent.com ([65.97.54.246])
 by makus.postgresql.org with esmtps
 (TLS1.0:DHE_RSA_CAMELLIA_256_CBC_SHA1:256)
 (Exim 4.84) (envelope-from <YGuo@cvent.com>) id 1Yy1V6-0007gx-NK
 for pgsql-admin@postgresql.org; Thu, 28 May 2015 17:21:54 +0000
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
 d=cvent.com; i=@cvent.com; q=dns/txt; s=c1211;
 t=1432833708; x=1464369708;
 h=from:to:subject:date:message-id:mime-version:
 content-transfer-encoding;
 bh=LUhYbPyVCfBOP/9W/2VEDpuEGvW+c5C2RS48PaydnE8=;
 b=LUG4SzczsGVb0yan1DWcr5l5kvfT0ZH2rJZlevHL+AYa8w+R7L2jamaU
 3RUaKTGwa14CnLCrs7A/52R4Vf4JOyopdFNMka5+IZDBGaX+EH97/F5Ww
 Q7EzW7PyXy8GzQ8TpxLjEx5qTZVeNAFCwTK4as+EkLR5X2Pu90k/agCbN I=;
X-IronPort-AV: E=Sophos;i="5.13,513,1427774400"; d="scan'208,217";a="5480069"
From: "Guo, Yun" <YGuo@cvent.com>
To: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: pg_dump not dumping some schemas
Thread-Topic: pg_dump not dumping some schemas
Thread-Index: AQHQmWrG8qD1Kd5wwECxQFQUQc4hUA==
Date: Thu, 28 May 2015 17:21:46 +0000
Message-ID: <D18CC6E9.36A0E%yguo@cvent.com>
Accept-Language: en-US
Content-Language: en-US
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
user-agent: Microsoft-MacOutlook/14.5.0.150423
Content-Type: multipart/alternative;
 boundary="_000_D18CC6E936A0Eyguocventcom_"
MIME-Version: 1.0
X-Pg-Spam-Score: -0.1 (/)
List-Archive: <http://archives.postgresql.org/pgsql-admin>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-admin.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@postgresql.org>
List-Post: <mailto:pgsql-admin@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-admin>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
X-Mailing-List: pgsql-admin
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

--_000_D18CC6E936A0Eyguocventcom_
Content-Type: text/plain; charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

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 t=
est, 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=92s missing some permissions, but not able to figure out w=
hat permissions are missing. Below is the permission on test schema:

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 |


Thanks

Yun

--_000_D18CC6E936A0Eyguocventcom_
Content-Type: text/html; charset="Windows-1252"
Content-ID: <257C46F88901B64389DD51E4305E45CC@cvent.com>
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3DWindows-1=
252">
</head>
<body style=3D"word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-lin=
e-break: after-white-space; color: rgb(0, 0, 0); font-size: 14px; font-fami=
ly: Calibri, sans-serif;">
<div>Hi,</div>
<div><br>
</div>
<div>I use this command to dump schema:</div>
<div>pg_dump -s -n test polling_etl &nbsp;&gt; file.sql</div>
<div><br>
</div>
<div>However, the file.sql file includes creation of all the objects in sch=
ema test, but not the creation of test schema itself.</div>
<div>I executed pg_dump as postgres user, the server and pg_dump are versio=
n 9.3.5. I suspect it=92s missing some permissions, but not able to figure =
out what permissions are missing. Below is the permission on test schema:</=
div>
<div><br>
</div>
<div>
<div>polling_etl=3D# \dn&#43; test</div>
<div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; List of schema=
s</div>
<div>&nbsp;Name | Owner | Access privileges | Description</div>
<div>------&#43;-------&#43;-------------------&#43;-------------</div>
<div>&nbsp;test | test &nbsp;| test=3DUC/test &nbsp; &nbsp; &#43;|</div>
<div>&nbsp; &nbsp; &nbsp; | &nbsp; &nbsp; &nbsp; | pb_writer=3DUC/test&#43;=
|</div>
<div>&nbsp; &nbsp; &nbsp; | &nbsp; &nbsp; &nbsp; | =3DU/test &nbsp; &nbsp; =
&nbsp; &nbsp; &nbsp;&#43;|</div>
<div>&nbsp; &nbsp; &nbsp; | &nbsp; &nbsp; &nbsp; | postgres=3DU*C/test |</d=
iv>
</div>
<div><br>
</div>
<div><br>
</div>
<div>Thanks</div>
<div><br>
</div>
<div>Yun</div>
</body>
</html>

--_000_D18CC6E936A0Eyguocventcom_--