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

Re: Postgresql Novice problem

From: Alain-Serge Nagni <akenaton(at)freesurf(dot)ch>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Postgresql Novice problem
Date: 2004-05-28 20:29:37
Message-ID: 200405282229.37803.akenaton@freesurf.ch (view raw or flat)
Thread:
Lists: pgsql-novice
On Friday 28 May 2004 18.41, Tom Lane wrote:
> 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

In response to

pgsql-novice by date

Next:From: Paul ThomasDate: 2004-05-29 08:58:56
Subject: Re: PostgreSQL delete the blank in the end of the String automatically. how can I avoid it?
Previous:From: Jeff EckermannDate: 2004-05-28 19:46:06
Subject: Re: PostgreSQL delete the blank in the end of the String automatically. how can I avoid it?

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