PDA

View Full Version : Restoring database via postgreSQL 9.3???



steel108
08-10-2011, 07:23 PM
I made a backup of my HEM using postgreSQL 9.3 (couldn't get it to work within HEM).

I can't figure out how to restore it. The FAQ shows how to do it for a earlier version of postgreSQL and the interface has completely changed.

netsrak
08-11-2011, 04:25 AM
Our backup/restore tool doesn't support postgresql 9.x.

You need to create and restore a backup via pgadmin instead. http://faq.holdemmanager.com/questions/72/Backup+%26+Restore+Database

steel108
08-11-2011, 04:39 AM
Our backup/restore tool doesn't support postgresql 9.x.

You need to create and restore a backup via pgadmin instead. http://faq.holdemmanager.com/questions/72/Backup+%26+Restore+Database

You repeated everything I said????

The FAQ shows how to restore from an earlier version of postgreSQL. 9.3 interface is different.

I already cacked up through pgadmin need help with restore part.

netsrak
08-11-2011, 08:23 AM
I thought you were using our integrated backup/restore tool.

We have no experience with Postgresql 9.x and this is not officially supported.
Do you get an error message or what is happening?

steel108
08-11-2011, 11:56 AM
When following the instructions for an earlier version of postgreSQL (right click -> new database), the option isn't there:

http://img593.imageshack.us/img593/7917/newdatabase.png (http://imageshack.us/photo/my-images/593/newdatabase.png/)

After selecting a database, I have the option to restore it:

http://img600.imageshack.us/img600/9451/restore.png (http://imageshack.us/photo/my-images/600/restore.png/)

I have no clue what to input, so I guessed:

http://img835.imageshack.us/img835/1316/setuph.png (http://imageshack.us/photo/my-images/835/setuph.png/)

This is the error I get. I have tried a few different options (reason why there are different error types).

http://img577.imageshack.us/img577/10/errorar.png (http://imageshack.us/photo/my-images/577/errorar.png/)

Patvs
08-11-2011, 06:19 PM
We don't support SQL 9.1 beta

Use 8.4.8 or 9.0.4 instead.

steel108
08-11-2011, 09:15 PM
Where can I download an older version (9.0.4)? Can I go back from 9.1 to 9.0.4?

I don't even need the actual database, I just want to get my notes.

steel108
08-11-2011, 09:16 PM
Nevermind, I found it on cnet.com Hopefully this will work

Chumplestultz
10-21-2011, 10:04 PM
I'm having what looks like the exact same problem as OP. I backed up my database using pgAdminIII but now when I try to restore the database I am greeted with the exact same screen:
http://img600.imageshack.us/img600/9451/restore.png (http://imageshack.us/photo/my-images/600/restore.png/)

And the "restore" button is always greyed out, it never becomes an available option. If I start clicking the different drop down menus i get the same error as OP about input file not being valid archive.

I'm using PostgreSQL 9 (version 1.14.0) so obviously this is the issue but now I'm just wondering what my options are. Can I install an older version of SQL and restore the database or will I have to somehow transfer my existing database to an older version of SQL, back up from there, and then restore. If this is possible how do I go about doing it?

I don't have a ton of custom reports or notes so would it be easier to just copy all my archived HHs, import into new computer, and then configure the HUD again?

netsrak
10-22-2011, 05:33 AM
Both options are possible: uninstall postgresql 9.x, install postgresql 8.4 and restore the database or create a new database with your current postgresql installation and import all your hands from the archive. I think the 2nd solution is the better one.