Restoring database via postgreSQL 9.3???

[steel108]

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]

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/questio...store+Database

[steel108]

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/questio...store+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]

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]

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



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



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



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

[Patvs]

We don't support SQL 9.1 beta

Use 8.4.8 or 9.0.4 instead.

[steel108]

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]

Nevermind, I found it on cnet.com Hopefully this will work

[Chumplestultz]

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:


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]

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.