dbTalk Databases Forums  

Re: Postgresql Novice problem

comp.databases.postgresql.novice comp.databases.postgresql.novice


Discuss Re: Postgresql Novice problem in the comp.databases.postgresql.novice forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Tom Lane
 
Posts: n/a

Default Re: Postgresql Novice problem - 05-28-2004 , 11:41 AM






Alain-Serge Nagni <akenaton (AT) freesurf (DOT) ch> writes:
Quote:
But when a I try to use the Datamanager to get access to the database, it's
looks impossible. I got an error message: [unixODBC]FATAL: IDENT
authentication failed for user "newuser".
If you're using IDENT authentication then you can't log in under a
Postgres username that's different from your real (Unix) username.

(At least, not without fooling around with creating an ident user map,
which is probably more trouble than you want to go to.)

I'd suggest setting up your pg_hba.conf file so that this connection
is checked using passwords instead of IDENT.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html



Reply With Quote
  #2  
Old   
Alain-Serge Nagni
 
Posts: n/a

Default Re: Postgresql Novice problem - 05-28-2004 , 03:29 PM






On Friday 28 May 2004 18.41, Tom Lane wrote:
Quote:
Alain-Serge Nagni <akenaton (AT) freesurf (DOT) ch> writes:
But when a I try to use the Datamanager to get access to the database,
it's looks impossible. I got an error message: [unixODBC]FATAL: IDENT
authentication failed for user "newuser".

If you're using IDENT authentication then you can't log in under a
Postgres username that's different from your real (Unix) username.

(At least, not without fooling around with creating an ident user map,
which is probably more trouble than you want to go to.)

I'd suggest setting up your pg_hba.conf file so that this connection
is checked using passwords instead of IDENT.

regards, tom lane
Hi,
********First of all thanks for your help.

As you suggested, I commented in the file "pg_hba.conf.sample" the following
line:
********local *all * * all * * ident * sameuser

and added the line this line:

********local * all * * all * * password



I have a new error message which is: [unixODBC]Could not connect to the
server; Could not connect to remote socket.
********I have the impression that I did not installed all the PostgreSQL
packages?

Best regards,
Alain-Serge

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.