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

Re: Not accepting passwords for remote logins

From: Frank Bax <fbax(at)sympatico(dot)ca>
To: PostgreSQL List - Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Not accepting passwords for remote logins
Date: 2011-02-28 12:11:59
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
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(at)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
> # "local" is for Unix domain socket connections only
> local all all trust
> # IPv4 local connections:
> host all all <> trust
> host all all <> md5
> # IPv6 local connections:
> host all all ::1/128 trust

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

host repository postgres md

With values appropriate to your setup.

In response to

pgsql-novice by date

Next:From: suresh ramasamyDate: 2011-02-28 19:10:35
Subject: dear friend
Previous:From: Liran RitkopDate: 2011-02-28 08:06:44
Subject: General question about memory usage

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