Recreating postgres database on a fly app

For my (elixir) (dev/demo) application I went a bit on a rampage and have changed the database structure of my app.

It would be easier for me to have a new database rather than migrating everything around, but I’m not sure how best to do this without deleting the entire fly app.

Can I just get away with deleting the database with psql and make a new one? Does fly have any special settings to the database it applies that id need to recreate?

Thanks in advance!

I recreated it a few times and usually I just delete the app and create a new one, it seems the simplest way, also because if you created/updated user roles you might need to change those as well while if you drop the app you are sure you start from 0…just remember that the app connected to the db must scale to 0 otherwise the app cancellation might fail as the db as active connections

1 Like

Thanks for getting back to me!

I have tried this previously but as my application has the same name, sometimes I believe the DNS records don’t get updated correctly as although the application says it’s running I can’t access it via the url.

If I recreate the app again it has a better chance of working, but I wasn’t sure if I was being a bit cheeky by doing this.

maybe you can wait for someone with more experience then me and see what they says

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.