Thread: Not accepting passwords for remote logins

Not accepting passwords for remote logins

From

Joel

Date:

28 February 2011, 09:45:52

So I can login while I am on the system as postgres, but when I try to login remotely (directly to the database) I get this:

x@x-U52F-BBL9:~$ psql -h servername -U postgres -d repository
Password for user postgres:
psql: FATAL: password authentication failed for user "postgres"

The password fails everytime. Any clues as to what this symptom might entail?

I have already in postgresql.conf set:
listen_addresses = '*'

Here is the end of my pg_hba.conf
# TYPE DATABASE USER CIDR-ADDRESS METHOD

# "local" is for Unix domain socket connections only
local all all trust
# IPv4 local connections:
host all all 127.0.0.1/32 trust
host all all 0.0.0.0/0 md5
# IPv6 local connections:
host all all ::1/128 trust

Thanks.

Re: Not accepting passwords for remote logins

From

Frank Bax

Date:

28 February 2011, 11:37:45

On 02/27/11 16:43, Joel wrote:
> So I can login while I am on the system as postgres, but when I try to
> login remotely (directly to the database) I get this:
>
> x@x-U52F-BBL9:~$ psql -h servername -U postgres -d repository
> Password for user postgres:
> psql: FATAL: password authentication failed for user "postgres"
>
> Here is the end of my pg_hba.conf
> # TYPE DATABASE USER CIDR-ADDRESS METHOD
>
> # "local" is for Unix domain socket connections only
> local all all trust
> # IPv4 local connections:
> host all all 127.0.0.1/32 <http://127.0.0.1/32> trust
> host all all 0.0.0.0/0 <http://0.0.0.0/0> md5
> # IPv6 local connections:
> host all all ::1/128 trust

This conf does not allow remote connections.  try something like this:

host repository postgres 192.168.1.50 255.255.255.255 md

With values appropriate to your setup.