Question

Restoring backup file to local database instance

0

I have downloaded a (database) ".backup" file from the test (cloud) instance of our application. I would like to restore this data into my local instance. How do you do this? Thanks.

asked 2016-09-13

adrian allen

3 answers

Pieter van de Braak · Answer 1 · 2016-09-13

If you downloaded it from the public cloud then you have a backup file that was generated by postgres. To restore it you first need to run a postgres database locally and a pgadmin. You can find the downloads here

adrian allen · Answer 2 · 2016-09-16

Wow ... that sounds a little bit more work than I was expecting. C'est la vie I guess. Thanks.

Monique Brown · Answer 3 · 2016-11-16

You can create a new database in Postgres. Right click on the new database you created and selected Restore, it will direct you to your file explorer, select the (database) ".backup" file you downloaded and click restore, it will start to restore your database.