Re: problem to connect

On Tue, 8 Apr 2003, nicolas renie waxed:

8<'s

> I logged under another linux user
> I tried : psql test -h localhost -U nicolas and received the message
>
> No pga_hba.conf entry for host localhost, user nicolas, database test
>
> I tryed to change the pg_dba.conf (trust) file but another message appears.

In pg_hba.conf, do you have the following:

local        all                                           trust
host         all         127.0.0.1     255.255.255.255     trust

Also, you need to be either root or the postgres user to edit the file.

To work with PgAccess, you will need to give the user you want to login
as SELECT permission on the pg_user table (if it's a different user than
that which created the database.)

--Chris


-- 

Chris Maj <cmaj_hat_freedomcorpse_hot_info>
0xC0051F6A
5EB8 2035 F07B 3B09 5A31  7C09 196F 4126 C005 1F6A