PDA

View Full Version : Unable to restore database



kidpokeher
09-01-2008, 02:49 AM
The database was backed up using 1.06.01. I tried to restore it into a newly created 1.06.02 database using PGAdmin in case that's the problem.

Otherwise it's a long list of "unable to create..." constraint messages, unable to execute query: relation xxx already exists messages, 103 total that returned exit code 1. I'll post the errors if you want but it's pretty long.

Fortunately I have the original hands so I can import them again, but what's the trick to restoring a backup?

fabio
09-01-2008, 06:15 AM
Please try this:

get to the command prompt.
enter psql -U postgres -f c:\dbbackup.sql postgres (or change the filename to whatever makes sense)

Note: edit c:\dbbackup.sql to the path of your backup

kidpokeher
09-01-2008, 01:42 PM
Strange thing is, in spite of getting all these error messages when attempting to restore thru PGAdmin, it does appear to have worked. I'm getting stats on players and the HUD stats and hand histories are showing up. Weird.

fabio
09-01-2008, 02:01 PM
Export all HHs of the database just in case something gets broken.