Answer the question
In order to leave comments, you need to log in
Why does psql authorization work partially?
Authorization works partially - I changed the password and now it enters interactive mode:
~> psql -d postgres -U postgres
Password for user postgres:
postgres=#
~> psql -d postgres -U postgres -h localhost
Password for user postgres:
psql: error: FATAL: password authentication failed for user "postgres"
# Database administrative login by Unix domain socket
local all postgres md5
# TYPE DATABASE USER ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all md5
# 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.
psql -h localhost postgres postgres
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question