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 1u2YIR-002M0e-02 for pgsql-general@arkaria.postgresql.org; Wed, 09 Apr 2025 16:29:03 +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 1u2YIP-005288-EE for pgsql-general@arkaria.postgresql.org; Wed, 09 Apr 2025 16:29:01 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u2YIO-005271-9m for pgsql-general@lists.postgresql.org; Wed, 09 Apr 2025 16:29:01 +0000 Received: from fout-a8-smtp.messagingengine.com ([103.168.172.151]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1u2YIM-003uLR-29 for pgsql-general@lists.postgresql.org; Wed, 09 Apr 2025 16:28:59 +0000 Received: from phl-compute-02.internal (phl-compute-02.phl.internal [10.202.2.42]) by mailfout.phl.internal (Postfix) with ESMTP id 6843A1380142; Wed, 9 Apr 2025 12:28:57 -0400 (EDT) Received: from phl-mailfrontend-01 ([10.202.2.162]) by phl-compute-02.internal (MEProxy); Wed, 09 Apr 2025 12:28:57 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:content-transfer-encoding:content-type:content-type:date:date :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to; s=fm1; t=1744216137; x=1744302537; bh=0i4l6mkFNVR/kHrP9hc6qVak0/b4teAu8Kwdwp7ZTmY=; b= kd3UL4qQjkFlfLq4unz6/Po8uhpKWgfai/r7P/PrYU7QwpVj0x1ntm2vE5l28a5o Kc53Pi3GBszzQtsnaAjBiMU7TtZHyImY7nM9olxxaWkuCEoOjPduL3q9EafXPFNE a8kpEVfMXufV+Iek+0oJMjO9MWHSRpOhi3Adc5TbzOcvMIREhzOOtJby8IgMoWzQ /TjPOAEqhxZqgZxuUREF8eR8YIrS/OICiixbg3aRcTh1bxpdymEGwtR3GjKX6hnn mz04sYohEd7TXCZHrAc3JamdojUFujgtFNVPuxKPLs/qkVfw07Sr+wtzpPs9KhoV hF8iHW47RNlOF7z8kEnpdQ== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :content-type:date:date:feedback-id:feedback-id:from:from :in-reply-to:in-reply-to:message-id:mime-version:references :reply-to:subject:subject:to:to:x-me-proxy:x-me-sender :x-me-sender:x-sasl-enc; s=fm2; t=1744216137; x=1744302537; bh=0 i4l6mkFNVR/kHrP9hc6qVak0/b4teAu8Kwdwp7ZTmY=; b=LJx9t4zeVp+gUt8WJ GmiWdQz7vbHT1Z2e91oUdDxPM2kZq9dBhYn+mQBPO/ea0psvY7PMp2qrCJi5EMBF FUWbnkc73LepEsEFHs2pXfKGqcoVGkVoBfPpvyND8IBVoj1SlV7N5IdAX+EuKUpS UEBS3nk4iYrzzHeY7aMbHrv1Iewo/WHZrd5ift7eFDeqcm+kgxbf/MrAuZroxWqy p/1ky5u3mo/IeR5aZiAb8cQAGuN+AhqGFyOSd6khjCD2ceOP3XfvFuACfUnZoVHx DGJ88UXBXdUAoVoKG+RL0HKxmkNfkrYj9JRAU2QRx7jtZrMGDXTWBL85VbHgvVQz SnOMQ== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefvddrtddtgddvtdeigeelucetufdoteggodetrf dotffvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdggtfgfnhhsuhgsshgtrhhisggv pdfurfetoffkrfgpnffqhgenuceurghilhhouhhtmecufedttdenucesvcftvggtihhpih gvnhhtshculddquddttddmnecujfgurhepkfffgggfuffvfhfhjggtgfesthejredttddv jeenucfhrhhomheptegurhhirghnucfmlhgrvhgvrhcuoegrughrihgrnhdrkhhlrghvvg hrsegrkhhlrghvvghrrdgtohhmqeenucggtffrrghtthgvrhhnpeeivdfhieehheegueei leejieettdejhedugeefleekvdelkeehtdfgiefffeekudenucevlhhushhtvghrufhiii gvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpegrughrihgrnhdrkhhlrghvvghrsegr khhlrghvvghrrdgtohhmpdhnsggprhgtphhtthhopedvpdhmohguvgepshhmthhpohhuth dprhgtphhtthhopegurghnnhihpggrsghrrghhrghmsegsmhgtrdgtohhmpdhrtghpthht ohepphhgshhqlhdqghgvnhgvrhgrlheslhhishhtshdrphhoshhtghhrvghsqhhlrdhorh hg X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed, 9 Apr 2025 12:28:56 -0400 (EDT) Message-ID: Date: Wed, 9 Apr 2025 09:28:55 -0700 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Cannot connect local with ttrust (pg_upgrade assumes it) To: "Abraham, Danny" , "pgsql-general@lists.postgresql.org" References: Content-Language: en-US From: Adrian Klaver In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 4/9/25 09:20, Abraham, Danny wrote: > Hi, > Asking for help with inability to connect local using trust > > The # are comments that would 'hide' the lines below from being looked at for authentication purposes. Is this really how the lines are in your pg_hba.conf file? > Fail > #local all all trust > #local all dbauser peer > > OK > #host all all 127.0.0.1/32 trust > > -- Adrian Klaver adrian.klaver@aklaver.com