Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nk8Gd-00021S-Cw for pgsql-admin@arkaria.postgresql.org; Thu, 28 Apr 2022 17:49:27 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nk8Gc-0005LX-8E for pgsql-admin@arkaria.postgresql.org; Thu, 28 Apr 2022 17:49:26 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nk8Gb-0005LM-NH for pgsql-admin@lists.postgresql.org; Thu, 28 Apr 2022 17:49:25 +0000 Received: from bcbsma.zixworks.com ([173.226.139.14] helo=z132.zixworks.com) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nk8GX-0003k8-MU for pgsql-admin@lists.postgresql.org; Thu, 28 Apr 2022 17:49:25 +0000 Received: from 127.0.0.1 (ZixVPM [127.0.0.1]) by Outbound.z132.zixworks.com (Proprietary) with SMTP id DB2A721186FD for ; Thu, 28 Apr 2022 12:49:15 -0500 (CDT) Received: from NAM02-DM3-obe.outbound.protection.outlook.com (mail-dm3nam07lp2049.outbound.protection.outlook.com [104.47.56.49]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by z132.zixworks.com (Proprietary) with ESMTPS id 8463C61D6492; Thu, 28 Apr 2022 12:49:14 -0500 (CDT) ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=CYAzoS7CIQD56rNe0r6xiIhFeIIr+t/pKnALbzE1AnKIChS58g03xVxh9E46yw46+royYFlRmv8TFSv1qwUTat1vhZ9N0yUXYj3gSwnvtcr4kSIZuo6UPtIW8/WXsDWOSIXINooODLt2pa/sCXdtrRBXCoqzNOhgARwOr+BS4mQ3RW+5RbBIkpkQ3ZszCBWUPHF2pEG/YjndQInM/vTWKRiriZSrs+ARPdkpaSvY1AQiqPc5R2Evy2444UKN3VHIhT3Irc+2ajOeZw+kqPDefyWH1LEeNqN3mcG+QUpm0al/cJ8XwDAKr2EeCkjTGFoDCG2hq0czV5rBTVBqSaHG3Q== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=CxbF+P8AWrJTDK+Zqv4DHSHVnhM8G5jRpt2JhWKJbco=; b=RX+aEuOVg5JGELA2gfCfzKezW1s0DsDdGPINw7tNuobEwHF97+84p5Q9+QLp/9xCK3ns2u7Q9Efegxv925KFMoNFApFZhcoCWSd4JIjQFRiT8uW+mvYQYr01jus4oxMPsZGPocdGJP5khK1+BQ8z3LTb9AGvCictWvuA4RBXHw/TwmRdmBfOUPuCDd4+3J8yo7dsgQokBsa0W9tCHYj8t0HMJVz4sHcx0Jx3+ZAR7T6EdIxGAH1H3H2s+uSxvfdW2RC6y3QPJ9v9yDTrZc/WZKkU1jedSnNTXJmUcTMJOyxSPDmKgutz6FCCMtEHcFOBqIXQmKyD9ZZS6Zsk4lVUPQ== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=bcbsma.com; dmarc=pass action=none header.from=bcbsma.com; dkim=pass header.d=bcbsma.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=bcbsma.onmicrosoft.com; s=selector2-bcbsma-onmicrosoft-com; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=CxbF+P8AWrJTDK+Zqv4DHSHVnhM8G5jRpt2JhWKJbco=; b=qjbkTrikPRR2UlOIv+Bhp0ZOZMCuK/yamzRQOf8IatUgabR7b/NYfi2gbN0pdl3E1vOxubInfzLj9W2I28WYKIhwAPfYQzmIK/J+9G/46GettKFBMZmppXx6Ntpb+8RBtFKvkxckki5U8fAp2sDYkybAtCfdVQ3KEr296y67M4E= Received: from BLAPR13MB4660.namprd13.prod.outlook.com (2603:10b6:208:321::8) by BN6PR13MB3059.namprd13.prod.outlook.com (2603:10b6:405:7e::26) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.5227.6; Thu, 28 Apr 2022 17:49:12 +0000 Received: from BLAPR13MB4660.namprd13.prod.outlook.com ([fe80::b944:d865:9673:e842]) by BLAPR13MB4660.namprd13.prod.outlook.com ([fe80::b944:d865:9673:e842%8]) with mapi id 15.20.5206.014; Thu, 28 Apr 2022 17:49:12 +0000 From: "Capobianco, Tony" To: Florents Tselai CC: Tom Lane , "pgsql-admin@lists.postgresql.org" Subject: RE: issues connecting to RDS from psql 9.2 v 14.2 Thread-Topic: issues connecting to RDS from psql 9.2 v 14.2 Thread-Index: AdhaUEIdPGwjGMmxRt2j4twTB2m6bgABjIOAAAUSH8AABGy0AAAq8T1g Date: Thu, 28 Apr 2022 17:49:11 +0000 Message-ID: References: <395140.1651078037@sss.pgh.pa.us> In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-dg-ref: =?us-ascii?Q?PG1ldGE+PGF0IG5tPSJib2R5Lmh0bWwiIHA9ImM6XHVzZXJzXHRjYXBvYjAx?= =?us-ascii?Q?XGFwcGRhdGFccm9hbWluZ1wwOWQ4NDliNi0zMmQzLTRhNDAtODVlZS02Yjg0?= =?us-ascii?Q?YmEyOWUzNWJcbXNnc1xtc2ctODE3N2M3ZmItYzcxYi0xMWVjLWI2ZDItMDhk?= =?us-ascii?Q?MjNlMjBmMzA5XGFtZS10ZXN0XDgxNzdjN2ZkLWM3MWItMTFlYy1iNmQyLTA4?= =?us-ascii?Q?ZDIzZTIwZjMwOWJvZHkuaHRtbCIgc3o9IjEwMzY5IiB0PSIxMzI5NTY0MTc1?= =?us-ascii?Q?MDE5NDkxNzYiIGg9Iksyc01LMHVZQWJGRzRKUG1lSjB3V29Ka1JGYz0iIGlk?= =?us-ascii?Q?PSIiIGJsPSIwIiBibz0iMSIgY2k9ImNBQUFBRVJIVTFSU1JVRk5DZ1VBQUp3?= =?us-ascii?Q?R0FBRDQ3TTlES0Z2WUFhMzVKZWRkMXB1c3Jma2w1MTNXbTZ3S0FBQUFBQUFB?= =?us-ascii?Q?QUFBQUFBQUFBQUFBQUFBQUFIQUFBQUFzQmdBQUFBQUFBQUFBQUFBQUFBQUFB?= =?us-ascii?Q?QUFBQUFFQUFRQUJBQUFBRmc1c2NRQUFBQUFBQUFBQUFBQUFBSjRBQUFCaEFH?= =?us-ascii?Q?UUFaQUJ5QUdVQWN3QnpBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFB?= =?us-ascii?Q?QUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFB?= =?us-ascii?Q?QUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFB?= =?us-ascii?Q?QUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBSUFBQUFBQUFBQUFB?= =?us-ascii?Q?QUFBQUVBQUFBQUFBQUFBZ0FBQUFBQW5nQUFBR01BWXdCZkFHTUFkUUJ6QUhR?= =?us-ascii?Q?QWJ3QnRBRjhBWVFCdUFIa0FBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFB?= =?us-ascii?Q?QUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFB?= =?us-ascii?Q?QUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFB?= =?us-ascii?Q?QUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFRQUFBQUFBQUFB?= =?us-ascii?Q?Q0FBQUFBQUNlQUFBQVl3QjFBSE1BZEFCdkFHMEFYd0J3QUdVQWNnQnpBRzhB?= =?us-ascii?Q?YmdBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFB?= =?us-ascii?Q?QUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFB?= =?us-ascii?Q?QUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFB?= =?us-ascii?Q?QUFBQUZBQUFBQUFBQUFBQUFBQUFCQUFBQUFBQUFBQUlBQUFBQUFKNEFBQUJq?= =?us-ascii?Q?QUhVQWN3QjBBRzhBYlFCZkFIQUFhQUJwQUdzQVpRQjVBSGNBYndCeUFHUUFj?= =?us-ascii?Q?d0FBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFB?= =?us-ascii?Q?QUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFB?= =?us-ascii?Q?QUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFB?= =?us-ascii?Q?QUFBQUFBRUFBQUFBQUFBQUFnQUFBQUFBbmdBQUFHTUFkUUJ6QUhRQWJ3QnRB?= =?us-ascii?Q?RjhBY0FCb0FHOEFiZ0JsQUc0QWRRQnRBR0lBWlFCeUFBQUFBQUFBQUFBQUFB?= =?us-ascii?Q?QUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFB?= =?us-ascii?Q?QUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFB?= =?us-ascii?Q?QUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQVFBQUFBQUFB?= =?us-ascii?Q?QUFDQUFBQUFBQ2VBQUFBWXdCMUFITUFkQUJ2QUcwQVh3QnpBSE1BYmdBQUFB?= =?us-ascii?Q?QUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFB?= =?us-ascii?Q?QUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFB?= =?us-ascii?Q?QUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFB?= =?us-ascii?Q?QUFBQUFBQUFBQUFBQUFBQUFBQUFBQUJBQUFBQUFBQUFBSUFBQUFBQUo0QUFB?= =?us-ascii?Q?QmtBSGdBWHdCakFHOEFaQUJsQUhNQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFB?= =?us-ascii?Q?QUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFB?= =?us-ascii?Q?QUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFB?= =?us-ascii?Q?QUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFB?= =?us-ascii?Q?QUFBQUFBQUFFQUFBQUFBQUFBQWdBQUFBQUFuZ0FBQUdVQWJRQmhBR2tBYkFC?= =?us-ascii?Q?ZkFHRUFaQUJrQUhJQVpRQnpBSE1BQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFB?= =?us-ascii?Q?QUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFB?= =?us-ascii?Q?QUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFB?= =?us-ascii?Q?QUFBQUFBQUFBQUFBQUFBQUFBQUFBQUNRQUFBQUFBQUFBQUFBQUFBUUFBQUFB?= =?us-ascii?Q?QUFBQUNBQUFBQUFDZUFBQUFhQUJqQUhBQVl3QnpBRjhBWXdCdkFHUUFaUUJ6?= =?us-ascii?Q?QUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFB?= =?us-ascii?Q?QUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFB?= =?us-ascii?Q?QUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFB?= =?us-ascii?Q?QUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQkFBQUFBQUFBQUFJQUFBQUFBSjRB?= =?us-ascii?Q?QUFCd0FIZ0FYd0JqQUc4QVpBQmxBSE1BQUFBQUFBQUFBQUFBQUFBQUFBQUFB?= =?us-ascii?Q?QUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFB?= =?us-ascii?Q?QUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFB?= =?us-ascii?Q?QUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFB?= =?us-ascii?Q?QUFBQUFBQUFBQUVBQUFBQUFBQUFBZ0FBQUFBQSIvPjwvbWV0YT4=3D?= x-dg-rorf: true authentication-results: dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=bcbsma.com; x-ms-publictraffictype: Email x-ms-office365-filtering-correlation-id: 56f8bbbd-3e2d-4eb1-5729-08da293f6729 x-ms-traffictypediagnostic: BN6PR13MB3059:EE_ x-microsoft-antispam-prvs: x-bcbsmarule-messageencryptionremoval: Rule Triggered x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: mHTw/Skk1plB2Z1iTf/b/K5XADlqV2lU10mxzBnvaYMDNSKC7B9cHnxXHdmSo9NEKrlDKkmf+MrAIlSeBmq5/SgSoCcGJlstDQWR8HRvJYp+xQyFXm5XeWt7nnJfpiHWezWIX/GaZ14JSpmhza+nxlckoiguJg5Vc37QeoOLyDgPJfNUCuyQ6daKYvPT7j2GhSpL7+uMVgWSX30dDfw/INeGkZUmBqftouDkD2ArihrY0vFfWBAqLe89bTVLIB0cnNxLA2g/bIt8bJI+tWNnHxkm2KLfy6flFcBKCo14/waz6khvxaZzkJOmwCKaJ4S56L45Ee4u/zqbJq3OaSsEY9pRGD4thwUCq/jKH67LHE9kvG+N00Nndm+qXFo5pVSy96Bb671DpYYzf23/bHsi4mwJdQeUQnqRGF78iz59pUgZK9sMMmsnrncylaTDHYg/pVheikhh0xuZm0HNfH3jozp7iNYlKnDMWnGdGGCrb5TE34LqfAlTKrYecxfg1FlPX3vd7dDi/6fJqvpqPAMukR8dKD/dj4Dbn/MpVZnAkbdiUYQXapNeVuE7lU+129NEFpQGg5nxatRqEI48yBfDN9TTMP4k4KHnp4v72f7rd8G7VtMeLssxnicwmMrEURahCE6/kLxVbyWLPcTn6YMi30g15+et1R9Fcy4VN/WCUICOUsFzSDpfTD3y8P8cICQ9RkxSxGrPN4fXRlm3U/OqDw== x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:BLAPR13MB4660.namprd13.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230001)(4636009)(366004)(38070700005)(166002)(54906003)(122000001)(55016003)(6916009)(38100700002)(316002)(83380400001)(52536014)(186003)(8936002)(8676002)(66946007)(26005)(33656002)(7696005)(9686003)(508600001)(5660300002)(2906002)(4326008)(86362001)(76116006)(6506007)(66556008)(66476007)(66446008)(64756008)(53546011)(71200400001);DIR:OUT;SFP:1102; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?us-ascii?Q?nXlpWw70yROWKqnSBpDsMw52qEETm6kJhiK2ksWMbC905N7gwRwRwt8GWCxs?= =?us-ascii?Q?xJl3IB6RbLDhll4iycduBgIeQbU6MM8E3XSXcF+IEYlGoXFaP3LsPNKT1lpM?= =?us-ascii?Q?qzoFZwsmxOqfl7B+03miO3HNUJ05hcXxdlsohfLfZvWMH6jFGu0ib8jb3BTm?= =?us-ascii?Q?pbRjzTfL0zXXFERUXzWmKp/mOA0VZk4lymGbONATTRRO7CqsLmDuLlhm3GpN?= =?us-ascii?Q?NAqMeyF5waYwvz26iC6WNRltzU8KLkft3bJ26OKCgsLG2AH/AV2TuLPy9u4i?= =?us-ascii?Q?ioAK63iaW902DMvBy+lEPxKvoQw7I8LJ8s+k/ka7DVL03PmnYcASsK9VUBM5?= =?us-ascii?Q?FYeU3gVuOFJb8OLbPSKbJKgBCEisAmUp24y+5tanfNHRTxvxUNR3sYnMbHjk?= =?us-ascii?Q?1z2zEm1LQlKVfXvXf5K4B0QETrGBS9sa9DS8WkkeWnXh11h3KCX/cQt6hFy6?= =?us-ascii?Q?jklUJLLP1u3yiXQ0K6OMfKXRJqi0uQyXv2frVgmdljofKynaPHeNeNPuP5Yo?= =?us-ascii?Q?Qa+x/b4XS72NSzS98l3rdWcO+Vf9UIjQj4Fwf2DnrmogoBDF6zeySHUHjiQy?= =?us-ascii?Q?s+SJWDD1j0NY7A2keJ0ZUiCFrd7sXxnpNQAlQmZKlSOZ9Uq+4wJ8QJ82a3Yd?= =?us-ascii?Q?LIMAbOEI4IjOQI2wH/5YE1vZf9791DPoMQHbSkWIBDgKgjamaZTpZiv+Peuj?= =?us-ascii?Q?TAfx2B9Z8g+/Wv/yzKYp9XDHhvAlF0L0CFewhWNhK5C3ZGNPF9eD+7Iin+bp?= =?us-ascii?Q?QWNvJ1/Kdt2bni9VpR8+XMGje70rial4nvkAVF45NTqyKtogsJUNz2UkyBg/?= =?us-ascii?Q?1a376M5mKLTQYgrzuKz5OSJcv5kZoWXdiIsPl7xrjY2rfNGeXYDXWayvNq2l?= =?us-ascii?Q?48GJy0CCugN1bIElkgyjEDHEsCQSLMx+3nQYomvbi44MJ2uY5zslvwrBnVeb?= =?us-ascii?Q?+btMjT5z8EeenETKpgg4TYK/o3JrXvl1dpU9mJFdsoiNFwd1nVe0X79//xzN?= =?us-ascii?Q?XJPUGIiK2ClAU6u/cVq0XjTFIKA5e9wZWcVVfJAsSI1Kc2jY1x8meyp+MgZ6?= =?us-ascii?Q?44ewz7io+0JAeM0zHbsRiHycJrnv3bgKGJmuOJOIfTPoPwSnu5poN+HkwdPs?= =?us-ascii?Q?wLFwymOZgK7A41KsSDQq+IzGmHyRdInsoSBtWWiYIVGjhRJRimUbEvGkdemJ?= =?us-ascii?Q?znKQWdn5H+ezy0cNp0XTRsTaboWr8mAXot0erIfDY33ce/sELGvF5PMU+ItN?= =?us-ascii?Q?i1VkdvvPQqVSoMazG3ohjYVsPUo4+P9HHzbaPV3HhFiYnBthvethe9YcKV6e?= =?us-ascii?Q?E4XDgHSNmK2HpvyIPbvBTyT0VIY8xzbUZwHqB+sSb3V2esvsZZ3t9Jekbb3B?= =?us-ascii?Q?he7Ke13ueaPjb9sAWJqf1RuWTc3E5/gFLo8VfA1BYk1YK5zmeI5KVLJDNPSr?= =?us-ascii?Q?TIIZXlr7diMaRwSMT5JUgc5rxfdn+smuWqTzJOhs1LXQNSAdWrcduy4WObQT?= =?us-ascii?Q?VobwLcGuu7ok3b+mHSTvLZZnslz8LQgjROtoFv3UvvLdo5y4GE9DwmxCokIv?= =?us-ascii?Q?8Hnj5NaY4oHd/QcY3bt2Hrl4rPXtoq89oDMd+50ONjCDfzLywGMjyEHqGaz2?= =?us-ascii?Q?gdBsyr+YaVeEYpqBICjstnR8NQDLmbOuqz6Rj7lZJYdx6+swPrUeMrQ4N/1H?= =?us-ascii?Q?+eo9VFOkDqoeVsqENUo4kw0iXAXafbDNX0DRXOR+5kKbz4GJcpBqTm3nkyNH?= =?us-ascii?Q?BPeirksiCA=3D=3D?= Content-Type: multipart/alternative; boundary="_000_BLAPR13MB46603FB1F11ED81FE66897619EFD9BLAPR13MB4660namp_" MIME-Version: 1.0 X-OriginatorOrg: BCBSma.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: BLAPR13MB4660.namprd13.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: 56f8bbbd-3e2d-4eb1-5729-08da293f6729 X-MS-Exchange-CrossTenant-originalarrivaltime: 28 Apr 2022 17:49:11.6006 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 7f6a7d1e-1213-434b-981c-95c72d65f665 X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: sIIm32rdS7CK9m0U//5Fbmq8FJCkg33ul7Ncbh2A6SpXidFzwuvI3gbHNf4ymhEjWxkZHxqjv3vR1dSdvAs8CA== X-MS-Exchange-Transport-CrossTenantHeadersStamped: BN6PR13MB3059 X-VPM-HOST: vmvpm03.z132.zixworks.com X-VPM-GROUP-ID: f5f8dea3-a142-4c15-9522-40bb04b80fba X-VPM-MSG-ID: cbe25888-8320-43eb-929b-12e41ced57e0 X-VPM-ENC-REGIME: Plaintext X-VPM-IS-HYBRID: 0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_BLAPR13MB46603FB1F11ED81FE66897619EFD9BLAPR13MB4660namp_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Bingo! That was it. Thanks so much! Tony From: Florents Tselai Sent: Wednesday, April 27, 2022 5:19 PM To: Capobianco, Tony Cc: Tom Lane ; pgsql-admin@lists.postgresql.org Subject: Re: issues connecting to RDS from psql 9.2 v 14.2 CAUTION: This email originated from outside of the organization. Do not cli= ck links or open attachments unless you recognize the sender and know the c= ontent is safe. On 27 Apr 2022, at 10:16 PM, Capobianco, Tony > wrote: Ok, that makes sense. Attempting the below, but receiving this error: ./configure --without-readline --with-includes=3D/usr/lib --with-openssl checking for CRYPTO_new_ex_data in -lcrypto... no configure: error: library 'crypto' is required for OpenSSL You don't have crypto installed on your machine. Try something like Redhat / Centos / Fedora : sudo yum install openssl-devel Ubuntu / Debian : sudo apt-get install libssl-dev [postgres@servername postgresql-14.2]$ ls -lhrt /usr/lib/*crypt* -rwxr-xr-x 1 root root 547K Feb 28 2017 /usr/lib/libgcrypt.so.11.8.2 lrwxrwxrwx 1 root root 19 Aug 29 2017 /usr/lib/libgcrypt.so.11 -> libgcrypt= .so.11.8.2 -rwxr-xr-x 1 root root 38K Sep 14 2021 /usr/lib/libcrypt-2.17.so lrwxrwxrwx 1 root root 16 Nov 12 07:01 /usr/lib/libcrypt.so.1 -> libcrypt-2= .17.so lrwxrwxrwx 1 root root 23 Nov 12 07:01 /usr/lib/libcrypt.so -> ../../lib/li= bcrypt.so.1 Tony -----Original Message----- From: Tom Lane > Sent: Wednesday, April 27, 2022 12:47 PM To: Capobianco, Tony > Cc: pgsql-admin@lists.postgresql.org Subject: Re: issues connecting to RDS from psql 9.2 v 14.2 CAUTION: This email originated from outside of the organization. Do not cli= ck links or open attachments unless you recognize the sender and know the c= ontent is safe. "Capobianco, Tony" > writes: Our RHEL 7.9 installation comes with PostgreSQL 9.2 installed which I know = has been desupported. We installed 14.2 in a non-default location and obser= ve this unusual behavior: [postgres@servername ~]$ psql -h RDS-instance.rds.amazonaws.com -p 5432 -d dbname -U root Password for user root: psql (9.2.24, server 12.8) WARNING: psql version 9.2, server version 12.0. Some psql features might not work. SSL connection (cipher: cipher text here, bits: 256) Type "help" for help. daldb=3D> \q [postgres@ servername ~]$ export LD_LIBRARY_PATH=3D/u01/apps/postgres/postgresql-14.2/pg14.2/usr/local/pg sql/lib [postgres@ servername ~]$ /u01/apps/postgres/postgresql-14.2/pg14.2/usr/local/pgsql/bin/psql -h RDS-instance.rds.amazonaws.com -p 5432 -d dbname -U root psql: error: connection to server at " RDS-instance.rds.amazonaws.com " (1.2.3.4), port 5432 failed: FATAL: no pg_hba.conf entry for host "1.2.3.4", user "root", database "dbname", SSL off [postgres@ servername ~]$ Any ideas of why I'm encountering this issue? Looks like you neglected to build psql with OpenSSL support, and the server= is insisting on having an SSL connection. regards, tom lane --_000_BLAPR13MB46603FB1F11ED81FE66897619EFD9BLAPR13MB4660namp_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Bingo!  That was it.  Thanks so much!=

 

