On Mon, 2003-12-29 at 22:19, davadie philippe wrote:
> Hi everybody !
> Excuse my poor english, since I'm french, and the dummy question I will
> ask, since I'm new using pgaccess and postgresql.
> I have successfully installed pgaccess, but when I try to connect to
> the databses I have created, I get the message :
> Error trying to connect to database 'garde' on host
> PostgreSQL error message : Connection to database failed
> FATAL : IDENT authentication failed for user "philippe"
> User philippe has been created by superuser postgres and is granted for
> this database.
Access control is governed by the file $PGDATA/pg_hba.conf. The
relevant line in that file is specifying "ident sameuser"
authentication, which means that it expects the postgresql user to have
the same name as the unix user; if your unix login were "philippe" it
Create a postgresql user with the same name as your login and try again.
Oliver Elphick Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight, UK http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
"Give to him that asketh thee, and from him that would
borrow of thee turn not away."
In response to
pgsql-interfaces by date
|Next:||From: Phil Rivard||Date: 2003-12-30 07:48:47|
|Subject: Need help with nmake /f win32.mak|
|Previous:||From: davadie philippe||Date: 2003-12-29 22:19:52|
|Subject: trouble with pgaccess|