Delete and restore data to postgres database

bodgerbarnett
HOBBY

3 days ago

I'm in the process of moving my project from an old service to Railway. I've already imported my data to Railway so I could do some testing but now I need to delete the Railway data and re-import a new dump that I've got which contains the latest data from the live database.

Is it best to delete the entire service from Railway and start again? Or is there a way I can delete the entire database and pg_restore with a fresh backup?

Solved

3 Replies

3 days ago

Hey, you could try to wipe the volume of your Postgres database (Volume > Settings > Wipe volume). Alternatively, you can also just delete the Postgres service plus its volume and deploy a new Postgres database.


uxuz

Hey, you could try to wipe the volume of your Postgres database (Volume > Settings > Wipe volume). Alternatively, you can also just delete the Postgres service plus its volume and deploy a new Postgres database.

bodgerbarnett
HOBBY

3 days ago

Great, it looks the Wipe volume was the way to go! Thanks!


bodgerbarnett

Great, it looks the Wipe volume was the way to go! Thanks!

3 days ago

You are welcome!


Status changed to Solved uxuz 3 days ago