Skip site navigation (1) Skip section navigation (2)

Re: problem to connect

From: Wei Weng <wweng(at)kencast(dot)com>
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:40:36
Message-ID: 3E944D04.9000301@kencast.com (view raw or flat)
Thread:
Lists: pgsql-interfaces
The default behavior for postgres uses IDENT. So you need to log on as 
user nicolas to be able to use postgres user nicolas. You can look at 
/var/lib/pgsql/data/pg_hba.conf for configuration detail.

Wei

nicolas renie wrote:

> Hye
>  
> I use linux mandrack 9.0 and postgres 7.2
> I can't connect to postgresql (even in local) if I use a postgres user.
> I don't know what to do.
> I've started the daemon (root# etc/rc.d/init.d/postgresql start)
> logged under postgres I made a user (createuser nico) and a 
> database(createdb test)
> But I can't access to this database if I am logged under an other user.
> (su Eddy or anathor linux user)
>  
> When I try: psql test -h localhost -U nicolas I have the message :
> IDENT authentification failed for user nicolas.
> I can see the same message when I try to connect whith pgaccess.
>  
> If I try to start pgaccess with: "pgaccess test", the main PgAccess 
> window
>  comes up, (empty) but there is an error message box in front of it. 
> The message is:
>     
>  "Error trying to connect to database "test" on host localhost.
>    is the postmaster running (with -i) at
>     'localhost' and accepting connections on TCP/IP port '5432'?"
>  
> Therefore I stopped postgresql etc/rc.d/init.d/postgresql stop
> I started it logged under postgres with options ($ postmaster -h 
> localhost -i )
>  
> 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.
>  
> I would like to know what to do especially to use pgaccess
>  
>  
> Please, help me !
> regards
>  
> Nicolas RENIE
>  
>  


In response to

Responses

pgsql-interfaces by date

Next:From: C. MajDate: 2003-04-09 16:42:53
Subject: Re: problem to connect
Previous:From: Tom LaneDate: 2003-04-09 15:06:33
Subject: Re: column type/typmod for domains in backend protocol

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group