SupabaseS
Supabase•4y ago
Equinox

Local development - Postgrest container keeps restarting

Hello

After playing around with the UI and starting to prototype some stuff in production (I got into it too quickly 😬) I decided to follow this tutorial https://supabase.com/docs/guides/cli/cicd-workflow to setup a proper dev environment,

I ran all the commands up to supabase db remote commit which created the migration but then as soon as I want to startup my local supabase again with supabase start it keeps on throwing errors

I have also tried moving the migration file out of the folder and starting the database then putting the file back and running
supabase db reset
but it doesn't work either

When I setup my supabase project I used the Next.js subscription starter so I have some enum types already created that I'm not currently using e.g: pricing_type, I tried deleting those from the UI and running a migration again but I cannot because of errors with the shadow database

I also tried removing those specific enum types from the migration but then the migration throws some other error.

I have also tried re-running everything with the latest update of the Supabase CLI but it didn't change anything
unknown.png
How to deploy Supabase schema changes with a CI / CD pipeline.
Was this page helpful?