RE: [INTERFACES] Still have problems connecting to Localhost...

On 08-Jun-99 Andre Carvalho wrote:
> Thanx for solution with "load libpgtcl.so"...
>
> but now I have the other problem when I try to connect to the localhost
> server (with libpgtcl) I get the answer:
> "Connection to database failed
> User authentication failed"...
>
> I verified and the server is running with the -i option (it's OK) , and
> connections from other machines to the server work fine too.
> But when try to use libpgtcl to local connections I get errors... Running
> psql localy works fine too, but with the options:
> " psql -h localhost -u template1 "
> I received the error:
> "Connection to database 'template1' failed
> User authentication failed"...
>
> I just can't understand why remote connections work fine and local not...
> if anyone can help me....

You didn't mention you'd done this so I'll suggest it - take a look
at your $PGDATA/pg_hba.conf file. There should be a line near the bottom that
looks like this:

host all 127.0.0.1 255.255.255.255 trust

If there's something other than trust in the authentication
field, you should make sure that the method you chose is operating
correctly. Also, make sure that a name lookup of "localhost" yields
the IP address "127.0.0.1".

----------------------------------
Date: 08-Jun-99 Time: 14:48:00

Craig Orsinger (email: <orsingerc(at)epg(dot)lewis(dot)army(dot)mil>)
Logicon RDA
Bldg. 8B28 "Just another megalomaniac with ideas above his
6th & F Streets station. The Universe is full of them."
Ft. Lewis, WA 98433 - The Doctor
----------------------------------