| From: | "C(dot) Maj" <cmaj(at)freedomcorpse(dot)info> |
|---|---|
| To: | nicolas renie <nicolas(dot)renie(at)wanadoo(dot)fr> |
| Cc: | pgsql-interfaces(at)postgresql(dot)org |
| Subject: | Re: problem to connect |
| Date: | 2003-04-09 16:42:53 |
| Message-ID: | Pine.LNX.4.44.0304091227250.8925-100000@freebird.stanley.cup |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-interfaces |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michiel Lange | 2003-04-09 22:30:40 | Getting to learn libpqxx |
| Previous Message | Wei Weng | 2003-04-09 16:40:36 | Re: problem to connect |