Staging databse
I have a staging database where the data is not testable anymore. I also have a production database where the data is good and what the actual user are interacting with. Is there a way to take a snapshot of the prod database and set that as the staging database?
3 Replies
You can use pg_dump since it's just a postgres database and you have direct access to it via the database connection string.
Do note it's bad practice to access production data and copy it down to your non-production instance. Especially if it contains sensitive data.
How would i use that?
So i have two different projects one for staging and one for production
You can do a Google search on
pg_dump and also do a search in the Supabase docs too.