PDA

View Full Version : Rescue PostgreSQL-Base after PC-Crash



EiQ
01-09-2010, 06:08 AM
Hello, i have following Problem:

I had one PC (PC1) with a HEM - Postgresql-Database installed, witch worked fine. It was installed under c:\programme\postgresql\8.3. The OS was Win XP.

But now the PC got Hardware-crashed (Mainboard and CPU), and so i installed HEM on another PC (PC2) with Vista.

Postgresql i installed to c:\programme (x86)\postgresql\8.3
The Harddrive of PC1 i plugged in PC2, so here i have the old Postgresql-Folder on Drive e:\programme\postgresql

How do i get the Database from PC1, witch now is in Drive E, to work on PC2?
Just to copy the Database-Files to the new folder doesnt work.

Can you help me?

Thanks!

netsrak
01-09-2010, 07:48 AM
You need to copy the postgresq\8.x\data folder to the new computer BEFORE you install postgresql:
http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=177

And it only works with the same Postgresql version

EiQ
01-09-2010, 08:01 AM
You need to copy the postgresq\8.x\data folder to the new computer BEFORE you install postgresql:
http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=177

And it only works with the same Postgresql version

so i have to create the Directory "c:\programs\postgresql\8.3\data" BEFORE installing and then install an deactivate "init DB Cluster" ?

EiQ
01-09-2010, 08:07 AM
so i have to create the Directory "c:\programs\postgresql\8.3\data" BEFORE installing and then install an deactivate "init DB Cluster" ?

Thanks! It really works! I thank you a lot!