2

**I am able to connect LOCALLY to the postgres user but NOT Remotely. This is a different issue then the one noted in Auth Failed for Local Connection **

I have PostgreSQL installed on a VM, and am able to connect remotely with one user called 'myapp', but when I try to login remotely with the 'postgres' user I get an:

Error connecting to the server: FATAL: password authentication failed for user "postgres" FATAL: password authentication failed for user "postgres"

However when I attempt to login locally as postgres it succeeds:

vagrant@postgresql:~$ psql -U postgres Password for user postgres: psql (9.4.5) Type "help" for help. postgres=#

Here are the full configurations for my pg_hba.conf file:

local all postgres md5 local all all md5 host all all 0.0.0.0/0 md5

Also I added: postgresql.conf: listen_addresses = '*'

Please help me understand what I am doing wrong, why is it that a random user can login from a remote connection but then I cannot log into postgres user remotely? The key here is that I want to be able to create a user that I can log in remotely. i'm seeing the same issue when creating create role me with login password 'me'; , with that I cannot log in remotely either but locally I can.

Improve this question
4
  • 1
    Are you sure you're connecting to the same PostgreSQL instance in both cases? Commented Nov 24, 2015 at 5:18
  • there is only one postgres instance Commented Nov 24, 2015 at 5:25
  • Possible duplicate of psql: FATAL: password authentication failed for user Commented Nov 24, 2015 at 11:40
  • Christian your link is about a completely different issue. Your link describes an issue with local connections I do not have that problem!! My problem is with REMOTE connection when local clearly works fine. Commented Nov 25, 2015 at 3:18
Related questions
605
'password authentication failed for user "postgres"'
1
PostgreSQL password authentication failure on Linux only
18
Login Failed with Existing User on PostgreSQL
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.