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?
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?
Share Improve this question edited Mar 16 at 15:11 jonrsharpe 122k30 gold badges268 silver badges476 bronze badges asked Mar 16 at 15:10 kjhugheskjhughes 112k31 gold badges196 silver badges268 bronze badges1 Answer
Reset to default 0Upgrading 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:
- supabase/dashboard/project/_/settings/infrastructure