Re: Authentification failed

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: Judith <jaltamirano(at)correolux(dot)com(dot)mx>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Authentification failed
Date: 2007-08-02 00:52:58
Message-ID: dcc563d10708011752r6f0e8775i98a681c123b72b1d@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On 8/1/07, Judith <jaltamirano(at)correolux(dot)com(dot)mx> wrote:
> Hello everybody!!
>
> I'm trying in SUSE to connect to a postgres db and this is the error:
>
> Ident Authentification failed for user <<root>>
>
> I'm already created the user with createuser root, but the error
> persist, I would aprecciate some help, thanks in advanced

you need to change auth methods in your pg_hba.conf file:

http://www.postgresql.org/docs/8.2/static/auth-pg-hba-conf.html

basically identd means that you are who you are on the unix box. no
-U flag, you can't log in as someone else.

note that a "root" user is a bit of a mysqlism. The postgres user is
the equivalent in postgresql. might you sudo su - postgres and try to
connect?

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Luiz K. Matsumura 2007-08-02 01:46:00 Re: Alternative to INTERSECT
Previous Message chester c young 2007-08-02 00:48:15 Re: Authentification failed