On 04/15/2013 07:29 PM, Carlos Mennens wrote:
I dropped both roles (Carlos & DBA) from the database and I will show
you exactly what I'm doing:
Now I login as 'carlos':
carlos@debian:~$ psql -d postgres
Password:
psql (9.1.9)
Type "help" for help.
postgres=>
but...
To add to my post from l
On 04/15/2013 07:29 PM, Carlos Mennens wrote:
I dropped both roles (Carlos & DBA) from the database and I will show
you exactly what I'm doing:
postgres=# \du
List of roles
Role name | Attributes | Member of
---+
I dropped both roles (Carlos & DBA) from the database and I will show
you exactly what I'm doing:
postgres=# \du
List of roles
Role name | Attributes | Member of
---++-
Adrian Klaver writes:
> On 04/15/2013 09:10 AM, Carlos Mennens wrote:
>> That's the end of 'carlos' being able to login. What am I doing wrong?
> Unfortunately I do not have a 9.1.x instance handy. I tried the above on
> 9.0.x and everything worked.
Works for me on 9.1.9, too. Perhaps there is
On 04/15/2013 09:10 AM, Carlos Mennens wrote:
I'm doing this all in psql.
Example:
CREATE ROLE carlos LOGIN CREATEDB CREATE ROLE REPLICATION;
I going to assume you actually did:
CREATE ROLE carlos LOGIN CREATEDB CREATEROLE REPLICATION;
otherwise it would fail on the second CREATE ROLE.
T
I'm doing this all in psql.
Example:
CREATE ROLE carlos LOGIN CREATEDB CREATE ROLE REPLICATION;
Then set password \password carlos
Now I create the ROLE:
CREATE ROLE dba NOLOGIN;
So now I have two roles:
-carlos = user role
-dba = group role
I can login just fine as 'carlos' now with no aut
On Mon, Apr 15, 2013 at 7:30 AM, Carlos Mennens wrote:
> I can't understand what is going on with my PostgreSQL server. For
> some reason after I GRANT my role 'carlos' to the 'dba' group role, I
> lose the ability to login. I've reset the password over and over for
> 'carlos' and even reversing t
