https://supabase.com/ logo
#help
Title
# help
e

ericchen

06/08/2022, 7:09 PM
Hi, I've just pushed my first schema changes from my local Supabase instance (development) to a Supabase-hosted staging instance. That worked fine. But now, I'm wondering what the process is to promote from staging --> production? Seems like the steps I followed are only valid for linking and updating one Supabase instance (staging). What is the recommended process for then promoting schema changes from staging to production?
n

Needle

06/08/2022, 7:09 PM
Hello @ericchen! This thread has been automatically created from your message in #843999948717555735 a few seconds ago. We have already mentioned the @User so that they can see your message and help you as soon as possible! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ``...`` menu) and select "Leave Thread" to unsubscribe from future updates. Want to change the title? Use the ``/title`` command! We have solved your problem? Click the button below to archive it.
o

Olyno

06/09/2022, 7:35 AM
Hi to move to production, the best way would be to migrate your local Postgres database to the production one. You can easily do it using ``pg_dump``. Unfortunately, you can't move your settings, so you will need to change them on the production side @ericchen
e

ericchen

06/09/2022, 7:36 AM
So you don't recommend doing it via migrations and supabase db commands, right?
o

Olyno

06/09/2022, 12:51 PM
Yes it should be the right way
e

ericchen

06/09/2022, 6:44 PM
Thank you!