Tony

 

From: Florents Tselai <florents.tselai@gma= il.com>
Sent: Wednesday, April 27, 2022 5:19 PM
To: Capobianco, Tony <Tony.Capobianco@bcbsma.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>; pgsql-admin@lists.postgresql= .org
Subject: Re: issues connecting to RDS from psql 9.2 v 14.2

 

<= span style=3D"font-size:10.0pt;color:#9C6500">CAUTION: This email originated from outside of t= he organization. Do not click links or open attachments unless you recognize the sender and know the content is safe.<= o:p>

 

 



On 27 Apr 2022, at 10:16 PM, Capobianco, Tony <Tony.Capobianco@bcbsma.com&= gt; wrote:

 

Ok, that makes sense. Attempting the below, but r= eceiving this error:

./configure --without-readline --with-includes=3D/usr/lib --with-openssl
checking for CRYPTO_new_ex_data in -lcrypto... no
configure: error: library 'crypto' is required for OpenSSL

 

You don’t have crypto installed on your machin= e.

 

Try something like 

 

Redhat / Centos / Fedora : sudo yum install openssl-= devel 

Ubuntu / Debian : sudo apt-get install libssl-dev

 


[postgres@servername postgresql-14.2]$ ls -lhrt /usr/lib/*crypt*
-rwxr-xr-x 1 root root 547K Feb 28 2017 /usr/lib/libgcrypt.so.11.8.2
lrwxrwxrwx 1 root root 19 Aug 29 2017 /usr/lib/libgcrypt.so.11 -> libgcr= ypt.so.11.8.2
-rwxr-xr-x 1 root root 38K Sep 14 2021 /usr/lib/libcrypt-2.17.so
lrwxrwxrwx 1 root root 16 Nov 12 07:01 /usr/lib/libcrypt.so.1 -> libcryp= t-2.17.so
lrwxrwxrwx 1 root root 23 Nov 12 07:01 /usr/lib/libcrypt.so -> ../../lib= /libcrypt.so.1

Tony 

-----Original Message-----
From: Tom Lane <tgl@sss.= pgh.pa.us> 
Sent: Wednesday, April 27, 2022 12:47 PM
To: Capobianco, Tony <Tony.Capobianco@bcbsma.com>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: issues connecting to RDS from psql 9.2 v 14.2

CAUTION: This email originated from outside of the organization. Do not cli= ck links or open attachments unless you recognize the sender and know the c= ontent is safe.


"Capobianco, Tony" <Tony.Capobianco@bcbsma.com> writes:

Our RHEL 7.9 installation comes with PostgreSQL 9= .2 installed which I know has been desupported. We installed 14.2 in a non-= default location and observe this unusual behavior:
[postgres@servername ~]$ psql -h RDS-instance.rds.amazonaws.com -p=  
5432 -d dbname -U root Password for user root:
psql (9.2.24, server 12.8)
WARNING: psql version 9.2, server version 12.0.
Some psql features might not work.
SSL connection (cipher: cipher text here, bits: 256) Type "help" = for 
help.



daldb=3D> \q
[postgres@ servername ~]$ export = ;
LD_LIBRARY_PATH=3D/u01/apps/postgres/postgresql-14.2/pg14.2/usr/local/pg sql/lib [postgres@ servername ~]$&nbs= p;
/u01/apps/postgres/postgresql-14.2/pg14.2/usr/local/pgsql/bin/psql -h 
R= DS-instance.rds.amazonaws.com -p 5432 -d dbname -U root
psql: error: connection to server at " RDS-instance.rds.amazonaws.com&nb= sp;
" (1.2.3.4), port 5432 failed: FATAL: no pg_hba.conf entry for 
host "1.2.3.4", user "root", database "dbname"= ;, SSL off [postgres@  servername ~]$



Any ideas of why I'm encountering this issue?


Looks like you neglected to build psql with OpenSSL support, and the server= is insisting on having an SSL connection.

regards, tom lane

 

--_000_BLAPR13MB46603FB1F11ED81FE66897619EFD9BLAPR13MB4660namp_--