PDA

View Full Version : PostgreSQL problem.



ScreenBeat
01-01-2010, 04:34 PM
Hello,
I have big problem with my databases. I have to delete old system, and install a new one (XP), system was on C:, postgresql folder was on D: + 20 gb of DATA. Now I just installed postgresql again in this old postgresql folder on D:, but installer don`t see database cluster so i have to create a new one, but when I started Holdem Manager i get message : database 'xxx' doesn`t exist. 'xxx' is old database from previous system. How to get this database working again with new postgressql ?

fozzy71
01-01-2010, 07:05 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.
5) Install the same version of PostgreSQL as your current DB using these instructions - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=177
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.