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?
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 |