```\password postgres``` < is this possible? I'm g...
# help
m
Copy code
\password postgres
< is this possible? I'm getting
Copy code
ERROR:  42501: must be superuser to alter replication roles or change replication attribute
when I try
s
You would need to elevate the postgres user to a superuser before you can perform certain actions with it
m
ahh I see
Copy code
\du
Copy code
List of roles
       Role name        │                         Attributes                         │                    Member of                     
════════════════════════╪════════════════════════════════════════════════════════════╪══════════════════════════════════════════════════
 anon                   │ No inheritance, Cannot login                               │ {}
 authenticated          │ No inheritance, Cannot login                               │ {}
 authenticator          │ No inheritance                                             │ {anon,authenticated,service_role,supabase_admin}
 dashboard_user         │ Create role, Create DB, Cannot login, Replication          │ {}
 pgbouncer              │                                                            │ {}
 postgres               │ Create role, Create DB, Replication, Bypass RLS            │ {}
 service_role           │ No inheritance, Cannot login, Bypass RLS                   │ {}
 supabase_admin         │ Superuser, Create role, Create DB, Replication, Bypass RLS │ {}
 supabase_auth_admin    │ No inheritance, Create role                                │ {}
 supabase_storage_admin │ No inheritance, Create role                                │ {}
s
Also there is a solution on how to elevate the postgres user to superuser
2 Views