Roles, superuser access and unsupported operations
Supabase provides the default
postgres role to all instances deployed. Superuser access is not given as it allows destructive operations to be performed on the database.
To ensure you are not impacted by this, additional privileges are granted to the
postgres user to allow it to run some operations that are normally restricted to superusers.
However, this does mean that some operations, that typically require
superuser privileges, are not available on Supabase. These are documented below:
CREATE ROLE ... WITH REPLICATION
CREATE EVENT TRIGGER
COPY ... FROM PROGRAM
ALTER USER ... WITH SUPERUSER