From: | Manuel Rivero <trikitrok(at)gmail(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Doubt with role creation |
Date: | 2010-10-18 09:24:53 |
Message-ID: | AANLkTint=YDNb7GCY=43rT9dBsNuT_=Y4ewiDchU-Pyg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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?
Thanks in advance.
Best regards,
M
From | Date | Subject | |
---|---|---|---|
Next Message | Thom Brown | 2010-10-18 09:38:23 | Re: Doubt with role creation |
Previous Message | Lukasz Brodziak | 2010-10-18 05:12:03 | Re: Overriding local encoding defaults |