PDA

View Full Version : restoring a DB



runhot
01-12-2010, 03:51 PM
i have a few .backup files for database backups that i want to restore.

i have read the instructions here several times:http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=101

but when i click ok in step 8 on this page:
http://208.109.95.123/faq/afmmain.aspx?faqid=12

pgAdminIII just hangs indefinetely, i cant cancel the restore or anything.

the .backup file is only 800megs, so i dont think it should take like a full day to restore it or anything.

whats the deal here?

fwiw, when i created the .backup files, i followed the instructions in the FAQ here on this site..


thanks for your help.

fozzy71
01-12-2010, 04:34 PM
Did you make sure to change the encoding of your new DB to SQL ASCII from UTF, before restoring it? Are you sure you are using the same version of postgresql?

runhot
01-12-2010, 05:31 PM
Did you make sure to change the encoding of your new DB to SQL ASCII from UTF, before restoring it? Are you sure you are using the same version of postgresql?

it appears as tho it was just taking a very long time for a not so big DB...

i left it be for a while, left the house, came back, and i got it working.

thanks.