Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Yznix-0004NH-FV for pgsql-admin@arkaria.postgresql.org; Tue, 02 Jun 2015 15:03:27 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Yzniw-0002Sj-V0 for pgsql-admin@arkaria.postgresql.org; Tue, 02 Jun 2015 15:03:27 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1Yzniv-0002QL-EA for pgsql-admin@postgresql.org; Tue, 02 Jun 2015 15:03:25 +0000 Received: from smtp1.cvent.com ([198.207.146.196]) by makus.postgresql.org with esmtps (TLS1.0:DHE_RSA_CAMELLIA_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1Yznin-0005Sr-Sc for pgsql-admin@postgresql.org; Tue, 02 Jun 2015 15:03:24 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cvent.com; i=@cvent.com; q=dns/txt; s=c1211; t=1433257397; x=1464793397; h=from:to:cc:subject:date:message-id:references: in-reply-to:content-id:content-transfer-encoding: mime-version; bh=EuI0vGBz4VRMHs+4xkvJE9UtXv+sTzwdTDtxiiho42o=; b=fUY0EwZH75ZoZiGDmKgtGqyQyXIsmVZnUHA5ZANAzem6w1VVUdTRZfxg Z9CMFP7mtn/FFloQNOVQF+VRWbGty6X4GiEPt56eRqB5gjm9JixHe9P6u /uUHzE0qxxeXzGzpZCB1yrc7mBJMxhEPJ156aE8gjX//znlOHHWmMj/pc M=; X-IronPort-AV: E=Sophos;i="5.13,540,1427774400"; d="scan'208";a="46124595" From: "Guo, Yun" To: Albe Laurenz , Tom Lane CC: "pgsql-admin@postgresql.org" Subject: Re: pg_dump not dumping some schemas Thread-Topic: [ADMIN] pg_dump not dumping some schemas Thread-Index: AQHQmWrG8qD1Kd5wwECxQFQUQc4hUJ2SmSMwgABZZgCABFkg4IAAXWMAgAAHsYCAAAXooIAARaiAgACLsgCAAEkQAIAAb84AgAAEuwCAABIQgA== Date: Tue, 2 Jun 2015 15:03:15 +0000 Message-ID: References: <2DB6C5478F692C4C983B3129CC1AEB14CA65E8C8@HQ08HQMX002.cvent.net> <17196.1433168399@sss.pgh.pa.us> <11998.1433214088@sss.pgh.pa.us> In-Reply-To: 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: text/plain; charset="utf-8" Content-ID: <8D730FC93283CC4E81C14A3B1FF0BCF3@cvent.com> Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-Pg-Spam-Score: -2.0 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org DQoNCkJ1dCB0aGUgZHVtcGVkIGZpbGUgY2Fubm90IGJlIHJlc3RvcmVkLiBJ biB0aGUgZHVtcCBmaWxlIGl0IGRvZXNu4oCZdCBzZWVtDQp0byBjcmVhdGUg c2NoZW1hcyB3aXRoIHRoZSBleHRlbnNpb246DQoNCi1iYXNoLTQuMSQgcGdf ZHVtcCAtcyBwb2xsaW5nX2V0bCB8IGdyZXAgRVhURU5TSU9ODQotLSBOYW1l OiBoc3RvcmU7IFR5cGU6IEVYVEVOU0lPTjsgU2NoZW1hOiAtOyBPd25lcjoN CkNSRUFURSBFWFRFTlNJT04gSUYgTk9UIEVYSVNUUyBoc3RvcmUgV0lUSCBT Q0hFTUEgcG9sbGluZ19ldGw7DQotLSBOYW1lOiBFWFRFTlNJT04gaHN0b3Jl OyBUeXBlOiBDT01NRU5UOyBTY2hlbWE6IC07IE93bmVyOg0KQ09NTUVOVCBP TiBFWFRFTlNJT04gaHN0b3JlIElTICdkYXRhIHR5cGUgZm9yIHN0b3Jpbmcg c2V0cyBvZiAoa2V5LCB2YWx1ZSkNCnBhaXJzJzsNCi0tIE5hbWU6IHBscGdz cWw7IFR5cGU6IEVYVEVOU0lPTjsgU2NoZW1hOiAtOyBPd25lcjoNCg0KDQoN ClNvIHRoYXQgd2hlbiBpdCB0cmllcyB0byByZXN0b3JlIGFueSBvYmplY3Rz IGluIHRoZSBzY2hlbWEgaXQgd291bGQgZXJyb3INCm91dCBiZWNhdXNlIHRo ZSBzY2hlbWEgaXNu4oCZdCBjcmVhdGVkLg0KDQotYmFzaC00LjEkIHBnX3Jl c3RvcmUgLWUgLWhocS1wZ3BzYmstMDAxIC1VZGJhIC1kcG9zdGdyZXMgL3Rt cC9wb2xsaW5nLmR1bXANClBhc3N3b3JkOg0KcGdfcmVzdG9yZTogW2FyY2hp dmVyIChkYildIEVycm9yIHdoaWxlIFBST0NFU1NJTkcgVE9DOg0KcGdfcmVz dG9yZTogW2FyY2hpdmVyIChkYildIEVycm9yIGZyb20gVE9DIGVudHJ5IDE3 ODsgMTI1OSAxODYwMCBUQUJMRQ0KdGVzdCBtZGV2MQ0KcGdfcmVzdG9yZTog W2FyY2hpdmVyIChkYildIGNvdWxkIG5vdCBleGVjdXRlIHF1ZXJ5OiBFUlJP UjogIHBlcm1pc3Npb24NCmRlbmllZCB0byBjcmVhdGUgInBnX2NhdGFsb2cu dGVzdCINCkRFVEFJTDogIFN5c3RlbSBjYXRhbG9nIG1vZGlmaWNhdGlvbnMg YXJlIGN1cnJlbnRseSBkaXNhbGxvd2VkLg0KICAgIENvbW1hbmQgd2FzOiBD UkVBVEUgVEFCTEUgdGVzdCAoDQogICAgaSBpbnRlZ2VyDQopOw0KDQpJIGhh dmUgbm8gaWRlYSBob3cgaHN0b3JlIGJlY29tZXMgb3duZXIgb2YgdGhvc2Ug c2NoZW1hcy4gTWF5YmUgb3RoZXIgdGVhbQ0KbWVtYmVycyBkaWQgdGhhdCBi dXQgSSBjYW7igJl0IHRoaW5rIG9mIHJlYXNvbiB3aHkgd291bGQgdGhhdCBi ZSBuZWNlc3NhcnkuDQpJIHRyaWVkICJBTFRFUiBFWFRFTlNJT04gaHN0b3Jl IERST1AgU0NIRU1B4oCdIGFzIExhdXJlbnogc3VnZ2VzdGVkIHdoaWNoDQpk b2VzIGZpeCB0aGUgcHJvYmxlbSBvZiBkdW1waW5nIHNjaGVtYS4NCg0KVGhh bmsgeW91IHNvIG11Y2ggZm9yIHlvdXIgaGVscCBndXlzIQ0KDQpZdW4NCg0K T24gNi8yLzE1LCAxMDowMiBBTSwgIkFsYmUgTGF1cmVueiIgPGxhdXJlbnou YWxiZUB3aWVuLmd2LmF0PiB3cm90ZToNCg0KPll1biBHdW8gd3JvdGU6DQo+ PiBJbnRlcmVzdGluZ8WgIEkgY2hlY2tlZCB0aGUgcGdfZGVwZW5kIGZvciB0 aGF0IHNjaGVtYSwgbG9va3MgbGlrZSBpdMK5cw0KPj4gZGVwZW5kaW5nIG9u IGFuIGV4dGVuc2lvbi4NCj4+IA0KPj4gcG9sbGluZ19ldGw9IyBTRUxFQ1Qg Y2xhc3NpZCwgb2JqaWQsIHJlZmNsYXNzaWQsIHJlZm9iamlkDQo+PiBGUk9N IHBnX2RlcGVuZA0KPj4gV0hFUkUgcmVmY2xhc3NpZCA9ICdwZ19leHRlbnNp b24nOjpyZWdjbGFzcw0KPj4gQU5EIGRlcHR5cGUgPSAnZScgIGFuZCBvYmpp ZCA9IDE3OTcyDQo+PiBPUkRFUiBCWSAzLDQ7DQo+PiAgY2xhc3NpZCB8IG9i amlkIHwgcmVmY2xhc3NpZCB8IHJlZm9iamlkDQo+PiAtLS0tLS0tLS0rLS0t LS0tLSstLS0tLS0tLS0tLS0rLS0tLS0tLS0tLQ0KPj4gICAgIDI2MTUgfCAx Nzk3MiB8ICAgICAgIDMwNzkgfCAgICAxNjczMA0KPj4gCQkgICAgICBeXl5e Xl4NCj4+IA0KPj4gDQo+PiBwb2xsaW5nX2V0bD0jIHNlbGVjdCAqIGZyb20g cGdfZXh0ZW5zaW9uIHdoZXJlIG9pZCA9IDE2NzMwOw0KPj4gIGV4dG5hbWUg fCBleHRvd25lciB8IGV4dG5hbWVzcGFjZSB8IGV4dHJlbG9jYXRhYmxlIHwg ZXh0dmVyc2lvbiB8DQo+PiBleHRjb25maWcgfCBleHRjb25kaXRpb24NCj4+ IA0KPj4tLS0tLS0tLS0rLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLSstLS0t LS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLSstLS0tLS0tDQo+Pi0tDQo+PiAt LSstLS0tLS0tLS0tLS0tLQ0KPj4gIGhzdG9yZSAgfCAgICAgICAxMCB8ICAg ICAgICAxNjM4OSB8IHQgICAgICAgICAgICAgIHwgMS4yICAgICAgICB8DQo+ PiAgIHwNCj4+IA0KPj4gDQo+PiBIb3cgY2FuIEkgcmVtb3ZlIHRoaXMgZGVw ZW5kZW5jeT8gT3Igd2hhdCBzaG91bGQgSSBkbyB0byBtYWtlIGl0IGR1bXAN Cj4+dGhlDQo+PiBzY2hlbWEgY3JlYXRpb24gY29ycmVjdGx5Pw0KPg0KPkl0 ICppcyogYmVpbmcgZHVtcGVkIGNvcnJlY3RseS4NCj4NCj5UaGUgc2NoZW1h IGJlbG9uZ3MgdG8gYW4gZXh0ZW5zaW9uLCBzbyBpdCBpcyBjcmVhdGVkIGJ5 IHRoZSBDUkVBVEUNCj5FWFRFTlNJT04NCj5jb21tYW5kLiAgSWYgdGhlIHNj aGVtYSBpdHNlbGYgd2VyZSBhbHNvIGR1bXBlZCwgdGhhdCB3b3VsZCBjcmVh dGUNCj5wcm9ibGVtcw0KPmR1cmluZyByZXN0b3JlOiBUaGUgc2NoZW1hIHdv dWxkIGJlIGNyZWF0ZSBib3RoIGJ5IENSRUFURSBFWFRFTlNJT04gYW5kDQo+ Q1JFQVRFIFNDSEVNQSwgd2hpY2ggd291bGQgcmVzdWx0IGluIGFuIGVycm9y Lg0KPg0KPklmIHlvdSBhcmUgc3VyZSB0aGF0IGl0IGlzIHRoZSByaWdodCB0 aGluZyB0byBkbywgeW91IGNhbiByZW1vdmUgdGhlDQo+ZGVwZW5kZW5jeSBv biB0aGUgZXh0ZW5zaW9uIHdpdGgNCj4gICBBTFRFUiBFWFRFTlNJT04gaHN0 b3JlIERST1AgU0NIRU1BIHRlc3Q7DQo+DQo+WW91cnMsDQo+TGF1cmVueiBB bGJlDQoNCgotLSAKU2VudCB2aWEgcGdzcWwtYWRtaW4gbWFpbGluZyBsaXN0 IChwZ3NxbC1hZG1pbkBwb3N0Z3Jlc3FsLm9yZykKVG8gbWFrZSBjaGFuZ2Vz IHRvIHlvdXIgc3Vic2NyaXB0aW9uOgpodHRwOi8vd3d3LnBvc3RncmVzcWwu b3JnL21haWxwcmVmL3Bnc3FsLWFkbWluCg==