Horton
Menu

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

Adrian Klaver <adrian.klaver@aklaver.com>

View thread
From: Adrian Klaver <adrian.klaver@aklaver.com>
To: "Abraham, Danny" <danny_abraham@bmc.com>, "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Date: 2025-04-09T16:28:55Z
Lists: pgsql-general 
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