PDA

View Full Version : Reinstall postgres 8.2



mack848
01-31-2010, 03:24 PM
I fried my motherboard, so now need to reinstall HM and Postgres. I was using postgres 8.2, so need to reinstall this so I can recover my dbases.

Could you please point me in the direction of help to install 8.2? All I can find in the HM FAQ is info about 8.4 and I have not even come close to working it out from the postgresql website!

Many thanks
Mack

fozzy71
01-31-2010, 07:10 PM
Please update to the latest beta - http://www.holdemmanager.com/downloads/HmBetaUpdate.exe

For reinstalling SQL to the same DB, follow these steps:

1) Uninstall PostgreSQL from the Windows Control Panel.
2) If you are moving the DB to a different drive/partition, manually cut or copy the \Postgresql\8.x\data directory to it's new location.
3) run the command - start > programs > accessories > command prompt > right-click > run as administrator

net user postgres /delete
4) reboot.

You can skip all those steps if you have never installed PostgreSQL on the new PC.


5) Install the same version of PostgreSQL as your current DB using these instructions - http://faq.holdemmanager.com/questions/71/Reinstall+PostgreSQL+Preserving+Old+Database

You can download an 8.2 version from here:

http://www.postgresql.org/ftp/binary/

To test this process I downloaded this version to install.

http://www.postgresql.org/ftp/binary/v8.2.15/win32/

postgresql-8.2.15-1.zip

Unzip that to a new folder and run the postgresql-8.2.msi file from the new folder.

6) If you have moved/installed your DB to a non-default location, please make sure to change the 'Data Directory' path during the installation.