How to reset a cloud Postgres DB as if it was just created before each demo deployment?
0
votes
1
answer
76
views
I was using Heroku for projects in development.
Heroku has a great option to reset Postgres DB: https://devcenter.heroku.com/articles/managing-heroku-postgres-using-cli#pg-reset .
Now I'm using other cloud services for Postgres hosting which don't have such feature.
Since during the development phases the DB can change considerably I would like to automatically reset the DB during each deployment before being filled again by my new code.
How do I reset the DB (as if it was just created) if the hosting doesn't provide me a CLI/API to do it but only a web interface and of course the connection string?
Asked by Fred Hors
(101 rep)
Dec 23, 2022, 12:00 AM
Last activity: Dec 23, 2022, 03:13 AM
Last activity: Dec 23, 2022, 03:13 AM