Re: [GENERAL] User authentication failed - Mailing list pgsql-general

From Bob VonMoss
Subject Re: [GENERAL] User authentication failed
Date
Msg-id 36F7C085.881F4666@idm.com
Whole thread Raw
In response to User authentication failed  (Jean Lee <jean@cinesite.co.uk>)
List pgsql-general
Jean Lee wrote:

> I'm running postgres-6.4.2 on one machine, and want to access it from
> another, but get the error message
>
> % psql -h vsop rndprojectdb
>
> Connection to database 'rndprojectdb' failed.
> User authentication failed
>
> vsop is remote host
> rndprojectdb is database

I was having a similar problem (same error message) when routing through a
TCPIP port. When I created a password with pg_passwd (something like that),
I was able to route through TCPIP as opposed to unix sockets, which had been
working all along.

--
Bob VonMoss
mailto:bvonmoss@bigfoot.com
from Rosemont, IL



pgsql-general by date:

Previous
From: Eugenia Bulakh
Date:
Subject: [GENERAL] Restore deleted records
Next
From: Marcin Grondecki
Date:
Subject: Re: [GENERAL] Restore deleted records