Re: Doubt with role creation

On 18 October 2010 10:24, Manuel Rivero <trikitrok(at)gmail(dot)com> wrote:
> Hi
>
> I'm trying  to create a new role doing:
> # CREATE ROLE db_admin WITH CREATEDB CREATEROLE CREATEUSER PASSWORD
> 'password';
> CREATE ROLE
>
> If I check the roles, the new one is there:
> postgres=# Select rolname from pg_roles where rolname = 'db_admin';
> rolname
> ---------------
> pele_db_admin
> (1 fila)
>
> The problem is that when I try to enter psql with this user I get the
> following:
>
> postgres(at)linux> psql -U pele_db_admin -W
> Password for user pele_db_admin:
> psql: FATAL:  la autentificación Ident falló para el usuario «pele_db_admin»
>
> which translated is: psql: FATAL:  Ident authentication failed for user
> «pele_db_admin»
>
> Why is this happening and how could I avoid it?
>
> May be users and roles are not the same and I must create a user called
> pele_db_admin?

An "ident" authentication failure is down to your pg_hba.conf file
configuration. It means it's probably trying to match the user you're
running psql as with the user credentials you're trying to log in
with. Rather than use ident, you'll either want trust (which will not
require a password and I don't recommend), or md5. You may wish to
post the records from pg_hba.conf here if you still can't get it
working.

Regards

Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935