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 1u2F8F-00FB92-U8 for pgsql-general@arkaria.postgresql.org; Tue, 08 Apr 2025 20:01:16 +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 1u2F8E-00Elky-9U for pgsql-general@arkaria.postgresql.org; Tue, 08 Apr 2025 20:01:14 +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 1u2F8D-00EliQ-Qn for pgsql-general@lists.postgresql.org; Tue, 08 Apr 2025 20:01:14 +0000 Received: from mail-co1nam11on2080.outbound.protection.outlook.com ([40.107.220.80] helo=NAM11-CO1-obe.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1u2F86-004CDL-1k for pgsql-general@lists.postgresql.org; Tue, 08 Apr 2025 20:01:10 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=fXEG1FKIB/RxEI+CsABNfzXPgDd2GHDSw35eDr/Exk0ftq0VYeyyFsIoIvXZB92piLoQMDgKk25IJnfVqX2fobwAHOkZCDhlKzNPgSkpNzsJBFgn9DeXRFfnIIT65uVAs/ajOrpGkQ62aRG/aZFSPGu8BF2urPGnY5LcrXtgbSdvL8qn96PHxoXwsrzUvbnbIyQ7Q2K01E6+8rcdqOfYfSwhC/qRel3MQ4g1OClwEaXl7VRcZYKXKPuttHxVUo6xBWQQyYjIMsLD0kj6fG0g3Ur0r9nzFTtKkxHovWwdZ1V61lynsZa32HO2ZEj8Znga4vD8h4/BBkxcIgngBiyUNw== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector10001; 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=q29hesBJkHOTFMab1GF8wHPWQ/DWv7OyeYPj7LglEd4=; b=jx51fxNvIXbRB+lIpdiH9eBYQ8SBk7f/gRPMnr6yqfpP02v3ceTW/eiXkuZfVpdei/SZV6PGMEchEqfG4pdU1BVJjpb8f+5IjK6qMt4Wd6nEBU/jZvMVWe5ZquTftv+0TH/s31m7/SvKwN4OPTJ2K/zvs79McB+hBUQoAoUwz9G3L7BebHPQbGRCWFJR/A25Qe2MzsfIoBkUJpij9Jw2XKWShhOzBa7tqQh4vw1y1jMEnzNGiebZmVvtx5YqOPRxso0Cle0G46xTN/MANdl0GYqJeye8YgaJhM69HhXn8ejjKPPJIfqHsJO8D4c4BXzVx7LZNAeY1VAmIEQRmtDnBg== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=thomsonreuters.com; dmarc=pass action=none header.from=thomsonreuters.com; dkim=pass header.d=thomsonreuters.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=thomsonreuters.com; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=q29hesBJkHOTFMab1GF8wHPWQ/DWv7OyeYPj7LglEd4=; b=PqZ/WyPpUA+IusBtdEtjB2TzDcjkg0OdSb/609jLISLR88f/vApmt1MVUxKGdqFmwTSh9PxzeNr6uNeRC4BLZ6AQRLqkMUg1xAGMU/AcQ/JRU9DoWkqbXbw5YrcVxmqcbrIAM2TsCbTzYs2BIIttPrC0xZlnObyseT44Mn71/Tk= Received: from CH0PR03MB6034.namprd03.prod.outlook.com (2603:10b6:610:bd::18) by PH0PR03MB5719.namprd03.prod.outlook.com (2603:10b6:510:36::15) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.8606.34; Tue, 8 Apr 2025 20:00:59 +0000 Received: from CH0PR03MB6034.namprd03.prod.outlook.com ([fe80::ea99:4edc:5053:2291]) by CH0PR03MB6034.namprd03.prod.outlook.com ([fe80::ea99:4edc:5053:2291%6]) with mapi id 15.20.8606.027; Tue, 8 Apr 2025 20:00:58 +0000 From: "Dirschel, Steve" To: "pgsql-general@lists.postgresql.org" Subject: Postgres_fdw- User Mapping with md5-hashed password Thread-Topic: Postgres_fdw- User Mapping with md5-hashed password Thread-Index: AQHbqMDy24vlLiGg40umY/S8n+UGMg== Date: Tue, 8 Apr 2025 20:00:58 +0000 Message-ID: References: <2992983d-b237-4cc0-91d7-e3bc8de25006@joeconway.com> In-Reply-To: <2992983d-b237-4cc0-91d7-e3bc8de25006@joeconway.com> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: authentication-results: dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=thomsonreuters.com; x-ms-publictraffictype: Email x-ms-traffictypediagnostic: CH0PR03MB6034:EE_|PH0PR03MB5719:EE_ x-ms-office365-filtering-correlation-id: 4de6b291-9355-4b55-8faa-08dd76d814b7 x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0;ARA:13230040|366016|376014|1800799024|38070700018; x-microsoft-antispam-message-info: =?utf-8?B?TU5EZ3pKUE5pWVEwQUFtTndnNVdhWTQrR280MklsRWVhZHkwY0crNXd2aXRP?= =?utf-8?B?MzNYcnlvV0NxSkRtSk9VNFE1cXlPei91cDR3clB4T2thLzJQaTV3b1FKclpo?= =?utf-8?B?VVRia2V5WDRocW54Z09hdU1odWV3YTluc1J2UkU1RUxWRHZJS0dWeHpSSzYw?= =?utf-8?B?N0wyV2VDbWhObUt6cXlEVDN1YStJcVBZZ3d3TFpTMTRDMnRtSGtILzNtcC9G?= =?utf-8?B?ekdDUTE4WWFidjg3QmlWZk9hWWRsanhZSmRGWWdPK25hU2tvSHdQYUVrVEV5?= =?utf-8?B?VlZBTDlSMDV3cnZ6eHlsK05NQ1ZZT2hvY2lEMWg4RmxTK2pXRUprZk84YkRn?= =?utf-8?B?aDZrZ1o3bk1QNmFkVXp5OUdCWCtKYkU2anpqdFRhNU1tU3pnL3RIdzI2dFB6?= =?utf-8?B?MjM5S1FYdHdRbnhpamJtUDQwNmsxcjBML3QycHdQdWtxYmM0eCtlQ1VCQ1Zu?= =?utf-8?B?Y0JCOCtTK2htSkJtUUtPMkRFMGpzQXRqQi8zOEhHeEYwZE90YjJDMm9lNXZM?= =?utf-8?B?R2RDYlZ5MWVIVTRySFlUdzhlS2h0L2o2WDN2bWphUlBjVm56S2dDQytMNHhw?= =?utf-8?B?NEo1c3gvUHVxZXdyZUV0cXUvYzVKUlhTeVRWbzN0YmcvVUU0QTNmTFVzL1lo?= =?utf-8?B?UFVTSHBxdlplUTY5NnFhek5vd0wyL3hpRk0yd3J5dU5FQncwNTVnMHVUaEEy?= =?utf-8?B?bXpQc0xwWEhIdDRlUjlITmVqSGErcjdoOEdHMVhiSGd1WUM4T21kYXhQc3cr?= =?utf-8?B?UTVkZnJoSWJvNk4xa3BRVmNTUnhmb1F6eDZ4TVpGbjF4TVZRZElrNzhJWTV3?= =?utf-8?B?Njk0OEdqT2VUckV5WnBaZFl4L21NY3kxb2hRSkhkZUJYanpEOC9XUnA0eVhE?= =?utf-8?B?VEJQQU92dUxjM2IvSWtSZzZtQW0vMzN5NTRtbktCNHhUTENKL2RJTGlGRE15?= =?utf-8?B?RWgyM1IrcVZVajlKRE9objdyOGZ4K2xURnJmTnhpMVkwMVpjUEpVYkRQN3Ri?= =?utf-8?B?TzlBaVhhRURQTzVFeHJneXQweCtzU3JmUnhBREtOMWVkNFMzSFdqa3paTGsz?= =?utf-8?B?K3M3cUdZSnk5RkJSKzN5UGNJRTV5Q0ZOelpXRndBQ0dFbEcwUEZ6bkxiSFNm?= =?utf-8?B?LzFWMDREeXpUN3UwaFcyRmthWTBjMkxxM2J1bGZHQ0gzZUE4NnBweWw1dGEy?= =?utf-8?B?NFhHUldmZTNRdDc4UjNxWDBtOEo5UWg4bDhpOHJRTHZlTEkzMElqbmZ0VGNZ?= =?utf-8?B?RURqUkIySDg3ZnYzeGZOenEyOW9EZzB5SXZ2WUlwNDdoNWVqY2RlQkY0Wlhz?= =?utf-8?B?WTA5aGpJaXRmclVTbXBKbjlmYjQ0Y0RIQklyNzNRNit6V28rZ2pHazRiSitR?= =?utf-8?B?eWtqZmI4a3RjUXRFajlndXVZdlRXVm1RcUhwa1I4Sng2aG11WHRJazY0am1w?= =?utf-8?B?SEhvL0RCTkJjT3Mvc2tTVnVUV28wcFRpemovbzVmeGN0aGZkTC9WYVNjcUFE?= =?utf-8?B?UkhWTW53aTJ4TXZNcDJOdG1ZcDh3YWNQK3o2NXNZbjVHSVdNVGtYc1R2bnhw?= =?utf-8?B?N3FnR3l5UG0yQzU3dWg1ZGF6akRqWllId2NLaENHcTF1YlNyenJLRkV4QUJk?= =?utf-8?B?WFBVdzBZcTVkSjcvT21VdzB2cVZueWRUVVkzWUVJWkp6Q0psZ2h3WkZ2YVQ5?= =?utf-8?B?ZCtsUGJrb2N2dkk2dTZSQ1p0QnZ2SHkxSUd0Qkd5cU92VjU5MGc2UXdJNGx2?= =?utf-8?B?d0R0WnA0V2tmK0hSK3k0aDhPdnZEbi9BUHl3dks0MWpLYlFHSGkvdGdUUGdY?= =?utf-8?B?dlFaMVRwSGU4Q1hwRXpyUWduS1ZEbm16UUFobUcxaVN1Rmt5SjRXcUJKblFh?= =?utf-8?B?M2VmU1B6L1R0eldBaGlyNXExb3oxWFpBRUp4Y2RpUHp2Y2xvZXpvQmFYeDBh?= =?utf-8?B?NDNtMHlpNmpvQjdMR1NXMDloODFGc25wL3pyb3hIeStaZVhma3M4eUdGVW1O?= =?utf-8?B?OHVZN3lXRSt3PT0=?= x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:CH0PR03MB6034.namprd03.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230040)(366016)(376014)(1800799024)(38070700018);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?utf-8?B?bDZWbU9PNmluZWZWS0k2NnlraFFUWjRFbk5qMy8zSTlpNmZhdkpleHUrVy9z?= =?utf-8?B?elVtQ3pzSGZ0RTZIR2FodmFoUE1CeWJ3OFBwU0pOZzFZVWxDTmFpV3QrWkMy?= =?utf-8?B?T3dweGFmcE1HT0pKS2p4QlNqMnRSOWhwNzM4Q2NRNTFEV0pHei9hZW91cUJ2?= =?utf-8?B?cHRqS0VOdVZZR0Z6Yng2VVRzZlF3bTRIV1NvQzF1OGRWcHFJbFV0WVNodnlH?= =?utf-8?B?YVRCdXU0S3VzbGQ0MjUxdHl0QkZOTExvdlR0Rm5haUxhL1pEdHdydWdTaGZX?= =?utf-8?B?V21uVXFWbWorV0x0SXFTVUFZL3hWRWRVQk9COUJ6OURWS0h3dFc2RHVCdEI3?= =?utf-8?B?Y0k1TUt4R1FSdVpIeThuNUw2UmNKUVFKeHQva3ZaeWNpbzMvWXBPL1pLMldj?= =?utf-8?B?S1NMbzFtZkhLTXp1TEU1Z2xzQzZsazJPTnhXbXdtcng3bXF2c0VsSGI3K0Vh?= =?utf-8?B?SlZ2emVyVG1CS3IyWFRlWjJPdWJobEVrcnFOU01vUzhxc3JNNy94d3U3U3pu?= =?utf-8?B?RnNPak5BMGd5SUlJSll4cmVlK1E0bmlsb3NaSzhqYWxLOVFVT3lFQlEzUTJD?= =?utf-8?B?WFcyWVdpV1JEYlpDQ3c2VEV1Y2NkWUhtaUJENGUxeGpIWGtoVExjYnlqRURP?= =?utf-8?B?QTNWeUFYdW9BWnAwUWh3RGRKeCt5dHRPYW5yaE0yUytYWUlqcG1zLzljVnlB?= =?utf-8?B?UE0wYWxyV0RYbm04K1k4YzJObXdpOTlGbUJPMUZMZk9ScDJYaFV5cW9seTNz?= =?utf-8?B?Y255emNOM1BvU1Qra052RE9YMjdaNjM3OW1RSmVBcVlXdldYRGExNDRZNDNs?= =?utf-8?B?Qkt4ZHVoRHBnYld5ODg4dGFTeTRHaHY3Z3JaT0k4aS92VEd0U3FtazdhSTUx?= =?utf-8?B?S1RGOWVCU2N0WXRxNFhZOUhsa2hDT05pb2oxbHF1eThZNFdYektKRk9ldkx3?= =?utf-8?B?NThpc0w4eDRKeTJtc1Y3VmN4Z3BFM2s2Uk4xU3RaeUprbGJ6aGFLcFpyVEkz?= =?utf-8?B?VTJ1Ty9POVNINU00VDZncFAwbGU2UUJxWlNBbFdHSWpMVEE4WGlHVHlhVDlB?= =?utf-8?B?ZjlUYnJoZjNGcFo2VUplWHh0R3BGZktBaVQwdVIvUGVSUGx3dFo4TmFIOHVL?= =?utf-8?B?RjVDM1hKYTNzQUlTcEVyYmhveTNVR0dpcy9keis2M1c1OFlxeS80enZLYmlW?= =?utf-8?B?SFpZWVhpd3lRNEJQbjhFOWRybjJmTE9ZbnZsYWIzNy9iYnlDZldlSExSVTgz?= =?utf-8?B?ZXFHU0JvczJvQTFOazZMWVdLaWNZS0VWYmVMK25raGxyTktnQnRWT2dEeHlC?= =?utf-8?B?dGFaWFZTVy92VGxZaU80amNnOHc5L2pQSGhJMlFPYnpTa1p1R3h4NkZ2a2s5?= =?utf-8?B?K1JNbXdMWk01YzdGV0xtbW1QRHNZSjUvemZqTHpRNUNDT3ppL2VlcEZ0VnJm?= =?utf-8?B?MnJmbHJMWWx3QXNJVyszSG9pQllwM3NleWtLNnh6NEw2b0dYYmpPMUp1TDg3?= =?utf-8?B?WlRna1ZMaHN5em9WZmF1NFZwb3NmNFJQS3ZNcEo3elFRYThLZks2UVhXUmVM?= =?utf-8?B?cFpZMlhva1VzNWhYVllMcXc2VDdoc3Jpam1FV2g1U3FGVW5iRXBjbmpnU1Iz?= =?utf-8?B?SkNLLzlIcjIyTEQ2UGFkT2FqWU5wWTVILzg1OXdKQkxGWFo0TUJ3RWd5Nm1q?= =?utf-8?B?N1JLMm0zSHdTZHlEazRoeGdzZnJ3WnhCVE5sdlp1VkJ0MUhsQ0JzbUdzQ1J1?= =?utf-8?B?S0RmMlhXQi9pRVg1c1N2MGFOWmtBQnU1Z3hteWFCNjVWemtVV2NVNHpxaGVa?= =?utf-8?B?ejFRbDdMNUZNaytmR3VtczlIMmMyV2I2akQ4V0hrMEZZQWM3Tm0rVlhGM2Iv?= =?utf-8?B?MlI2NjlZd0pIZTdRWmJnMk02bDBvaSsvd25MeHRXNUhyQ242YUxQTVgrR0FX?= =?utf-8?B?V3I5MEEvTkFuRzBtZTZJVk1vbDY2ZVlEeWNrVG1iVm5NeXczVm5VZ2lWMTBp?= =?utf-8?B?dzIxVlA3Q1krSEN2L01JNnZDbHE1Ny8va0N2aUh3TTFHMDg3OE53NVBtUjhG?= =?utf-8?B?NXdlbXliWE5md1RmanR2cTJ3dS9CNXVMWmt5NHJ2RGRwZkZJVGIvbkZFaHRs?= =?utf-8?B?SW9IYWh0WHN6UjgrTDhOYmcyMGVrK2RHSEt0enREQnUySUoycXZielk0aFMv?= =?utf-8?B?c2c9PQ==?= Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-OriginatorOrg: thomsonreuters.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: CH0PR03MB6034.namprd03.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: 4de6b291-9355-4b55-8faa-08dd76d814b7 X-MS-Exchange-CrossTenant-originalarrivaltime: 08 Apr 2025 20:00:58.8656 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 62ccb864-6a1a-4b5d-8e1c-397dec1a8258 X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: Qmo3stI2wIfv4JUFPOaueF5L/n0Mhe60yO9Q4sI5n/ojJEnhsg00TYJbXfw9TYTMccUmfFicykVdSgu8dpvBI9sa7ypaeYsaAVi5gqDigDICg64yqSuwGaKiWEijysnz X-MS-Exchange-Transport-CrossTenantHeadersStamped: PH0PR03MB5719 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk SSBrbm93IEkgY2FuIGNyZWF0ZSB1c2VyIHN0ZXZlX3Rlc3Qgd2l0aCBwYXNzd29yZCB0ZXN0cGFz c3dvcmQxMjIgYXMgbWQ1IGJ5IGRvaW5nOg0KDQpzZWxlY3QgJ21kNSd8fG1kNSgndGVzdHBhc3N3 b3JkMTIyc3RldmVfdGVzdCcpOyAgUmV0dXJucyAtLT4gbWQ1ZWI3ZTIyMDU3NGJmODUwOTZlZTk5 MzcwYWQ2N2NiZDMNCg0KQ1JFQVRFIFVTRVIgc3RldmVfdGVzdCBXSVRIICBQQVNTV09SRCAnbWQ1 ZWI3ZTIyMDU3NGJmODUwOTZlZTk5MzcwYWQ2N2NiZDMnOw0KDQpBbmQgdGhlbiBJIGNhbiBsb2dp biBhcyBzdGV2ZV90ZXN0IHdpdGggcGFzc3dvcmQgdGVzdHBhc3N3b3JkMTIyLg0KDQpJJ20gdHJ5 aW5nIHRvIHVzZSBzaW1pbGFyIGxvZ2ljIHdoZW4gY3JlYXRpbmcgYSB1c2VyIG1hcHBpbmc6DQoN CkNSRUFURSBVU0VSIE1BUFBJTkcgRk9SIHBvc3RncmVzIFNFUlZFUiBzdGV2ZV9zbmFwMCBPUFRJ T05TICh1c2VyICdzdGV2ZV90ZXN0JywgcGFzc3dvcmQgJ21kNWViN2UyMjA1NzRiZjg1MDk2ZWU5 OTM3MGFkNjdjYmQzJyk7DQoNCldoZW4gSSB0cnkgYW5kIGltcG9ydCBhIGZvcmVpZ24gc2NoZW1h IEkgZ2V0IGFuIGVycm9yOg0KDQpFUlJPUjogIGNvdWxkIG5vdCBjb25uZWN0IHRvIHNlcnZlciAi c3RldmVfc25hcDAiDQoNCklmIEkgY3JlYXRlIHRoZSB1c2VyIG1hcHBpbmcgd2l0aCB0aGUgcGFz c3dvcmQ6DQoNCkNSRUFURSBVU0VSIE1BUFBJTkcgRk9SIHBvc3RncmVzIFNFUlZFUiBzdGV2ZV9z bmFwMCBPUFRJT05TICh1c2VyICdzdGV2ZV90ZXN0JywgcGFzc3dvcmQgJ3Rlc3RwYXNzd29yZDEy MicpOw0KDQpJdCB3b3JrcyBmaW5lLg0KDQpJcyBpdCBub3QgcG9zc2libGUgdG8gdXNlIHRoZSBz YW1lIGxvZ2ljIGZvciB0aGUgdXNlciBtYXBwaW5nIHBhc3N3b3JkIHRoYXQgY2FuIGJlIHVzZWQg d2hlbiBjcmVhdGluZyBhIHVzZXI/DQoNClRoYW5rcyBpbiBhZHZhbmNlLg0KVGhpcyBlLW1haWwg aXMgZm9yIHRoZSBzb2xlIHVzZSBvZiB0aGUgaW50ZW5kZWQgcmVjaXBpZW50IGFuZCBjb250YWlu cyBpbmZvcm1hdGlvbiB0aGF0IG1heSBiZSBwcml2aWxlZ2VkIGFuZC9vciBjb25maWRlbnRpYWwu IElmIHlvdSBhcmUgbm90IGFuIGludGVuZGVkIHJlY2lwaWVudCwgcGxlYXNlIG5vdGlmeSB0aGUg c2VuZGVyIGJ5IHJldHVybiBlLW1haWwgYW5kIGRlbGV0ZSB0aGlzIGUtbWFpbCBhbmQgYW55IGF0 dGFjaG1lbnRzLiBDZXJ0YWluIHJlcXVpcmVkIGxlZ2FsIGVudGl0eSBkaXNjbG9zdXJlcyBjYW4g YmUgYWNjZXNzZWQgb24gb3VyIHdlYnNpdGU6IGh0dHBzOi8vd3d3LnRob21zb25yZXV0ZXJzLmNv bS9lbi9yZXNvdXJjZXMvZGlzY2xvc3VyZXMuaHRtbA0K