Thread: user authentication failed...

user authentication failed...

From
StOo
Date:
This is really daft but i cant think what i have missed

I've got 1 postgres machine thats running the DB and 1 develkopment
machine that connects to the backend on the development machine and
plays ball nicley.

I've just come to add a new devlopment machine , same flavour of linux
same postgres release (6.4.2) i came to run a straight forward test
program and i keep getting 
user authentication failed

the ports are the same, the user has been added in the psql even when i
use an exsisting name and password i get grief ... any ideas ...

Stuart

+-=-=-=-=-=-+

Too much coffee not enough sleep.


Re: [INTERFACES] user authentication failed...

From
Tom Lane
Date:
Did you remember to add the new machine to pg_hba.conf?

6.4 is pretty closemouthed about telling you exactly why it's refusing
your connection; "user authentication failed" actually covers a lot of
different reasons.  6.5 will give a bit more info ... hopefully not
enough to risk being a security problem ...

Also, the postmaster log may contain more info than is reported to
the client.
        regards, tom lane