February 17th, 2014, 09:39 AM
Failure restoring a postgresql 9.1 database
I have a backup of my database as a .backup file that I made via pgAdminIII. The backed up database has been accidentally deleted so I have to use this .backup file to restore it. I am only praying that all the settings were correct while doing the original back up.
After creating the new test database I right click on it and choose restore. I change nothing at all except choose the .backup file. After doing so the "Restore" button is grayed out and wont allow me to select it.
I am running postgreSQL 9.1
What am I doing wrong? Thanks in advance!