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 1u2YAL-002KCV-Cg for pgsql-general@arkaria.postgresql.org; Wed, 09 Apr 2025 16:20:41 +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 1u2YAI-004uEU-TJ for pgsql-general@arkaria.postgresql.org; Wed, 09 Apr 2025 16:20:39 +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 1u2YAI-004uEH-D1 for pgsql-general@lists.postgresql.org; Wed, 09 Apr 2025 16:20:38 +0000 Received: from mx0b-001c1302.pphosted.com ([205.220.180.87]) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1u2YAE-004MwM-2M for pgsql-general@lists.postgresql.org; Wed, 09 Apr 2025 16:20:37 +0000 Received: from pps.filterd (m0279008.ppops.net [127.0.0.1]) by mx0b-001c1302.pphosted.com (8.18.1.2/8.18.1.2) with ESMTP id 539DibWi031876 for ; Wed, 9 Apr 2025 16:20:32 GMT DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=bmc.com; h=cc :content-transfer-encoding:content-type:date:from:message-id :mime-version:subject:to; s=dkim202204; bh=a46Ph+ENq30RJSKbY8Pj9 HXyqKsw4pMxBADdwYrpaCc=; b=GG0o9P17J5kculv6b5QBGTp0qP1sGMedYMoVK fOHOMJno7knHtCXRSes0o8Dv0eIE9BovaUiuswig1/0SDfRQu0lEk4tykGsB8yYG sn/AAw3rheqpqq/9X1THJXnpgI3LKjHsbScWVlmlmshX6yMBFRZX7wMDclKKJ6bJ 4iGfvsMu5gEC6DR9PRbOwrFEnXzILCGvrVzVzZcy9/y+igM6TvnJzx72dsqJbLPu hNmJh6WgKNkfkFFgq9Dx34BH/MDdzHpch7tVesUmlozns5G1fJXpiUkHLa/lBuu8 FCCBnHlncEz+ZqYuXi4Br8ZetANZUKv0AjLX8U8uIPZoEWk7Q== Received: from nam12-dm6-obe.outbound.protection.outlook.com (mail-dm6nam12lp2170.outbound.protection.outlook.com [104.47.59.170]) by mx0b-001c1302.pphosted.com (PPS) with ESMTPS id 45vjyppf6y-1 (version=TLSv1.2 cipher=ECDHE-RSA-AES256-GCM-SHA384 bits=256 verify=NOT) for ; Wed, 09 Apr 2025 16:20:31 +0000 (GMT) ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=BPreHeHOfrdGh0GOuiDeZVxWcRjubJLQPYt08Ydvinb8UtJKldvtpcJmftVTJeHMB2ssfg5Tw8H5uGYBhofrVrdTkpOU/fQgO41pWK+hFyRjQSkwZ1TrFA7ma3Tj8jOryQdBcOEB9W4PQHgy1Uy6+0m4lIv60KVvpu8DNSXt0+MfAcBzcwhvC+rNc5+hZiiI0WdEw6E7sjXEnqvynQsLUegPvKxrZPD+yLnv64WJWqs3D8ZUqfeJh/vHWBoGsesf3IgkIvldnHra0vFJBlOXUB/MSsfiY5VfTVTeOxqPuDjEeMwiQTZMGyY66SmMZpGSx/KDNdAuIB8jokW9fb1Pww== 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=a46Ph+ENq30RJSKbY8Pj9HXyqKsw4pMxBADdwYrpaCc=; b=g0k2CEHPP/d7SfP1B3NxwXJ+eDeAj8OEnUpbAhIK9yL2EHcAusfDhZbyM6DPteWHb+WAihzs9OpcX/a0pZ65KRGnYvGOTO87Nmu+7ZZPIL1Id6boo2KdRXrJlEkT42cRYK2XvnqrG/s3sPJmwmZ4mWPmWHh99IdnK08adogBpT8FkC2eV0HJUFTRy2RVeBqkeIuBooL6zBaYkcDRbY3LxIiNxSghANLEjBHEr6W4KzC71s1j73Ovr1YiNej/7Eff37Hqs1wtD/8S5GFWl+iauwYajSJMvN9tP/cj7ClcwLDEh532/ZJXJGi8r0qAFKEqEKpLMUsS5xbGK7tr3qkUKw== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=bmc.com; dmarc=pass action=none header.from=bmc.com; dkim=pass header.d=bmc.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=bmcsoftware.onmicrosoft.com; s=selector2-bmcsoftware-onmicrosoft-com; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=a46Ph+ENq30RJSKbY8Pj9HXyqKsw4pMxBADdwYrpaCc=; b=NFuCBbPdOEock1nISEXAtkBOKnjP9SRktPyWZ7/l9T1DMtvqK22sOzJxqFdLhRyCa+IZ15lS/BduFB6fjUzSsdKAt68K2mhfXuKrl4wyg5gscQ6F/A8ILLg4GXjW9CoblYEpG77IxloCp5O+2TT1gTQw/tjRmDJSEjkx0G6ltZA= Received: from SA1PR02MB9698.namprd02.prod.outlook.com (2603:10b6:806:385::11) by CH0PR02MB8225.namprd02.prod.outlook.com (2603:10b6:610:ea::16) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.8632.23; Wed, 9 Apr 2025 16:20:29 +0000 Received: from SA1PR02MB9698.namprd02.prod.outlook.com ([fe80::4ced:9ced:d904:1b01]) by SA1PR02MB9698.namprd02.prod.outlook.com ([fe80::4ced:9ced:d904:1b01%6]) with mapi id 15.20.8606.029; Wed, 9 Apr 2025 16:20:29 +0000 From: "Abraham, Danny" To: "pgsql-general@lists.postgresql.org" CC: "Abraham, Danny" Subject: Cannot connect local with ttrust (pg_upgrade assumes it) Thread-Topic: Cannot connect local with ttrust (pg_upgrade assumes it) Thread-Index: Adupa04JdBiA/l++RXSWyenCz2prSQ== Date: Wed, 9 Apr 2025 16:20:29 +0000 Message-ID: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-ms-publictraffictype: Email x-ms-traffictypediagnostic: SA1PR02MB9698:EE_|CH0PR02MB8225:EE_ x-ms-office365-filtering-correlation-id: 4f5edc94-7805-437a-afb7-08dd778271bb x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0;ARA:13230040|376014|1800799024|366016|38070700018; x-microsoft-antispam-message-info: =?us-ascii?Q?kRF4gQAgRnDzxC2Rjueu7Ha4wdVtYHD7v7R3fclojJC+dB0G5x6cASPxQDSP?= =?us-ascii?Q?v0UtxLxw/4hwdCwZOVjy1B+/dX+wWNcG/GnTs/9XcJBcBz7bXDwWX6OmibUZ?= =?us-ascii?Q?vzxDOG3E/Upr3KGtFmqdXv5MBXO/ytVzGgNGjj34Z1aucQjG1X8WrFlN8HLq?= =?us-ascii?Q?WjCDjRtW2VpijnM6FhlpuFL589lIT9NRgHJmKkEaWRrDwI1YAdIcurTj8W60?= =?us-ascii?Q?FyJCDH3PXxW1hldOObVEgSl94XyCbw2laIT6TZeRPbI5uq0WvUkDEtGFHl1e?= =?us-ascii?Q?0WvESzvrr6Kv7gdodvpbET+7vWIJ3M+ddCvvCUliYvm08lO/TgbpiCwyTV4h?= =?us-ascii?Q?c3THCxKc9cNR3n2vjAiNOj5iRef6X0iqbjGfVx/0Qr3FwUThyqO6R5aRyUW1?= =?us-ascii?Q?ZQ+K68vU+qa5pONWV3pvihzOOTV9MFfb+NU8EpwtHKd9PJj04FNrw1H1ic+y?= =?us-ascii?Q?pyuRBwxOrFWutlRI5Z6iicCGCcyjnTpK3QWfeprzefmsp+kAgDiSNzNrtWsD?= =?us-ascii?Q?eFC7Y+RxNskpCh8mgVH/ywpk4w8wY7Ph6qofB8qjgDlxNBVA2znAS1j+wqcP?= =?us-ascii?Q?QCy1FIIPBxZdh9LilnA/SRpbSbD9xi9EsgZBF6HigznZKBC3bQCNWWJuYqrM?= =?us-ascii?Q?KgME4H6LSyuGq5sduwRb7fxg5yPF/X3NmJjTb79cgXC0kbOBeRXGx78At/yU?= =?us-ascii?Q?u4BQyagcKzZp2IZXRX/lMe6vToeaPj/cutVq9uMlYnolbZqqqv9gKp3wf/yB?= =?us-ascii?Q?BTenqxFFxw/PFMUHEZLZG2wtMXTR0vcj0lB6Y/EG0tOpBUN/NqchHlM4/nzb?= =?us-ascii?Q?I/dQDmaD6K0+pqL4xRZ4uxqjkgeWW0L7zHZADn/xrpuHDkR4YGeXIOc/3Rbs?= =?us-ascii?Q?1vsBtdxXzfpuJIFN8yLRFp7s8ABXx88M7qAQCzTb5iKJVUs0jhIUI25VlYoB?= =?us-ascii?Q?v8jOVmBjqNGt7HuTt3/G+fayv5/eucsC9Xul0oN3jR0xotMHMqNuJIYfGfsG?= =?us-ascii?Q?nj36PEAu0yFa6Y39gmX1mxhyYaKKa0Cm7QHYuQ2Y1LafjQOdjXxYoYDpOTIh?= =?us-ascii?Q?5gpZ4/cz2964uxiO6O4ReXgWnhKigwGOwxegXLOlQHTTlgVTGxRYRjobkdiE?= =?us-ascii?Q?5tmFxYbBdCxOT+Q6DnCSJfe5zXOZ+g7Lo2aSfzia0f7ITIePg+OeBB+wswlU?= =?us-ascii?Q?qo603Un7cFVmqWQFePACoIGjqHTmwNpDgDXlfeZXHx0mCFeMRqhiRoA5Ichj?= =?us-ascii?Q?pgP8Lpr9QX8to9aPiKoYTGIXBublaSnSrex//GLrAnNe49BNVxMNXSo+mGpD?= =?us-ascii?Q?Shbl1a38KSMQ647OMx6FrBG+d6QiapSU2e4D74YatoE8vOnKnS7wLjnHEbuH?= =?us-ascii?Q?4VexzkbZKdL7+uMOzLw91h87w1DYVwVeCBxWfLHQmjuWsArIMJGGFhghY9F6?= =?us-ascii?Q?IWcNcVc+yGIQ2raiunHOCoSrc8VcEpiw3vEXlXmsTeliSx07OJ1wVJFme3fO?= =?us-ascii?Q?OMXcJ4l/9SH6lMA=3D?= x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:SA1PR02MB9698.namprd02.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230040)(376014)(1800799024)(366016)(38070700018);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?us-ascii?Q?lX9EvFHJHSHu+l4Gnp4EmQ3+X+nt4Mi3NBk5LV9QXEcDEgii7xiDtTOo8A5I?= =?us-ascii?Q?1ZQ4WM+7vL3XXfqRmYFoRGxnTSTrkkgRdjAgfqRMwpFcPRZmsg0pnJDwDR6p?= =?us-ascii?Q?UXSVX73JXOFA5J5ocoIks6Oe64xo6W8FcS8HboOgMN/iRxYaE72aYL0UvjxT?= =?us-ascii?Q?x49d9QhOP2zkNVE3Pw4rUU3th3i0wdsJf/x/LJUhV/HYp6Wzko6pfNGbWHQl?= =?us-ascii?Q?nolveAn7d0JnZSGzSWM1W3551kaRxkLw8J02ilNUgJH7JidFbQ07kk1U1t0t?= =?us-ascii?Q?HEa/NWquyhw7uxatf7Q8oDcpLZrZsEqVpD5isTG+ExoRF/62sIAFoK0r6zwC?= =?us-ascii?Q?uVFbfUIg34pA/JevTaGt4ny7tCN2X8/QQqnudCDmJaVe0POSstXSZ2e2g1XX?= =?us-ascii?Q?p15bGeT5MyY4BlesMGHtSYbz25qugzOoQ5lRLuf5fd1inIpooX8+BpA710T+?= =?us-ascii?Q?yIHupoSt8K9s+Kzg86q1KaR7zjKjJCZj0hlExccppVSMX4G+/ZjSqQQ+kpc0?= =?us-ascii?Q?M0JiSzYr0AZh94K1lqx117MbfNsl5XP0o0aqc31wiKPh7xYTKvsHLfIqFLP0?= =?us-ascii?Q?cy4JzBiYfL4B6stvEorPYwWrUtMYhZ1lglaCmKGjlJ7f+ti2bIKI2t1JkWWm?= =?us-ascii?Q?VyXgPcoqHaioHya99vRB+g31BqAmFEsAXtdK6RZHNmNqM4zgk3RyJ6Ky3QQf?= =?us-ascii?Q?R75SK2o0uMMwazvycYT3yvoh9v90ZHzCDjQNfiosQY2D90riDur1L3HvDINc?= =?us-ascii?Q?hsVf2kEnPN/xqe7VSeCwYgSVgZOX/Ka5w+q9o0hnqOAu4R/cSDu+hVGLpoJE?= =?us-ascii?Q?qgkExe45BVJfjhr/smG/Oerjh9Cs9go5zdqQr94tBS2UsQG0uAe1D1yqK89t?= =?us-ascii?Q?JibOUjxMjzbRbLlqUgTSZLINFUO7+9T1HDhRZuW+mnu4OcL0jOSnm6488QV4?= =?us-ascii?Q?siu2hEGaTOePcSfnogr/PNEt1iyRzw4OLLHQtDaVCCl43js6HEFijWR11seI?= =?us-ascii?Q?J1N5utmaRCOHZl6jCwuQQuxQkiqcXk3T3B4PscSTrM9beggQkZuq0MOdPpXf?= =?us-ascii?Q?2Dpj9HXf5wQ3+wnKvNmBVCWLP4GiV5LP5R9SmM3+IxzQJfZCLcEJ/S+IJhLp?= =?us-ascii?Q?cmgYj3XaCQszgIgRoL492f1BzjkHaDVnC5GdhYFn7K7nyMAt+AK3/BW5OZ29?= =?us-ascii?Q?ZmqCKBUfl+zBigC6jMCFxddWE7kmOzoG0+264InVRPjfGki2fNn5A8cL3HL5?= =?us-ascii?Q?pZHt9sKjxguTL6bWgj8g5QLnYqyvf/5BDTeCcJ/7VeLbQfqV5yQXMi86H6NV?= =?us-ascii?Q?eXx6wOqb54wlhgjqPU/hDSWDaLS57BqDrEmmWfnKHM1nBOUZq/4uWDRzB0rG?= =?us-ascii?Q?wcrn8AO8uN/JijOREgNO867Ycs26iVlwcxTj3nNYnbO2bK5tm6lnFawCjsbR?= =?us-ascii?Q?wcNoDNxK8i0SFZHpP4dZ6tJCMNNWfNJgZyISJa6s9ubGLg91Hhyhdea5Y4Gs?= =?us-ascii?Q?YLDthvdKu/TCFoxrfKnWR8E93uejtfRAC2z6l4knH5L3muR3ZQDWenVmyhIZ?= =?us-ascii?Q?tWHsKR1mXl4uxLvxSbE=3D?= Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-OriginatorOrg: bmc.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: SA1PR02MB9698.namprd02.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: 4f5edc94-7805-437a-afb7-08dd778271bb X-MS-Exchange-CrossTenant-originalarrivaltime: 09 Apr 2025 16:20:29.3419 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 92b796c5-5839-40a6-8dd9-c1fad320c69b X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: ePx9v7EBnOfxGn8IhNkUlTKK/AcTNLcTjVEccmwnVk7NhkSPyTqSTvvumJH1YcD7iU79yM0eMvwMY28AybOZTA== X-MS-Exchange-Transport-CrossTenantHeadersStamped: CH0PR02MB8225 X-Authority-Analysis: v=2.4 cv=Y9f4sgeN c=1 sm=1 tr=0 ts=67f69e50 cx=c_pps a=oQ/SuO94mqEoePT5f2hFBg==:117 a=lCpzRmAYbLLaTzLvsPZ7Mbvzbb8=:19 a=wKuvFiaSGQ0qltdbU6+NXLB8nM8=:19 a=Ol13hO9ccFRV9qXi2t6ftBPywas=:19 a=xqWC_Br6kY4A:10 a=kj9zAlcOel0A:10 a=XR8D0OoHHMoA:10 a=uF0kXBFlZFoA:10 a=ZXbCBayoFKxm0lcrn7oA:9 a=CjuIK1q_8ugA:10 a=DVKqRkKJf1IA:10 X-Proofpoint-GUID: LA213P_dPOBMbmYXHOMseY0Do4qvKPmZ X-Proofpoint-ORIG-GUID: LA213P_dPOBMbmYXHOMseY0Do4qvKPmZ X-Proofpoint-Virus-Version: vendor=baseguard engine=ICAP:2.0.293,Aquarius:18.0.1095,Hydra:6.0.680,FMLib:17.12.68.34 definitions=2025-04-09_05,2025-04-08_04,2024-11-22_01 X-Proofpoint-Spam-Details: rule=outbound_notspam policy=outbound score=0 clxscore=1015 lowpriorityscore=0 malwarescore=0 priorityscore=1501 impostorscore=0 suspectscore=0 spamscore=0 phishscore=0 bulkscore=0 mlxscore=0 mlxlogscore=247 adultscore=0 classifier=spam authscore=0 authtc=n/a authcc= route=outbound adjust=0 reason=mlx scancount=1 engine=8.19.0-2502280000 definitions=main-2504090105 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, Asking for help with inability to connect local using trust Fail #local all all trust #local all dbauser peer OK #host all all 127.0.0.1/32 trust