Setting up a dev/test DB
Hello. I have a live application running on supabase and now need to make some breaking changes.
I tried the DB branch approach first, but there were 100's of errors, so I switched to local hosting. I have Docker, Supabase and Stripe installed on my local machine. I start supabase and serve the edge functions, so far so good. But looking at the (local) database there are no triggers !
I instantiated the empty database from a pg_dump output via the SQL editor on the local studio, it ran with no errors.
The create for the triggers looks to have failed silently
I have set my dev environment up and the local application is connecting to the local database, and I can see that the local auth has created a user
What am I missing or doing wrong ?
I want to stick at getting the local dev cofig working for this and future projects, so help solving this problem woudl be appreaciated greatly.
Thanks in advance,
Rich from
I tried the DB branch approach first, but there were 100's of errors, so I switched to local hosting. I have Docker, Supabase and Stripe installed on my local machine. I start supabase and serve the edge functions, so far so good. But looking at the (local) database there are no triggers !
I instantiated the empty database from a pg_dump output via the SQL editor on the local studio, it ran with no errors.
The create for the triggers looks to have failed silently
I have set my dev environment up and the local application is connecting to the local database, and I can see that the local auth has created a user
What am I missing or doing wrong ?
I want to stick at getting the local dev cofig working for this and future projects, so help solving this problem woudl be appreaciated greatly.
Thanks in advance,
Rich from
