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:
Unsupported operations
CREATE SUBSCRIPTIONCREATE EVENT TRIGGERCOPY ... FROM PROGRAMALTER USER ... WITH SUPERUSER