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: 4D6B910F.7020102@sympatico.ca (view raw or flat)
Thread:
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
> # 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.

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-2014 The PostgreSQL Global Development Group