Re: [EXTERNAL] Re: Cannot connect local with ttrust (pg_upgrade assumes it) - Mailing list pgsql-general

From Francisco Olarte
Subject Re: [EXTERNAL] Re: Cannot connect local with ttrust (pg_upgrade assumes it)
Date
Msg-id CA+bJJbxFFYXQE+LXhes0=7O9USmxb+3SJZVoq7f+HXPPr_o9ug@mail.gmail.com
Whole thread Raw
In response to Re: [EXTERNAL] Re: Cannot connect local with ttrust (pg_upgrade assumes it)  (Francisco Olarte <folarte@peoplecall.com>)
List 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.



pgsql-general by date:

Previous
From: Francisco Olarte
Date:
Subject: Re: [EXTERNAL] Re: Cannot connect local with ttrust (pg_upgrade assumes it)
Next
From: Dimitrios Apostolou
Date:
Subject: Re: pg_restore causing ENOSPACE on the WAL partition