Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1ZjBgy-0004NO-6H for pgsql-admin@arkaria.postgresql.org; Mon, 05 Oct 2015 19:45:00 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1ZjBgx-0005ix-AD for pgsql-admin@arkaria.postgresql.org; Mon, 05 Oct 2015 19:44:59 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1ZjBgw-0005i6-KV for pgsql-admin@postgresql.org; Mon, 05 Oct 2015 19:44:58 +0000 Received: from smtp2.cvent.com ([192.190.92.246]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1ZjBgr-00011r-NM for pgsql-admin@postgresql.org; Mon, 05 Oct 2015 19:44:57 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cvent.com; i=@cvent.com; q=dns/txt; s=c1211; t=1444074293; x=1475610293; h=from:to:cc:subject:date:message-id:references: in-reply-to:content-id:content-transfer-encoding: mime-version; bh=28s9u9i1k+CQbyqdZMId7fS0QI0ETk53jKGyIGwkC9k=; b=bEn0ORPcu1vKRApEa26AlLBwkTV/OOFgUZyoLL6d9UGVxEe1ZrkYUNYR kMyOnWA6NzWFv8yldhTAeFHf9/xCEVGCzCRPB/iJlTV2uIdnzrVvCbxB3 u2QCXw0eSx7NBcPjCfVx5+C6UdZAXaibxPa3emFdphKdpz9gKzvm2IfHW w=; X-IronPort-AV: E=Sophos;i="5.17,640,1437451200"; d="scan'208";a="7937780" From: "Guo, Yun" To: Bruce Momjian CC: "pgsql-admin@postgresql.org" Subject: Re: pg_upgrade from 9.3 to 9.4 fails Thread-Topic: [ADMIN] pg_upgrade from 9.3 to 9.4 fails Thread-Index: AQHQ/4mcAUs7p8odSEODO5MGegI4x55dIRKAgABIPQD//8cJgIAAQ7QA//+9XICAAEZnAP//vwoAAAm6/AD//8jSgA== Date: Mon, 5 Oct 2015 19:44:51 +0000 Message-ID: References: <20151005172418.GA6784@momjian.us> <20151005180244.GB6784@momjian.us> <20151005181612.GC6784@momjian.us> <20151005190218.GD6784@momjian.us> In-Reply-To: <20151005190218.GD6784@momjian.us> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: user-agent: Microsoft-MacOutlook/14.5.3.150624 Content-Type: text/plain; charset="euc-kr" Content-ID: <9DAF98D9446BED4B9C6E264E6D497012@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 DQoNCk9uIDEwLzUvMTUsIDM6MDIgUE0sICJCcnVjZSBNb21qaWFuIiA8YnJ1 Y2VAbW9tamlhbi51cz4gd3JvdGU6DQoNCj5PbiBNb24sIE9jdCAgNSwgMjAx NSBhdCAwNjoyMzo0M1BNICswMDAwLCBHdW8sIFl1biB3cm90ZToNCj4+ID5D UkVBVEUgVEVNUE9SQVJZIFRBQkxFIGluZm9fcmVscyAocmVsb2lkKSBBUyBT RUxFQ1QgYy5vaWQgRlJPTQ0KPj4gPnBnX2NhdGFsb2cucGdfY2xhc3MgYyBK T0lOIHBnX2NhdGFsb2cucGdfbmFtZXNwYWNlIG4gICBPTg0KPj5jLnJlbG5h bWVzcGFjZSA9DQo+PiA+bi5vaWQgTEVGVCBPVVRFUiBKT0lOIHBnX2NhdGFs b2cucGdfaW5kZXggaSAgIE9OIGMub2lkID0gaS5pbmRleHJlbGlkDQo+PiA+ V0hFUkUNCj4+ID5yZWxraW5kIElOICgncicsICdtJywgJ2knLCAnUycpIEFO RCAgaS5pbmRpc3ZhbGlkIElTIERJU1RJTkNUIEZST00NCj4+ZmFsc2UNCj4+ ID5BTkQNCj4+ID4gaS5pbmRpc3JlYWR5IElTIERJU1RJTkNUIEZST00gZmFs c2UgQU5EICAgKChuLm5zcG5hbWUgIX4gJ15wZ190ZW1wXycNCj4+QU5EDQo+ PiA+bi5uc3BuYW1lICF+ICdecGdfdG9hc3RfdGVtcF8nIEFORCAgICAgbi5u c3BuYW1lIE5PVCBJTiAoJ3BnX2NhdGFsb2cnLA0KPj4gPidpbmZvcm1hdGlv bl9zY2hlbWEnLCAnYmluYXJ5X3VwZ3JhZGUnLCAncGdfdG9hc3QnKSBBTkQg Yy5vaWQgPj0gMTYzODQpDQo+PiA+T1INCj4+ID4obi5uc3BuYW1lID0gJ3Bn X2NhdGFsb2cnIEFORCAgICAgcmVsbmFtZSBJTiAoJ3BnX2xhcmdlb2JqZWN0 JywNCj4+ID4ncGdfbGFyZ2VvYmplY3RfbG9pZF9wbl9pbmRleCcsICdwZ19s YXJnZW9iamVjdF9tZXRhZGF0YScsDQo+PiA+J3BnX2xhcmdlb2JqZWN0X21l dGFkYXRhX29pZF9pbmRleCcpICkpOw0KPj4gDQo+PiBTb3JyeSBJIG1pc3Vu ZGVyc3Rvb2QgeW91IGluc3RydWN0aW9uLiBJIHRyaWVkIHRoaXMgcXVlcnkg aW4gYWxsDQo+PmRhdGFiYXNlcw0KPj4gYW5kIGl0IGV4ZWN1dGVzIHdpdGhv dXQgYW55IGVycm9yLg0KPj4gSSBndWVzcyB0aGF0qfZzIHRoZSByZWFzb24g d2hlbiBJIGhhdmUgdGhlIG9sZCBzZXJ2ZXIgcnVubmluZyB0aGUgY2hlY2sN Cj4+IGNvdWxkIHBhc3MuIA0KPj4gSG93ZXZlciwgc29tZWhvdyB3aGVuIHRo ZSBvbGQgc2VydmVyIGlzIGh1dCBkb3duIGl0IHdvdWxkIGZhaWwuDQo+DQo+ V293LCB0aGF0IGlzIHJlYWxseSBvZGQuICBDYW4geW91IHBvc3QgdGhlIGNv bnRlbnRzIG9mDQo+InBnX3VwZ3JhZGVfc2VydmVyLmxvZyIgYWZ0ZXIgdGhl IGZhaWx1cmU/ICBUaGlzIGZpbGUgaXMgbWVudGlvbmVkIGluDQo+dGhlIGVy cm9yIG1lc3NhZ2UuICBZb3UgY2FuIGVtYWlsIGl0IHRvIG1lIHByaXZhdGVs eSBpZiBpdCBpcyBsYXJnZS4NCj4NCj5NeSBvbmx5IGd1ZXNzIGlzIHRoYXQg d2hlbiB0aGUgc2VydmVyIGlzIHJ1bm5pbmcsIHlvdSBoYXZlIHN0YXJ0ZWQg aXQNCj53aXRoIHNvbWUgc3BlY2lhbCBvcHRpb25zIHRoYXQgcGdfdXBncmFk ZSBkb2Vzbid0IGtub3cgYWJvdXQuICBJZiB0aGUNCj5zZXJ2ZXIgaXMgZG93 biwgcGdfdXBncmFkZSBoYXMgdG8gc3RhcnQgaXQgdG8gY2hlY2sgaXQsIGFu ZCB0aGF0IG1pZ2h0DQo+YmUgY2F1c2luZyB0aGUgcHJvYmxlbS4gIEl0IHdv dWxkIGFsc28gYmUgZ29vZCB0byBrbm93IGlmIHRoZSBmYWlsdXJlIGlzDQo+ d2l0aCB0aGUgb2xkIG9yIG5ldyBjbHVzdGVyLg0KDQpwZ191cGdyYWRlX3Nl cnZlci5sb2cgb3V0cHV0cyBiZWxvdyBtZXNzYWdlOg0KDQotLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLQ0KICBwZ191cGdyYWRlIHJ1biBvbiBNb24gT2N0ICA1IDE5 OjE3OjE3IDIwMTUNCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQoNCmNvbW1hbmQ6 ICIvdXNyL3Bnc3FsLTkuMy9iaW4vcGdfY3RsIiAtdyAtbCAicGdfdXBncmFk ZV9zZXJ2ZXIubG9nIiAtRA0KIi9kYXRhL3BnLm9sZCIgLW8gIi1wIDUwNDMy IC1iICAtYyBsaXN0ZW5fYWRkcmVzc2VzPScnIC1jDQp1bml4X3NvY2tldF9w ZXJtaXNzaW9ucz0wNzAwIC1jIHVuaXhfc29ja2V0X2RpcmVjdG9yaWVzPScv dmFyL2xpYi9wZ3NxbCciDQpzdGFydCA+PiAicGdfdXBncmFkZV9zZXJ2ZXIu bG9nIiAyPiYxDQp3YWl0aW5nIGZvciBzZXJ2ZXIgdG8gc3RhcnQuLi4uPDIw MTUtMTAtMDUgMTU6MTc6MTcuODAyIEVEVD4NCnVzZXI9LGRiPSxob3N0PSxw cm9jZXNzaWQ9MTg3NjEgTE9HOiAgcmVkaXJlY3RpbmcgbG9nIG91dHB1dCB0 byBsb2dnaW5nDQpjb2xsZWN0b3IgcHJvY2Vzcw0KPDIwMTUtMTAtMDUgMTU6 MTc6MTcuODAyIEVEVD4gdXNlcj0sZGI9LGhvc3Q9LHByb2Nlc3NpZD0xODc2 MSBISU5UOg0KRnV0dXJlIGxvZyBvdXRwdXQgd2lsbCBhcHBlYXIgaW4gZGly ZWN0b3J5ICJwZ19sb2ciLg0KIGRvbmUNCnNlcnZlciBzdGFydGVkDQoNCg0K Y29tbWFuZDogIi91c3IvcGdzcWwtOS4zL2Jpbi9wZ19jdGwiIC13IC1EICIv ZGF0YS9wZy5vbGQiIC1vICIiIC1tIGZhc3QNCnN0b3AgPj4gInBnX3VwZ3Jh ZGVfc2VydmVyLmxvZyIgMj4mMQ0Kd2FpdGluZyBmb3Igc2VydmVyIHRvIHNo dXQgZG93bi4uLi4gZG9uZQ0Kc2VydmVyIHN0b3BwZWQNCg0KSSB0cmllZCB0 byBleGVjdXRlIHRoZSBzdGFydCBjb21tYW5kIG9uIG15IG93biwgaXQgZGlk bqGvdCB0aHJvdyBlcnJvciBidXQNCnRoZSBzZXJ2ZXIgaXMgbm90IGFjY2Vz c2libGUuIEmhr20gZ3Vlc3NpbmcgaXShr3MgYmVjYXVzZSBvZiB0aGUNCmxp c3Rlbl9hZGRyZXNzZXM9oa6hryBwYXJhbWV0ZXIuDQoNCg0KQmVsb3cgYXJl IHRoZSBsb2cgZW50cmllcyBkdXJpbmcgdGhhdCBzdGFydCBjb21tYW5kOg0K DQo8MjAxNS0xMC0wNSAxNTo0Mjo1MC41MDYgRURUPiB1c2VyPSxkYj0saG9z dD0scHJvY2Vzc2lkPTE4OTE3IExPRzoNCmRhdGFiYXNlIHN5c3RlbSB3YXMg c2h1dCBkb3duIGF0IDIwMTUtMTAtMDUgMTU6NDI6MzAgRURUDQo8MjAxNS0x MC0wNSAxNTo0Mjo1MC41MTAgRURUPiB1c2VyPSxkYj0saG9zdD0scHJvY2Vz c2lkPTE4OTE1IExPRzoNCmRhdGFiYXNlIHN5c3RlbSBpcyByZWFkeSB0byBh Y2NlcHQgY29ubmVjdGlvbnMNCg0KDQo+DQo+SSBoYXZlIG5ldmVyIHNlZW4g YSBmYWlsdXJlIGxpa2UgdGhpcy4NCj4NCj4tLSANCj4gIEJydWNlIE1vbWpp YW4gIDxicnVjZUBtb21qaWFuLnVzPiAgICAgICAgaHR0cDovL21vbWppYW4u dXMNCj4gIEVudGVycHJpc2VEQiAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgaHR0cDovL2VudGVycHJpc2VkYi5jb20NCj4NCj4rIEFzIHlvdSBhcmUs IHNvIG9uY2Ugd2FzIEkuIEFzIEkgYW0sIHNvIHlvdSB3aWxsIGJlLiArDQo+ KyBSb21hbiBncmF2ZSBpbnNjcmlwdGlvbiAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgKw0KDQoKLS0gClNlbnQgdmlhIHBnc3FsLWFkbWluIG1haWxp bmcgbGlzdCAocGdzcWwtYWRtaW5AcG9zdGdyZXNxbC5vcmcpClRvIG1ha2Ug Y2hhbmdlcyB0byB5b3VyIHN1YnNjcmlwdGlvbjoKaHR0cDovL3d3dy5wb3N0 Z3Jlc3FsLm9yZy9tYWlscHJlZi9wZ3NxbC1hZG1pbgo=