postgres problem

[jjmcjohnson]

Installing hem on a new laptop and I messed up the installation of postgres and I don't know how to correct it...

in the installation faq is says to fill out the form as follows:

http://www.holdemmanager.net/images/install_guides/pginst_05.jpg
http://i13.photobucket.com/albums/a282/jjmcjohnson/Capture1.jpg
but i left the bits which is said to change as a default so i uninstalled postgres and tried reinstalling it again but when i change the thing and try to continue it gives me the following error message

http://i13.photobucket.com/albums/a282/jjmcjohnson/Capture2.jpg

[netsrak]

You can delete the given data folder (from a previous postgresql installation) and try again or you uncheck the option "Initialize database cluster" and this data folder will be used again.

[jjmcjohnson]

You can delete the given data folder (from a previous postgresql installation) and try again or you uncheck the option "Initialize database cluster" and this data folder will be used again.

how do i find this folder? treid searvhing for it and i can't find it??

[jjmcjohnson]

You can delete the given data folder (from a previous postgresql installation) and try again or you uncheck the option "Initialize database cluster" and this data folder will be used again.

also if i uncheck initialize databse cluster then im sure i can't change the settings on how the databse is coded??

[netsrak]

The folder is in the postgresql installation folder, usually c:\program files\postgresql\8.3\data.

For changing the coding you should reinstall it.

[hus444]

I did the same thing, I didn't see the instruction page and went with all the defaults. I haven't tried to use it yet. Should I uninstall and reinstall?

[fozzy71]

Try it. If you have problems:


Please update to the latest beta - http://www.holdemmanager.com/downloads/HmBetaUpdate.exe

Vista: Turn off UAC - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=73

Turn off Windows Firewall for installing HM and PostgreSQL. Once you get those installed you can add exceptions to the firewall. If you have a 3rd party firewall, uninstall it completely before installing HM/SQL - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=171

For uninstalling SQL please follow these steps:

1) Uninstall PostgreSQL from the Windows Control Panel.
2) manually delete or rename the Program Files\Postgresql folders
3) run the command - start > run > cmd >

net user postgres /delete
4) reboot.
5) Install PostgreSQL 8.4, with your firewall uninstalled or turned off if windows firewall - http://www.enterprisedb.com/products/pgdownload.do#windows

[hus444]

Thanks, I will try to uninstall it. I know how to delete it from the control panel, I don't know how to do steps 2 and 3. I have vista 64bit, could you please explain how to find those folders to manually delete, also step 4 has me completely clueless, I know where the start button is but that's it.

Should I try it first without steps 2 and 3 just from the control panel then reinstall?

[fozzy71]

Thanks, I will try to uninstall it. I know how to delete it from the control panel, I don't know how to do steps 2 and 3. I have vista 64bit, could you please explain how to find those folders to manually delete, also step 4 has me completely clueless, I know where the start button is but that's it.

Should I try it first without steps 2 and 3 just from the control panel then reinstall?

Those are the most important steps.




.....
2) manually delete or rename the Program Files\Postgresql folders

Start > Computer > Browse to C:\program files (x86) and delete the \postgresql folder.




3) run the command - start > run > cmd >

net user postgres /delete
4) reboot.
...

http://i207.photobucket.com/albums/bb176/fozzy71/HEM/startruncmd.png

http://i207.photobucket.com/albums/bb176/fozzy71/HEM/startruncmd2.png

[hus444]

On step 3 when after I type in the command and hit enter it says, System error 5 has occurred. Access is denied.

I did steps 1 and 2, what should I do now?

Thanks

[hus444]

or am I supposed to type in the command and then restart with the window open without hitting enter?

[fozzy71]

Just reboot and install postgresql but pick a different postgres user name such as: postgreshm

[hus444]

I just tried reinstalling and ran into the exact problem of the OP, the warning says.
"The specified data directory is not empty.
If you have an existing database with the same version number, you do not need to initialize a database cluster.
If you have an existing database with a different major version you need to back up your old database and create a new one."

I see advice given to OP was to do this-

"You can delete the given data folder (from a previous postgresql installation) and try again or you uncheck the option "Initialize database cluster" and this data folder will be used again."

or this-

"The folder is in the postgresql installation folder, usually c:\program files\postgresql\8.3\data.

For changing the coding you should reinstall it."

what should I do? if it's the second one how how would I find the file to delete?

Thanks

[netsrak]

The 2nd advice was just an addition to the first one.

Use your windows explorer or "My computer" symbol to navigate to the given path and delete the folder. The path may be slightly different depending on your system.