Re: [EXTERNAL] Re: Cannot connect local with ttrust (pg_upgrade assumes it)

Francisco Olarte <folarte@peoplecall.com>

From: Francisco Olarte <folarte@peoplecall.com>
To: "Abraham, Danny" <danny_abraham@bmc.com>
Cc: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Date: 2025-04-10T11:36:49Z
Lists: pgsql-general
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.