From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | ourdiaspora <ourdiaspora(at)protonmail(dot)com> |
Cc: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: php connection failure |
Date: | 2021-08-08 00:51:45 |
Message-ID: | 79e859dc-9e70-cb72-85f8-e31786ad224d@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 8/7/21 5:36 PM, ourdiaspora wrote:
>
> On Sunday, August 8th, 2021 at 1:02 AM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> wrote:
>
>> What did you change listen_addresses from?
>>
>
> New line; same line had hash (#) to comment out.
>
>> What if you do?:
>>
>> psql -d cpacweb -U cpaca
>>
> psql -d cpacweb -U cpaca
> psql: FATAL: Peer authentication failed for user "cpaca"
>
>
So from a previous post of yours I have pasted the pg_hba.conf file
below my instructions:
1) Get rid of the first local line .
2) Then for the remaining local line below change peer to trust and
restart Postgres.
3) Then repeat:
psql -d cpacweb -U cpaca
local all postgres peer
# TYPE DATABASE USER ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all peer
# IPv4 local connections:
host all all 127.0.0.1/32 md5
# IPv6 local connections:
host all all ::1/128 md5
# Allow replication connections from localhost, by a user with the
# replication privilege.
#local replication postgres peer
#host replication postgres 127.0.0.1/32 md5
#host replication postgres ::1/128 md5
local cpacweb cpaca trust
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2021-08-08 01:15:39 | Re: php connection failure |
Previous Message | ourdiaspora | 2021-08-08 00:36:47 | Re: php connection failure |