Answer the question
In order to leave comments, you need to log in
Why doesn't authentication with PG pass with a password?
Here is pg_hba.conf:
The connection works like this: sudo -u postgres psql
As you can see from the config, I added password authentication for the postgres user. Pg restarted (sudo systemctl restart postgresql). Further, using the login method above, I performed:
I connect like this:
and I get:ALTER USER postgres PASSWORD 'postgres';
psql -U postgres -W -h 127.0.0.1 -d postgres
psql: FATAL: password authentication failed for user "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