Database Back-up and Transfer

[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

[kraada]

That should be working fine - take a look at the Tutorial: Backup and Restore - where are you having trouble?

[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

[kraada]

Glad to hear it

[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?

[kraada]

Did PGAdmin give you an error when trying to restore? If so, what did the error say?

[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.

[kraada]

Large databases can take quite a while - if you look in Task Manager is CPU still being used?

[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

[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?