Page 1 of 2
Database Back-up and Transfer
Posted:
Tue Aug 03, 2010 5:01 pm
by ttjager
I have PT installed on my desktop and laptop. If I create a database back-up file from my laptop, why can't I install that on my desktop so both versions are looking at the same data? I tried doing the back up and using the "restore" feature to bring in the new data, but it doesn't work. I guess that begs the question, how do you use a back-up file to restore a corrupted db?
Todd
Re: Database Back-up and Transfer
Posted:
Tue Aug 03, 2010 5:33 pm
by kraada
That should be working fine - take a look at the
Tutorial: Backup and Restore - where are you having trouble?
Re: Database Back-up and Transfer
Posted:
Tue Aug 03, 2010 6:21 pm
by ttjager
That worked like a charm. I was trying to do it from the Database menu and kept saying "file not found". When I used the File/Resort menu all was good.
Thanks,
Todd
Re: Database Back-up and Transfer
Posted:
Tue Aug 03, 2010 6:28 pm
by kraada
Glad to hear it
Re: Database Back-up and Transfer
Posted:
Sun Aug 22, 2010 11:28 am
by twinuno
I had my data base backed up using PGAdminIII. The backupfile waover 500 mb. I tried to then import is using PT3 restore but a file was not found. I tried to restore it throuhg PGadminIII using the resotre function but i have had no such luck restoring it. Any ideas?
Re: Database Back-up and Transfer
Posted:
Sun Aug 22, 2010 12:18 pm
by kraada
Did PGAdmin give you an error when trying to restore? If so, what did the error say?
Re: Database Back-up and Transfer
Posted:
Sun Aug 22, 2010 3:38 pm
by twinuno
PG did not give me an error. I had it running 8 hours last night and wheni woke up it said not responding. I am currently runnig it now and its been running for 4 hours. I am not sure if its acutally running and when i go to load my pt3 it now freezes.
Re: Database Back-up and Transfer
Posted:
Sun Aug 22, 2010 4:02 pm
by kraada
Large databases can take quite a while - if you look in Task Manager is CPU still being used?
Re: Database Back-up and Transfer
Posted:
Sun Aug 22, 2010 4:27 pm
by twinuno
PG_restore.exe is taking like 2 cpu randomly. Doesnt seem like anything else is taking up much cpu.
There are 3 pg_restores running in the task manager
Re: Database Back-up and Transfer
Posted:
Mon Aug 23, 2010 7:25 am
by twinuno
I have had this running for over 10 hours now and i am not sure if its working. I also tried to imoprt the hands that i played tody about 5khands and that ook over 2 hours to vaccum and cluster. Isnt that unsual since there is only 5k hands in my database.
Can i restore the database throuhg PGadmin and stil have pt3 open?