PDA

View Full Version : Had to delete PostGres user account...



DoctorHandles
09-24-2009, 03:37 AM
And now I cannot get my hold em manager to work. What do I need to do? I tried reinstalling PostGres but that did not work.

And sorry if this has been posted before, but if I uninstall and reinstall Hold Em Manager (I assume I can request my passwords again via email) will I still have all my databases?

Thanks for the help and I love your product.

-Matt

netsrak
09-24-2009, 06:09 AM
If your databases are lost its because of the Postgresql installation.

A holdemmanager reinstallation doesn't affect the data.

What Problem do you have with Postgresql? Error message? What doesn't work?

DoctorHandles
09-24-2009, 11:31 AM
I accidentally locked myself out of my C drive while trying to make my computer more secure (lol etc I know). It was not an easy problem to fix but luckily one of my friends was able to fix it after several hours of work.

When he finally did fix it, a message came up saying Hold Em Manager needed all this information to locate my hands when I opened up Hold Em Manager (I couldn't even attempt to open it before when I was forbidden acces to my C drive). It asked for information like what my port number is and what not. Now when I open up my hold em manager database it simply says "Failed to establish a connection to 127.0.0.1," quickly tries to open then shut downs in about 1/5th a second and I get a Microsoft windows error message that DBControlPanel has stopped working.

My friend claims when he regained access to my C drive he had to delete PostGres for some reason.

fozzy71
09-24-2009, 12:28 PM
I suggest you reinstall sql fully using your existing db.


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) If you are moving the DB to a different drive/partition, manually cut or copy the \Postgresql\data directory to it's new location.
3) run the command - start > run > cmd >

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.