psql: FATAL: Peer authentication failed for user
The order of rules in pg_hba.conf
matters.
Trying to connect to postgresql database with a standard user fails with psql: FATAL: Peer authentication failed fr user "user1"
.
The second line of pg_hba.conf
makes your connection attempt fail:
|
|
The order of rules matter. If the first one that matches the access method, username, database name and source IP range fails, there will be no second attempt. So either remove this line, your place your rule above this one.
Author Aditya
LastMod 2023-01-04 (f2f6f7d)