Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rFJMK-009IcJ-9W for pgsql-admin@arkaria.postgresql.org; Mon, 18 Dec 2023 19:33:00 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rFJMI-00CClx-UG for pgsql-admin@arkaria.postgresql.org; Mon, 18 Dec 2023 19:32:58 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rFJMH-00CCkm-M2 for pgsql-admin@lists.postgresql.org; Mon, 18 Dec 2023 19:32:58 +0000 Received: from mx0a-000e5c14.pphosted.com ([148.163.133.209]) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rFJMC-00Cfhf-HR for pgsql-admin@lists.postgresql.org; Mon, 18 Dec 2023 19:32:56 +0000 Received: from pps.filterd (m0206225.ppops.net [127.0.0.1]) by mx0a-000e5c14.pphosted.com (8.17.1.19/8.17.1.19) with ESMTP id 3BICZuep000697; Mon, 18 Dec 2023 13:32:47 -0600 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=express-scripts.com; h=from : to : cc : date : message-id : references : in-reply-to : content-type : mime-version : subject; s=pod140124231234; bh=qJRjURMtSavtemS04cBljdjcayd3jBU2ppwvjXub6pA=; b=uIio/iu+NOWcsRjZsjn79YuktUJXZlWTUBabtihKOgPI2RrCY2xwoKh2CytEn/Kf1K+w fekhtosvN77+/G9ulQFSHM6owXw7pOLynwF1kyaFMm2QRixTnHa9p3ynGjb4oPexPmM8 pLl7dFEwq7OTC+3pAnp2+Ce8LCiz5sKogbUXxPMAmco573DURjmYAXKhm/boqPM+jmTU oI4t8WGoTYBnqCNXtMg5U48bW0/J2T5w9pwxiEotfGI0s2fjnOtrNvE46lu2DnRe0XLw WrD30qeSZrKBtt/A7I20KqdmzDrQa2HDt6/yRTA5JfeXfvl8FFbBqUBEksz9lgiYDBQG tQ== Received: from eiaappxp0005.gid.prd.globalcore.com ([170.48.0.128]) by mx0a-000e5c14.pphosted.com (PPS) with ESMTPS id 3v192uwkp5-2 (version=TLSv1.2 cipher=ECDHE-RSA-AES256-GCM-SHA384 bits=256 verify=NOT); Mon, 18 Dec 2023 13:32:47 -0600 Received: from cvlappxp20751.internal.cigna.com (HELO PS2PW1012187.accounts.root.corp) ([10.36.52.88]) by EIAAPPXP0005.gid.prd.globalcore.com with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 18 Dec 2023 19:32:47 +0000 Received: from PS2PW1012186.accounts.root.corp (10.221.225.154) by PS2PW1012187.accounts.root.corp (10.221.225.157) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.2.1258.27; Mon, 18 Dec 2023 14:32:46 -0500 Received: from PS2PW1012186.accounts.root.corp ([fe80::ddfb:faf8:59ca:a8ec]) by PS2PW1012186.accounts.root.corp ([fe80::ddfb:faf8:59ca:a8ec%6]) with mapi id 15.02.1258.027; Mon, 18 Dec 2023 14:32:46 -0500 From: "Wetmore, Matthew (CTR)" To: GF , Aditya D CC: pgsql-admin Thread-Topic: [EXTERNAL] Re: Guidance required to summarize the migration breaking changes between PG versions Thread-Index: AQHaMejOokCnxeJT8ka9N+JUUrR5c7Cvbhuw Date: Mon, 18 Dec 2023 19:32:46 +0000 Message-ID: <6421dc6999c343fbb3e7afd75e256e63@express-scripts.com> References: In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.222.252.1] x-proofpoint-routing: 000e5c14 Content-Type: multipart/alternative; boundary="_000_6421dc6999c343fbb3e7afd75e256e63expressscriptscom_" MIME-Version: 1.0 X-CFilter-Loop: Reflected Subject: Guidance required to summarize the migration breaking changes between PG versions X-Proofpoint-Virus-Version: vendor=baseguard engine=ICAP:2.0.272,Aquarius:18.0.997,Hydra:6.0.619,FMLib:17.11.176.26 definitions=2023-12-18_13,2023-12-14_01,2023-05-22_02 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_6421dc6999c343fbb3e7afd75e256e63expressscriptscom_ Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 UG9zdGdyZVNRTDogUmVsZWFzZSBOb3RlczxodHRwczovL3d3dy5wb3N0Z3Jlc3FsLm9yZy9kb2Nz L3JlbGVhc2UvPg0KDQpGcm9tOiBHRiA8cGhhYnJpekBnbWFpbC5jb20+DQpTZW50OiBNb25kYXks IERlY2VtYmVyIDE4LCAyMDIzIDExOjMxIEFNDQpUbzogQWRpdHlhIEQgPGRzYWRpdHlhOTFAZ21h aWwuY29tPg0KQ2M6IHBnc3FsLWFkbWluIDxwZ3NxbC1hZG1pbkBsaXN0cy5wb3N0Z3Jlc3FsLm9y Zz4NClN1YmplY3Q6IFtFWFRFUk5BTF0gUmU6IEd1aWRhbmNlIHJlcXVpcmVkIHRvIHN1bW1hcml6 ZSB0aGUgbWlncmF0aW9uIGJyZWFraW5nIGNoYW5nZXMgYmV0d2VlbiBQRyB2ZXJzaW9ucw0KDQoN Cg0KSSB3YW50ZWQgdG8gdW5kZXJzdGFuZCBpZiB0aGVyZSBpcyBhbnkgd2F5IG9yIGFueSByZWZl cmVuY2VzIGFwYXJ0IGZyb20gcmVsZWFzZSBub3RlcyB3aGljaCBzdW1tYXJpemUgYWxsIHRoZSBt aWdyYXRpb24gYnJlYWtpbmcgY2hhbmdlcyBiZXR3ZWVuIGRpZmZlcmVudCBQb3N0Z3JlU1FMIHZl cnNpb25zLg0KDQpMZXQgdXMgc2F5IGZvciBleGFtcGxlLCBJIHdhbnQgdG8gbWlncmF0ZSBmcm9t IFBvc3RncmVTUUwgdmVyc2lvbiA5LjUgdG8gMTMuIElzIHRoZXJlIGFueSB3YXkgd2UgZ2V0IHRo ZSBjb2xsYXRlZCBsaXN0IG9mIGNoYW5nZXMgcmVsYXRlZCB0byBtaWdyYXRpb24gZnJvbSA5LjUg LS0+IDkuNiAtLT4gMTAgLS0+IDExIC0tPiAxMiAtLT4xMy4NCg0KVGhhbmtzICYgUmVnYXJkcywN CkFkaXR5YSBEDQoNCkNvdWxkIHRoaXMgd29yayBmb3IgeW91Pw0KaHR0cHM6Ly93aHktdXBncmFk ZS5kZXBlc3ouY29tL3Nob3c/ZnJvbT05LjUmdG89MTM8aHR0cHM6Ly91cmxkZWZlbnNlLmNvbS92 My9fX2h0dHBzOi93aHktdXBncmFkZS5kZXBlc3ouY29tL3Nob3c/ZnJvbT05LjUmdG89MTNfXzsh IUdGRThkUzZhY2xiMGgxbmtoUGY5ITUtaFl2dTlobTVZMklRU1p4Rlk1WXBHclloTjk3T0ltQlFV VWxadjdUTm5yNFRodkVBWm00ZG5oSmFJN2dSLUpzLW9mcmJON3BZRW14ekFQNXBCdVhtSUpHbWho JD4NCg0KQmVzdCwNCkdpb3Zhbm5pDQo= --_000_6421dc6999c343fbb3e7afd75e256e63expressscriptscom_ Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: base64 PGh0bWwgeG1sbnM6dj0idXJuOnNjaGVtYXMtbWljcm9zb2Z0LWNvbTp2bWwiIHhtbG5zOm89InVy bjpzY2hlbWFzLW1pY3Jvc29mdC1jb206b2ZmaWNlOm9mZmljZSIgeG1sbnM6dz0idXJuOnNjaGVt YXMtbWljcm9zb2Z0LWNvbTpvZmZpY2U6d29yZCIgeG1sbnM6bT0iaHR0cDovL3NjaGVtYXMubWlj cm9zb2Z0LmNvbS9vZmZpY2UvMjAwNC8xMi9vbW1sIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcv VFIvUkVDLWh0bWw0MCI+DQo8aGVhZD4NCjxtZXRhIGh0dHAtZXF1aXY9IkNvbnRlbnQtVHlwZSIg Y29udGVudD0idGV4dC9odG1sOyBjaGFyc2V0PXV0Zi04Ij4NCjxtZXRhIG5hbWU9IkdlbmVyYXRv ciIgY29udGVudD0iTWljcm9zb2Z0IFdvcmQgMTUgKGZpbHRlcmVkIG1lZGl1bSkiPg0KPHN0eWxl PjwhLS0NCi8qIEZvbnQgRGVmaW5pdGlvbnMgKi8NCkBmb250LWZhY2UNCgl7Zm9udC1mYW1pbHk6 IkNhbWJyaWEgTWF0aCI7DQoJcGFub3NlLTE6MiA0IDUgMyA1IDQgNiAzIDIgNDt9DQpAZm9udC1m YWNlDQoJe2ZvbnQtZmFtaWx5OkNhbGlicmk7DQoJcGFub3NlLTE6MiAxNSA1IDIgMiAyIDQgMyAy IDQ7fQ0KLyogU3R5bGUgRGVmaW5pdGlvbnMgKi8NCnAuTXNvTm9ybWFsLCBsaS5Nc29Ob3JtYWws IGRpdi5Nc29Ob3JtYWwNCgl7bWFyZ2luOjBpbjsNCgltYXJnaW4tYm90dG9tOi4wMDAxcHQ7DQoJ Zm9udC1zaXplOjEyLjBwdDsNCglmb250LWZhbWlseToiVGltZXMgTmV3IFJvbWFuIixzZXJpZjt9 DQphOmxpbmssIHNwYW4uTXNvSHlwZXJsaW5rDQoJe21zby1zdHlsZS1wcmlvcml0eTo5OTsNCglj b2xvcjpibHVlOw0KCXRleHQtZGVjb3JhdGlvbjp1bmRlcmxpbmU7fQ0KYTp2aXNpdGVkLCBzcGFu Lk1zb0h5cGVybGlua0ZvbGxvd2VkDQoJe21zby1zdHlsZS1wcmlvcml0eTo5OTsNCgljb2xvcjpw dXJwbGU7DQoJdGV4dC1kZWNvcmF0aW9uOnVuZGVybGluZTt9DQpwLm1zb25vcm1hbDAsIGxpLm1z b25vcm1hbDAsIGRpdi5tc29ub3JtYWwwDQoJe21zby1zdHlsZS1uYW1lOm1zb25vcm1hbDsNCglt c28tbWFyZ2luLXRvcC1hbHQ6YXV0bzsNCgltYXJnaW4tcmlnaHQ6MGluOw0KCW1zby1tYXJnaW4t Ym90dG9tLWFsdDphdXRvOw0KCW1hcmdpbi1sZWZ0OjBpbjsNCglmb250LXNpemU6MTIuMHB0Ow0K CWZvbnQtZmFtaWx5OiJUaW1lcyBOZXcgUm9tYW4iLHNlcmlmO30NCnNwYW4uRW1haWxTdHlsZTE4 DQoJe21zby1zdHlsZS10eXBlOnBlcnNvbmFsLXJlcGx5Ow0KCWZvbnQtZmFtaWx5OiJDYWxpYnJp IixzYW5zLXNlcmlmOw0KCWNvbG9yOiMxRjQ5N0Q7fQ0KLk1zb0NocERlZmF1bHQNCgl7bXNvLXN0 eWxlLXR5cGU6ZXhwb3J0LW9ubHk7DQoJZm9udC1mYW1pbHk6IkNhbGlicmkiLHNhbnMtc2VyaWY7 fQ0KQHBhZ2UgV29yZFNlY3Rpb24xDQoJe3NpemU6OC41aW4gMTEuMGluOw0KCW1hcmdpbjoxLjBp biAxLjBpbiAxLjBpbiAxLjBpbjt9DQpkaXYuV29yZFNlY3Rpb24xDQoJe3BhZ2U6V29yZFNlY3Rp b24xO30NCi0tPjwvc3R5bGU+PCEtLVtpZiBndGUgbXNvIDldPjx4bWw+DQo8bzpzaGFwZWRlZmF1 bHRzIHY6ZXh0PSJlZGl0IiBzcGlkbWF4PSIxMDI2IiAvPg0KPC94bWw+PCFbZW5kaWZdLS0+PCEt LVtpZiBndGUgbXNvIDldPjx4bWw+DQo8bzpzaGFwZWxheW91dCB2OmV4dD0iZWRpdCI+DQo8bzpp ZG1hcCB2OmV4dD0iZWRpdCIgZGF0YT0iMSIgLz4NCjwvbzpzaGFwZWxheW91dD48L3htbD48IVtl bmRpZl0tLT4NCjwvaGVhZD4NCjxib2R5IGxhbmc9IkVOLVVTIiBsaW5rPSJibHVlIiB2bGluaz0i cHVycGxlIj4NCjxkaXYgY2xhc3M9IldvcmRTZWN0aW9uMSI+DQo8cCBjbGFzcz0iTXNvTm9ybWFs Ij48YSBocmVmPSJodHRwczovL3d3dy5wb3N0Z3Jlc3FsLm9yZy9kb2NzL3JlbGVhc2UvIj5Qb3N0 Z3JlU1FMOiBSZWxlYXNlIE5vdGVzPC9hPjxzcGFuIHN0eWxlPSJmb250LXNpemU6MTEuMHB0O2Zv bnQtZmFtaWx5OiZxdW90O0NhbGlicmkmcXVvdDssc2Fucy1zZXJpZjtjb2xvcjojMUY0OTdEIj48 bzpwPjwvbzpwPjwvc3Bhbj48L3A+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj48c3BhbiBzdHlsZT0i Zm9udC1zaXplOjExLjBwdDtmb250LWZhbWlseTomcXVvdDtDYWxpYnJpJnF1b3Q7LHNhbnMtc2Vy aWY7Y29sb3I6IzFGNDk3RCI+PG86cD4mbmJzcDs8L286cD48L3NwYW4+PC9wPg0KPHAgY2xhc3M9 Ik1zb05vcm1hbCI+PGI+PHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToxMS4wcHQ7Zm9udC1mYW1pbHk6 JnF1b3Q7Q2FsaWJyaSZxdW90OyxzYW5zLXNlcmlmIj5Gcm9tOjwvc3Bhbj48L2I+PHNwYW4gc3R5 bGU9ImZvbnQtc2l6ZToxMS4wcHQ7Zm9udC1mYW1pbHk6JnF1b3Q7Q2FsaWJyaSZxdW90OyxzYW5z LXNlcmlmIj4gR0YgJmx0O3BoYWJyaXpAZ21haWwuY29tJmd0Ow0KPGJyPg0KPGI+U2VudDo8L2I+ IE1vbmRheSwgRGVjZW1iZXIgMTgsIDIwMjMgMTE6MzEgQU08YnI+DQo8Yj5Ubzo8L2I+IEFkaXR5 YSBEICZsdDtkc2FkaXR5YTkxQGdtYWlsLmNvbSZndDs8YnI+DQo8Yj5DYzo8L2I+IHBnc3FsLWFk bWluICZsdDtwZ3NxbC1hZG1pbkBsaXN0cy5wb3N0Z3Jlc3FsLm9yZyZndDs8YnI+DQo8Yj5TdWJq ZWN0OjwvYj4gW0VYVEVSTkFMXSBSZTogR3VpZGFuY2UgcmVxdWlyZWQgdG8gc3VtbWFyaXplIHRo ZSBtaWdyYXRpb24gYnJlYWtpbmcgY2hhbmdlcyBiZXR3ZWVuIFBHIHZlcnNpb25zPG86cD48L286 cD48L3NwYW4+PC9wPg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PG86cD4mbmJzcDs8L286cD48L3A+ DQo8ZGl2Pg0KPGRpdj4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPjxvOnA+Jm5ic3A7PC9vOnA+PC9w Pg0KPC9kaXY+DQo8ZGl2Pg0KPGRpdj4NCjxibG9ja3F1b3RlIHN0eWxlPSJib3JkZXI6bm9uZTti b3JkZXItbGVmdDpzb2xpZCAjQ0NDQ0NDIDEuMHB0O3BhZGRpbmc6MGluIDBpbiAwaW4gNi4wcHQ7 bWFyZ2luLWxlZnQ6NC44cHQ7bWFyZ2luLXJpZ2h0OjBpbiI+DQo8ZGl2Pg0KPGRpdj4NCjxwIGNs YXNzPSJNc29Ob3JtYWwiPjxvOnA+Jm5ic3A7PC9vOnA+PC9wPg0KPC9kaXY+DQo8ZGl2Pg0KPHAg Y2xhc3M9Ik1zb05vcm1hbCI+SSB3YW50ZWQgdG8gdW5kZXJzdGFuZCBpZiB0aGVyZSBpcyZuYnNw O2FueSB3YXkgb3IgYW55IHJlZmVyZW5jZXMgYXBhcnQgZnJvbSByZWxlYXNlIG5vdGVzIHdoaWNo IHN1bW1hcml6ZSBhbGwgdGhlIG1pZ3JhdGlvbiBicmVha2luZyBjaGFuZ2VzIGJldHdlZW4gZGlm ZmVyZW50IFBvc3RncmVTUUwgdmVyc2lvbnMuPG86cD48L286cD48L3A+DQo8L2Rpdj4NCjxkaXY+ DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj48bzpwPiZuYnNwOzwvbzpwPjwvcD4NCjwvZGl2Pg0KPGRp dj4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPkxldCB1cyBzYXkgPGk+Zm9yIGV4YW1wbGU8L2k+LCBJ IHdhbnQgdG8gbWlncmF0ZSBmcm9tIFBvc3RncmVTUUwgdmVyc2lvbiA5LjUgdG8gMTMuIElzIHRo ZXJlIGFueSB3YXkgd2UgZ2V0IHRoZSBjb2xsYXRlZCBsaXN0IG9mIGNoYW5nZXMgcmVsYXRlZCB0 byBtaWdyYXRpb24gZnJvbSA5LjUgLS0mZ3Q7IDkuNiAtLSZndDsgMTAgLS0mZ3Q7IDExIC0tJmd0 OyAxMiAtLSZndDsxMy48bzpwPjwvbzpwPjwvcD4NCjwvZGl2Pg0KPGRpdj4NCjxwIGNsYXNzPSJN c29Ob3JtYWwiPjxvOnA+Jm5ic3A7PC9vOnA+PC9wPg0KPC9kaXY+DQo8ZGl2Pg0KPHAgY2xhc3M9 Ik1zb05vcm1hbCI+VGhhbmtzICZhbXA7IFJlZ2FyZHMsPG86cD48L286cD48L3A+DQo8L2Rpdj4N CjxkaXY+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj5BZGl0eWEgRDxvOnA+PC9vOnA+PC9wPg0KPC9k aXY+DQo8L2Rpdj4NCjwvYmxvY2txdW90ZT4NCjwvZGl2Pg0KPC9kaXY+DQo8ZGl2Pg0KPHAgY2xh c3M9Ik1zb05vcm1hbCI+PG86cD4mbmJzcDs8L286cD48L3A+DQo8L2Rpdj4NCjxkaXY+DQo8ZGl2 Pg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+Q291bGQgdGhpcyB3b3JrIGZvciB5b3U/PG86cD48L286 cD48L3A+DQo8L2Rpdj4NCjxkaXY+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj48YSBocmVmPSJodHRw czovL3VybGRlZmVuc2UuY29tL3YzL19faHR0cHM6L3doeS11cGdyYWRlLmRlcGVzei5jb20vc2hv dz9mcm9tPTkuNSZhbXA7dG89MTNfXzshIUdGRThkUzZhY2xiMGgxbmtoUGY5ITUtaFl2dTlobTVZ MklRU1p4Rlk1WXBHclloTjk3T0ltQlFVVWxadjdUTm5yNFRodkVBWm00ZG5oSmFJN2dSLUpzLW9m cmJON3BZRW14ekFQNXBCdVhtSUpHbWhoJCI+aHR0cHM6Ly93aHktdXBncmFkZS5kZXBlc3ouY29t L3Nob3c/ZnJvbT05LjUmYW1wO3RvPTEzPC9hPjxvOnA+PC9vOnA+PC9wPg0KPC9kaXY+DQo8ZGl2 Pg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PG86cD4mbmJzcDs8L286cD48L3A+DQo8L2Rpdj4NCjxk aXY+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj5CZXN0LDxvOnA+PC9vOnA+PC9wPg0KPC9kaXY+DQo8 ZGl2Pg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+R2lvdmFubmkmbmJzcDs8bzpwPjwvbzpwPjwvcD4N CjwvZGl2Pg0KPC9kaXY+DQo8L2Rpdj4NCjwvZGl2Pg0KPC9ib2R5Pg0KPC9odG1sPg0K --_000_6421dc6999c343fbb3e7afd75e256e63expressscriptscom_--