supabasesupabase-database

Supabase error: permission denied to create extension "moddatetime"

While trying to create a local supabase dev environment,

supabase start

is failing with

Seeding globals from roles.sql...
Applying migration 20250315203000_remote_schema.sql...
Stopping containers...
ERROR: permission denied to create extension "moddatetime" (SQLSTATE 42501)
At statement 12:                                                           
CREATE EXTENSION IF NOT EXISTS "moddatetime" WITH SCHEMA "extensions"      
Try rerunning the command with --debug to troubleshoot the error.

How can I get past this?

Solution

  • Upgrading the remote supabase database version resolved the problem without having to engage in more complicated problems solving regarding extension compatibility or local privileges for installing/updating extensions.

    Go to the Infrastructure page of your dashboard to upgrade: