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 <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1u2qDq-006iNT-Nr
	for pgsql-general@arkaria.postgresql.org; Thu, 10 Apr 2025 11:37:30 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1u2qDp-00Aoy0-2y
	for pgsql-general@arkaria.postgresql.org; Thu, 10 Apr 2025 11:37:29 +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 <folarte@peoplecall.com>)
	id 1u2qDo-00Aoxh-On
	for pgsql-general@lists.postgresql.org; Thu, 10 Apr 2025 11:37:29 +0000
Received: from mail-ed1-x52f.google.com ([2a00:1450:4864:20::52f])
	by magus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.96)
	(envelope-from <folarte@peoplecall.com>)
	id 1u2qDm-004Vr1-20
	for pgsql-general@lists.postgresql.org;
	Thu, 10 Apr 2025 11:37:28 +0000
Received: by mail-ed1-x52f.google.com with SMTP id 4fb4d7f45d1cf-5e60cfef9cfso1207580a12.2
        for <pgsql-general@lists.postgresql.org>; Thu, 10 Apr 2025 04:37:26 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=peoplecall-com.20230601.gappssmtp.com; s=20230601; t=1744285046; x=1744889846; darn=lists.postgresql.org;
        h=cc:to:subject:message-id:date:from:in-reply-to:references
         :mime-version:from:to:cc:subject:date:message-id:reply-to;
        bh=lC8ZSBRHpba2KXPE0In6L96tm2VW7QJWF4sGygmWVcY=;
        b=Mh3NGAZnID3OFm65OKcogEPkojkkC2FRQCZHmD0rbKcI8YA4/2LXBAtARBbB6icrvE
         fLGdFIC/qlhqAHy1jZKiUjtxDSGxawCezJiczvtY3JkNsIg9lZR6NaFtV1Llw5mDKtXJ
         OyLo8VjtaYPaw8lgXUEOPjw9kQWGnRAPxoek01ldGShF6pTQMQwYkotLKipIMrPAMyLW
         6xYUekJffDN30NGc0xLWkNCQBhGwVvVTYytf6CSKVZZ2BcnFD92sg/jBiIjaHyKbKUpq
         7IUzmvSUNJdj/IFK86fmUYmyYMr4WMi24ws8711tTxaBEQykiCfB6XXNB1haiwNJTzGR
         u/6A==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1744285046; x=1744889846;
        h=cc:to:subject:message-id:date:from:in-reply-to:references
         :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id
         :reply-to;
        bh=lC8ZSBRHpba2KXPE0In6L96tm2VW7QJWF4sGygmWVcY=;
        b=Clg+v5A5ev1vrY8J+FJWb3U3HWJ1r0lyr14BqQeq/4Y0Ct5x22H/uUKtSSCQym4FmH
         tB1DUldFd+F9yurDLXecEqJ3JNSEvhiZyFr5mQRUxTyp3RgImDL3Ei3L/zHg1ZpDOT19
         ZvCOWXPl2oZUCl4+FPGyKVo5KpXT1kBHzkg0vH0CBi0VUr5eXJ5Pm7avQrluyl7CtTpx
         FeivzgJreHbzV9aBtRofY2QF9qlMPF4yt7a7qACd50ktG6c+tu7QNi4w8Slt8LDJTF7k
         hLYVBLXPL/5epxS3+ajmzfBzFCF63yer2nkCtknsFJvtlibgLMbh9fETs9vf8HcVo5t1
         MJEg==
X-Gm-Message-State: AOJu0Yy8f6GAYC2tVG7ZitMVVphtN3/cY66SX0ZgDT6W7MtcDXfHSJgX
	O+2i3OuFcP0pgGONE7cXyHvctSyyiXYV9lhndNm6rUqU0LMMEbCoT1KRzCh06kdKN8zSdYZ7ah4
	rx16OuSVjyiMtIJoY3LWp6yhnHsuAev9Etuok
X-Gm-Gg: ASbGncsDHknEWkdq24khbVq0Is/0b1JLbMnDqp5U2C2aMoBA2/Y2qUPqIZOceSClCKD
	xHPEFSjujc+A7HKEymV3DZ/3FHKXQDUYjzcyvneVvlMESEmRiDtBccrwSc45C01Q+iIfQcboocT
	XDZ67ZHoo+8V4RaZuDXz8=
X-Google-Smtp-Source: AGHT+IG7M+KfVfaLs9oi178i9UWkZ88pg31IhzCs5fOcB4KM8DALlVFmHt63EO6UqJ5kiTrHy3Rw46tW0PzjuPLjDxU=
X-Received: by 2002:a05:6402:2688:b0:5ed:994c:7e75 with SMTP id
 4fb4d7f45d1cf-5f3293183ffmr1766785a12.24.1744285045773; Thu, 10 Apr 2025
 04:37:25 -0700 (PDT)
MIME-Version: 1.0
References: <SA1PR02MB96986CA15EEF976BFE16D2F28EB42@SA1PR02MB9698.namprd02.prod.outlook.com>
 <CA+bJJby+nA8OVs7AZKgGBX2Dx3ApvhEceWtFiq97crkiER2A=Q@mail.gmail.com>
 <e5ff9605-80d6-4da9-a4ef-c6fa43bf4599@bmc.com> <CA+bJJbxHQvDkOK4v-FS9rqrkEQWfD9YJgoABEi4QTrxuNogYhA@mail.gmail.com>
In-Reply-To: <CA+bJJbxHQvDkOK4v-FS9rqrkEQWfD9YJgoABEi4QTrxuNogYhA@mail.gmail.com>
From: Francisco Olarte <folarte@peoplecall.com>
Date: Thu, 10 Apr 2025 13:36:49 +0200
X-Gm-Features: ATxdqUFEnsKu8VUaP2_wayqQDI0O7sK_mcxkw3Nwu4NSzKIwNJDNnS5_QVMeDOM
Message-ID: <CA+bJJbxFFYXQE+LXhes0=7O9USmxb+3SJZVoq7f+HXPPr_o9ug@mail.gmail.com>
Subject: Re: [EXTERNAL] Re: Cannot connect local with ttrust (pg_upgrade
 assumes it)
To: "Abraham, Danny" <danny_abraham@bmc.com>
Cc: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: text/plain; charset="UTF-8"
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/CA%2BbJJbxFFYXQE%2BLXhes0%3D7O9USmxb%2B3SJZVoq7f%2BHXPPr_o9ug%40mail.gmail.com>
Precedence: bulk

Abraham:

On Thu, 10 Apr 2025 at 13:30, Francisco Olarte <folarte@peoplecall.com> wrote:

> You forgot to answer the first and most important question.
> > How are you connecting? Your symptoms matches confusing local with
> > TCP/IP to localhost. They are not the same thing.

After reading more messages it seems you use plain psql -U.

Can you try to do \conninfo after connecting to see how you are connecting?
- If it says tcp, then it is a problem with how psql determines where
to connect.
- If it says local then it may be an hba problem.

Francisco Olarte.