Prepare for the PgBouncer and IPv4 deprecations on 26th January 2024

Database

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 ROLE ... WITH REPLICATION
  • CREATE SUBSCRIPTION
  • CREATE EVENT TRIGGER
  • COPY ... FROM PROGRAM
  • ALTER USER ... WITH SUPERUSER