| 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: | Whole Thread | Raw Message | 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 |