[Answered ]-Postgresql unable to alter role to superuser

by

1👍

I tricked myself into thinking I was actually user postgres. @iklinac and @Frank N Stein pointed out in the comments that I had to su myself to postgres.

(catmaid) [catmaid@sonic django]$ su - postgres
-bash-4.2$ psql -U postgres
psql (10.10)
Type "help" for help.

postgres=# \du
                                   List of roles
 Role name |                         Attributes                         | Member of
-----------+------------------------------------------------------------+-----------
 catmaid   |                                                            | {}
 postgres  | Superuser, Create role, Create DB, Replication, Bypass RLS | {}

postgres=# alter role catmaid superuser;
ALTER ROLE
postgres=# \du
                                   List of roles
 Role name |                         Attributes                         | Member of
-----------+------------------------------------------------------------+-----------
 catmaid   | Superuser                                                  | {}
 postgres  | Superuser, Create role, Create DB, Replication, Bypass RLS | {}

So credit goes to them, thanks!

👤lanery

Leave a comment