Skip site navigation (1) Skip section navigation (2)

Not accepting passwords for remote logins

From: Joel <felixtheratruns(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Not accepting passwords for remote logins
Date: 2011-02-27 21:43:58
Message-ID: AANLkTimbrSpe9kj+K2Cdvmwk3z5MK6sJY9UbmanXUUS5@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
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(at)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.

Responses

pgsql-novice by date

Next:From: Liran RitkopDate: 2011-02-28 08:06:44
Subject: General question about memory usage
Previous:From: Nick RajDate: 2011-02-27 04:06:16
Subject: Spatio-Temporal function

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group