Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1a1KI7-0007HO-3B for pgsql-admin@arkaria.postgresql.org; Tue, 24 Nov 2015 20:34:19 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1a1KI6-0000hl-Ji for pgsql-admin@arkaria.postgresql.org; Tue, 24 Nov 2015 20:34:18 +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 1a1KGS-0007I0-1b for pgsql-admin@postgresql.org; Tue, 24 Nov 2015 20:32:36 +0000 Received: from mr2.symcor.com ([205.189.242.12]) by magus.postgresql.org with esmtps (TLS1.0:DHE_RSA_CAMELLIA_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1a1KGN-0005TW-Te for pgsql-admin@postgresql.org; Tue, 24 Nov 2015 20:32:34 +0000 Received-SPF: None (mr2.symcor.com: no sender authenticity information available from domain of YBarot@symcor.com) identity=mailfrom; client-ip=172.25.152.11; receiver=mr2.symcor.com; envelope-from="YBarot@symcor.com"; x-sender="YBarot@symcor.com"; x-conformance=spf_only Received-SPF: None (mr2.symcor.com: no sender authenticity information available from domain of postmaster@MX001.symprod.com) identity=helo; client-ip=172.25.152.11; receiver=mr2.symcor.com; envelope-from="YBarot@symcor.com"; x-sender="postmaster@MX001.symprod.com"; x-conformance=spf_only X-IronPort-AV: E=Sophos;i="5.20,339,1444708800"; d="scan'208";a="43271454" Received: from mx001.symprod.com ([172.25.152.11]) by mr2.symcor.com with ESMTP; 24 Nov 2015 15:32:20 -0500 Received: from MX002.symprod.com (172.25.152.12) by MX001.symprod.com (172.25.152.11) with Microsoft SMTP Server (TLS) id 15.0.1044.25; Tue, 24 Nov 2015 15:32:18 -0500 Received: from MX002.symprod.com ([fe80::6cbc:31f6:fb5c:2f2f]) by MX002.symprod.com ([fe80::6cbc:31f6:fb5c:2f2f%15]) with mapi id 15.00.1044.021; Tue, 24 Nov 2015 15:32:18 -0500 From: Yogi Barot To: 'Albe Laurenz' , "'pgsql-admin@postgresql.org'" Subject: Re: Postgresql 9.4 pg_upgrade issues Thread-Topic: Postgresql 9.4 pg_upgrade issues Thread-Index: AdEjAGV3yn9Ef7JGS1GGnVPF7rUGHQD0zrRAAAjLPrA= Date: Tue, 24 Nov 2015 20:32:18 +0000 Message-ID: <622de7fb272e489292d5e6b41ae44c29@MX002.symprod.com> References: <6fb1f76dc5aa4d0a9285aa25ac099476@MX002.symprod.com> In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-ms-exchange-transport-fromentityheader: Hosted x-originating-ip: [10.249.248.20] Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 X-Pg-Spam-Score: -3.2 (---) 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 SGksDQoNCkkgd2FzIGFibGUgdG8gbWFuYWdlIHVwZ3JhZGUgdGVzdGluZyB3 aXRoIGNsdXN0ZXIgd2hpY2ggZG9lcyBub3QgaGF2ZSBwbHNoIGZvciBub3cu DQoNCkJ1dCBJIGhhdmUgYW5vdGhlciBwcm9ibGVtLiBBbGwgbXkgZGF0YSBU QiBpcyBpbiB0aGUgdGFibGVzcGFjZSBpbiBQR0RhdGEgZGlyZWN0b3J5LCBJ IGRpZCB0aGUgdXBncmFkZSB1c2luZyBsaW5rIG1ldGhvZCwgbm93IEkgZ290 IHRoaXMgd2FybmluZy4gIA0KDQpVcGdyYWRlIENvbXBsZXRlDQotLS0tLS0t LS0tLS0tLS0tDQpPcHRpbWl6ZXIgc3RhdGlzdGljcyBhcmUgbm90IHRyYW5z ZmVycmVkIGJ5IHBnX3VwZ3JhZGUgc28sDQpvbmNlIHlvdSBzdGFydCB0aGUg bmV3IHNlcnZlciwgY29uc2lkZXIgcnVubmluZzoNCiAgICBhbmFseXplX25l d19jbHVzdGVyLnNoDQoNCkNvdWxkIG5vdCBjcmVhdGUgYSBzY3JpcHQgdG8g ZGVsZXRlIHRoZSBvbGQgY2x1c3RlcidzIGRhdGENCmZpbGVzIGJlY2F1c2Ug dXNlci1kZWZpbmVkIHRhYmxlc3BhY2VzIGV4aXN0IGluIHRoZSBvbGQgY2x1 c3Rlcg0KZGlyZWN0b3J5LiAgVGhlIG9sZCBjbHVzdGVyJ3MgY29udGVudHMg bXVzdCBiZSBkZWxldGVkIG1hbnVhbGx5Lg0KDQoxKSBEb2VzIFRoaXMgbWVh bnMgLCBJIGNhbid0IGRlbGV0ZSBvbGQgY2x1c3RlciBkYXRhIGRpcmVjdG9y eT8gT3IgSSBjYW4gZGVsZXRlIGl0IG1hbnVhbGx5Pw0KMikgRGVsZXRpbmcg b2xkIGRhdGEgZGlyZWN0b3J5IHdpbGwgZWZmZWN0IGFueSBmdW5jdGlvbmFs aXR5IG9mIHBvc3RncmVzcWwgbmV3IGNsdXN0ZXI/DQozKSBBbHNvIE5lZWQg c29tZSBjbGFyaWZpY2F0aW9uIG9uIGxpbmsgbW9kZSwgd2hhdCBpZiBJIHVw Z3JhZGUgZnJvbSA5LjUuIHRvIGZ1dHVyZSByZWxlYXNlIHVzaW5nIHBnX3Vw Z2FyZGUgbGluayBtb2RlIHdpbGwgc3RpbGwgd29yayBvbiBzYW1lIGRhdGEg ZGlyZWN0b3J5Pw0KDQpUaGFua3MsDQpZb2dpDQoNCg0KLS0tLS1PcmlnaW5h bCBNZXNzYWdlLS0tLS0NCkZyb206IEFsYmUgTGF1cmVueiBbbWFpbHRvOmxh dXJlbnouYWxiZUB3aWVuLmd2LmF0XSANClNlbnQ6IFR1ZXNkYXksIE5vdmVt YmVyIDI0LCAyMDE1IDExOjI2IEFNDQpUbzogWW9naSBCYXJvdDsgJ3Bnc3Fs LWFkbWluQHBvc3RncmVzcWwub3JnJw0KU3ViamVjdDogUkU6IFBvc3RncmVz cWwgOS40IHBnX3VwZ3JhZGUgaXNzdWVzDQoNCllvZ2kgQmFyb3Qgd3JvdGU6 DQo+IEkgYW0gcnVubmluZyBwb3N0Z3Jlc3FsIHVwZ3JhZGUgZnJvbSBwb3N0 Z3Jlc3FsIDkuMC4xMSAgdG8gcG9zdGdyZXNxbCANCj4gOS40IHVzaW5nIHBn X3VwZ3JhZGUgbGluayBtZXRob2QgYW5kIGhhdmluZyBzb21lIGlzc3VlcyB3 aXRoIHVwZ3JhZGUgb24gUmVoIGhhdCA3LjEuDQo+IA0KPiBIZXJlIGlzIHRo ZSBlcnJvciBtZXNzYWdlLCB0aGF0IEkgYW0gZ2V0dGluZyB2aWEgcGdfdXBn cmFkZToNCj4gDQo+IC91c3IvcGdzcWwtOS40L2Jpbi9wZ191cGdyYWRlIC0t b2xkLWJpbmRpcj0vdXNyL2xvY2FsL3Bnc3FsL2JpbiANCj4gLS1uZXctYmlu ZGlyPS91c3IvcGdzcWwtOS40L2JpbiAtLW9sZC0gZGF0YWRpcj0vb3B0L3N5 bWNvci1mb2EvZGF0YSANCj4gLS1uZXctZGF0YWRpcj0vb3B0L3N5bWNvci1m b2EvZGF0YTk0ICAtdiAtLXVzZXI9cGdfZm9hX2MgIC0tbGluayAgLXAgDQo+ IDU0MzIgLVAgNTQzMw0KPiANCj4gY2F0ICBsb2FkYWJsZV9saWJyYXJpZXMu dHh0DQo+IENvdWxkIG5vdCBsb2FkIGxpYnJhcnkgIi9vcHQvc3ltY29yLWZv YS9wZ3NxbC8vbGliL3BncGxzaC9wZ3Bsc2guc28iDQo+IEVSUk9SOiAgY291 bGQgbm90IGxvYWQgbGlicmFyeSANCj4gIi9vcHQvc3ltY29yLWZvYS9wZ3Nx bC8vbGliL3BncGxzaC9wZ3Bsc2guc28iOiAvb3B0L3N5bWNvci0NCj4gZm9h L3Bnc3FsLy9saWIvcGdwbHNoL3BncGxzaC5zbzogdW5kZWZpbmVkIHN5bWJv bDogRGlyZWN0RnVuY3Rpb25DYWxsMQ0KPiANCj4gSW4gdGhlIG9yaWdpbmFs IGNsdXN0ZXIsIEkgaGF2ZSByZW1vdmVkIGZ1bmN0aW9uIGFuZCBsYW5ndWFn ZSB3aGljaCANCj4gcmVmZXJlbmNlIHRoaXMgbGlicmFyeSwgSSBhbHNvIHRv b2sgcG9zdGdyZXMgZHVtcCB1c2luZyBwZ19kdW1wYWxsIGFuZCANCj4gaXQg ZG9lcyBub3Qgc2hvdyBhbnkgcmVmZXJlbmNlIHRvIHRoaXMgbGlicmFyeSBw bHNoLiBTdGlsbCBwZ191cGdhcmRlIHNvbWVob3cgcmVmZXJlbmNlIHRoaXMg bGlicmFyeS4NCj4gDQo+IEFueSBoZWxwIGdyZWF0bHkgYXBwcmljYWl0ZWQg YXMgSSBhbSBzdHVjayBoZXJlLCBjYW4gbm90IGJ1aWxkIGxpYnJhcnkgDQo+ IG9uIG5ldyBSaGVsIDcgY2x1c3Rlciwgd2UgZG9u4oCZdCBuZWVkIGxpYnJh cnksIGJ1dCBub3Qgc3VyZSBob3cgdG8gDQo+IHJlbW92ZSB0aGUgcmVmZXJl bmNlIG9mIGl0IGNvbXBsZXRlbHkuIEkgZHJvcHBlZCBmcm9tIGFsbCBkYXRh YmFzZXMgDQo+IGFuZCBldmVuIGZyb20gdGVtcGxhdGUxIGRhdGFiYXNlIHVz aW5nIGRyb3BsaWIgcGxzaDsNCg0KSSBndWVzcyB5b3UgZmFpbGVkIHRvIHJl bW92ZSBQTC9zaCBpbiB0aGUgb3JpZ2luYWwgY2x1c3Rlci4NCg0KRGlkIHlv dSB0cnkgdGhlIGZvbGxvd2luZyBpbiBhbGwgZGF0YWJhc2VzOg0KICAgRFJP UCBMQU5HVUFHRSBwbHNoIENBU0NBREU7DQogICBEUk9QIEZVTkNUSU9OIHBs c2hfaGFuZGxlcigpOw0KICAgRFJPUCBGVU5DVElPTiBwbHNoX3ZhbGlkYXRv cihvaWQpOw0KDQpZb3VycywNCkxhdXJlbnogQWxiZQ0KCgpDT05GSURFTlRJ QUxJVFkgV0FSTklORyAKVGhpcyBjb21tdW5pY2F0aW9uLCBpbmNsdWRpbmcg YW55IGF0dGFjaG1lbnRzLCBpcyBmb3IgdGhlIGV4Y2x1c2l2ZSB1c2Ugb2Yg YWRkcmVzc2VlIGFuZCBtYXkgY29udGFpbiBwcm9wcmlldGFyeSBhbmQvb3Ig Y29uZmlkZW50aWFsIGluZm9ybWF0aW9uLiBJZiB5b3UgYXJlIG5vdCB0aGUg aW50ZW5kZWQgcmVjaXBpZW50LCBhbnkgdXNlLCBjb3B5aW5nLCBkaXNjbG9z dXJlLCBkaXNzZW1pbmF0aW9uIG9yIGRpc3RyaWJ1dGlvbiBpcyBzdHJpY3Rs eSBwcm9oaWJpdGVkLiBJZiB5b3UgYXJlIG5vdCB0aGUgaW50ZW5kZWQgcmVj aXBpZW50LCBwbGVhc2Ugbm90aWZ5IHRoZSBzZW5kZXIgaW1tZWRpYXRlbHkg YnkgcmV0dXJuIGUtbWFpbCwgZGVsZXRlIHRoaXMgY29tbXVuaWNhdGlvbiBh bmQgZGVzdHJveSBhbGwgY29waWVzLgoKQVZFUlRJU1NFTUVOVCBSRUxBVElG IMOAIExBIENPTkZJREVOVElBTElUw4kgCkNlIG1lc3NhZ2UsIGFpbnNpIHF1 ZSBsZXMgcGnDqGNlcyBxdWkgeSBzb250IGpvaW50ZXMsIGVzdCBkZXN0aW7D qSDDoCBs4oCZdXNhZ2UgZXhjbHVzaWYgZGUgbGEgcGVyc29ubmUgw6AgbGFx dWVsbGUgaWwgc+KAmWFkcmVzc2UgZXQgcGV1dCBjb250ZW5pciBkZSBs4oCZ aW5mb3JtYXRpb24gcGVyc29ubmVsbGUgb3UgY29uZmlkZW50aWVsbGUuIFNp IGxlIGxlY3RldXIgZGUgY2UgbWVzc2FnZSBu4oCZZW4gZXN0IHBhcyBsZSBk ZXN0aW5hdGFpcmUsIG5vdXMgbOKAmWF2aXNvbnMgcGFyIGxhIHByw6lzZW50 ZSBxdWUgdG91dGUgZGlmZnVzaW9uLCBkaXN0cmlidXRpb24sIHJlcHJvZHVj dGlvbiBvdSB1dGlsaXNhdGlvbiBkZSBzb24gY29udGVudSBlc3Qgc3RyaWN0 ZW1lbnQgaW50ZXJkaXRlLiBWZXVpbGxleiBhdmVydGlyIHN1ci1sZS1jaGFt cCBs4oCZZXhww6lkaXRldXIgcGFyIHJldG91ciBkZSBjb3VycmllciDDqWxl Y3Ryb25pcXVlIGV0IHN1cHByaW1leiBjZSBtZXNzYWdlIGFpbnNpIHF1ZSB0 b3V0ZXMgbGVzIHBpw6hjZXMgam9pbnRlcy4KCi0tIApTZW50IHZpYSBwZ3Nx bC1hZG1pbiBtYWlsaW5nIGxpc3QgKHBnc3FsLWFkbWluQHBvc3RncmVzcWwu b3JnKQpUbyBtYWtlIGNoYW5nZXMgdG8geW91ciBzdWJzY3JpcHRpb246Cmh0 dHA6Ly93d3cucG9zdGdyZXNxbC5vcmcvbWFpbHByZWYvcGdzcWwtYWRtaW4K