Re: problem to connect - Mailing list pgsql-interfaces

From C. Maj
Subject Re: problem to connect
Date
Msg-id Pine.LNX.4.44.0304091227250.8925-100000@freebird.stanley.cup
Whole thread Raw
In response to problem to connect  ("nicolas renie" <nicolas.renie@wanadoo.fr>)
List 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



pgsql-interfaces by date:

Previous
From: Wei Weng
Date:
Subject: Re: problem to connect
Next
From: Michiel Lange
Date:
Subject: Getting to learn libpqxx