PDA

View Full Version : Reinstalling postgresql



craig1129
08-31-2009, 03:58 AM
Hi I am trying to move my HM database to an external hard drive. I read somewhere that since I am changing from postgresql 8.2 to 8.3, I will need to export/reimport all hands.

I am currently trying to install postgresql on the external but at one point it said the port number was in use so I figured I needed to first delete my current postgresql folder. However, when I try to do this I keep getting a popup that says you need permission to do this and I can't get past this point. I tried turning UAC off but that didn't work. Thoughts?

fozzy71
08-31-2009, 09:47 AM
The easiest solution is to just pick a different port number such as 5433, or 5434.

UAC should always be off.

If you have Vista, please verify that UAC is still off. - http://www.holdemmanager.net/faq/afmmain.aspx?faqid=73. If it is on, please turn it off and reboot.


Add exceptions to the windows firewall, even if it is off. If you have a 3rd party firewall, uninstall it completely before installing HM/SQL - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=171

craig1129
08-31-2009, 04:40 PM
Ok I now have PostgreSQL deleted but am having a problem with the install.

When I get to the database cluster menu, type in the password, and hit ok, I get a data directory error that says: "The PostgreSQL data directory must be on a NTFS formatted volume. If you wish to install the data directory on another type of partition, you must initialize the database cluster manually by running initdb.exe."


Edit: I just found this thread:

http://www.holdemmanager.net/forum/showthread.php?p=71178&highlight=database+directory+error#post71178

but it seems that is for people with XP. I have Vista so I'm not sure why I'm getting this error message.

Should I still do this even though it says for XP:

http://www.aumha.org/win5/a/ntfscvt.php

netsrak
08-31-2009, 04:50 PM
Check your filesystem, if its FAT convert it...

http://www.computerhope.com/issues/ch000713.htm

craig1129
08-31-2009, 05:26 PM
Ok I need to convert and I'm trying to follow the directions I posted. When I open up Bootit it says, "It appears this system has no floppy drive.."

Then I get to a menu that says "Build a bootable ISO Image File for CD" and I click enter. It then says the ISO image file is created and I go where the file is located and open it. When I open it Roxio creator opens up and its instructing me to burn image to disc.

I don't have a blank disc but can get some. I just wanted to make sure I'm performing this correctly as I have no understanding of what is going on since the directions in the link are for a floppy.

craig1129
08-31-2009, 11:10 PM
Ok I had no idea what I was doing but I finally got it. Thanks for the help gentlemen.