From: Scott Marlowe <scott.marlowe@gmail.com>
To: Judith <jaltamirano@correolux.com.mx>
Cc: pgsql-sql@postgresql.org
Subject: Re: Authentification failed
Date: Wed, 1 Aug 2007 19:52:58 -0500
Message-ID: <dcc563d10708011752r6f0e8775i98a681c123b72b1d@mail.gmail.com> (raw)
In-Reply-To: <46B0F8C6.3070601@correolux.com.mx>
References: <46B0F8C6.3070601@correolux.com.mx>
On 8/1/07, Judith <jaltamirano@correolux.com.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?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: scott.marlowe@gmail.com, jaltamirano@correolux.com.mx
Subject: Re: Authentification failed
In-Reply-To: <dcc563d10708011752r6f0e8775i98a681c123b72b1d@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox