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.