Supabase error: permission denied to create extension "moddatetime"

Question

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?

kjhughes · Accepted Answer · 2025-03-16 15:10:06Z

0

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:

supabase.com/dashboard/project/_/settings/infrastructure

answered Mar 16 at 15:10

kjhughes

113k31 gold badges198 silver badges276 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Supabase error: permission denied to create extension "moddatetime"

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related