PDA

View Full Version : little help?



aycee87
10-11-2009, 09:20 PM
been emailing with fab to get my HEM fixed

seems i have a postgres issue

he sent me these instructions this morning

1. Uninstall any PostgreSQL version you can find under Control Panel -> Software



2. Delete the existing "postgres" user:



click on Start and go to Programs -> Accessories -> Command Prompt

- If you are on Vista, rightclick and choose "Run as Administrator".

A black box should appear. Type 'net user postgres /del' (without the quotes) and press enter. The user is now deleted.



3. Go to C:\Program Files\ and delete the PostgreSQL folder



4. Install this version: http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=176



but when i go control panel, there is no 'software' option
what else would it be under???

fozzy71
10-11-2009, 10:43 PM
If you are on XP it is Add/Remove programs. If you are on vista, on a USA PC, it is called Programs And Features.


here are my sql reinstall instructions, if you have no concern for the database.

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 reinstalling SQL to a new/empty DB, 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

aycee87
10-11-2009, 10:55 PM
sorry, i should have specified..

i have found...

PostgresSQL 8.3
psqlODBC 08.04.0100

should i delete both items or just PostgresSQL 8.3??

fozzy71
10-11-2009, 10:58 PM
You can remove both of those before reinstalling postgresql.

aycee87
10-11-2009, 11:02 PM
wierd thing just happened.....
i uninstalled PostgresSQL 8.3, the green bar ran till the end, then it said 'uninstallation incomplete'

but now its not in CONTROL PREGRAMS>PROGRAMS AND FEATURES

is that normal?

netsrak
10-12-2009, 03:47 AM
Thats not normal but ...
Please make sure whether the postgresql installation folder (usually c:\program files\postgresql) is properly deleted. If yes i think its ok.

aycee87
10-12-2009, 10:01 AM
i cant delete the folder c>ProgramFiles>PostgresSQL
when i try it says 'you need permission to delete this file'

fozzy71
10-12-2009, 10:28 AM
i cant delete the folder c>ProgramFiles>PostgresSQL
when i try it says 'you need permission to delete this file'

Delete the contents of it, if it will let you, or try renaming the folder. If that doesnt work, Turn off UAC (if it is on) and try rebooting, and then try to delete or rename it, immediately after rebooting.

aycee87
10-12-2009, 10:33 AM
contents of folder are deleted bar the file: EnterpriseDBApachePhp
the same 'you need permission to delete this file' message appears

UAC is turned off already

are you available to come on teamviewer fozzy?

fozzy71
10-12-2009, 10:40 AM
Please email me at fozzy@holdemmanager.net with a link to this thread. Please start the Teamviewer Quick Support Module - http://www.holdemmanager.com/downloads/TeamViewerQS.exe - and email me the ID and password information. I will open a chat window inside Teamviewer after I connect.