Re: Postgresql Novice problem - Mailing list pgsql-novice

From Alain-Serge Nagni
Subject Re: Postgresql Novice problem
Date
Msg-id 200405282229.37803.akenaton@freesurf.ch
Whole thread Raw
In response to Re: Postgresql Novice problem  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
On Friday 28 May 2004 18.41, Tom Lane wrote:
> Alain-Serge Nagni <akenaton@freesurf.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

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Postgresql Novice problem
Next
From: Tom Lane
Date:
Subject: Re: Error msgs from PostgreSQL server : specified item offset is too large, failed to add item to the page