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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | suresh ramasamy | 2011-02-28 19:10:35 | dear friend |
Previous Message | Liran Ritkop | 2011-02-28 08:06:44 | General question about memory usage |