PDA

View Full Version : reinstalling postgresql



bballwiz
04-17-2010, 01:33 PM
I'm trying to reinstall postgresql on my other bigger hard drive to save space. I uninstalled it, but am now having problems reinstalling it. I remember following a helpful pdf that showed me everything I needed to do. I can't find where it is now, can you please tell me where to go to find it? Thanks

a.k.a.Also
04-17-2010, 01:55 PM
FAQ - Hold'em Manager Poker Tracking Software :: Move Database to Another Hard Drive or Partition (http://faq.holdemmanager.com/questions/368/Move+Database+to+Another+Hard+Drive+or+Partition)

bballwiz
04-17-2010, 02:02 PM
ya wish I saw this before I deleted everything. It's too late, I already uninstalled it. I don't know where to go from here

fozzy71
04-17-2010, 02:41 PM
Are you trying to reinstall the same database (\data folder)?

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 - FAQ - Hold'em Manager Poker Tracking Software :: Reinstall PostgreSQL Preserving Old Database (http://faq.holdemmanager.com/questions/71/Reinstall+PostgreSQL+Preserving+Old+Database)
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.'


If you are installing a new/empty DB to reimport everything:


1) Uninstall PostgreSQL from the Windows Control Panel.
2) run the command - start > programs > accessories > command prompt > right-click > run as administrator

net user postgres /delete
4) reboot.
5) Install PostgreSQL from this link - http://www.holdemmanager.com/downloads/postgresql_8.4.1.1.exe

Make sure you pick an alternate Data Directory during installation, instead of the default path.

bballwiz
04-17-2010, 03:32 PM
Think I got it now thanks, just unfortunately deleted all my data so need to redo everything and get my hh's all over again