The system 5 error means you need to to right-click > run as administrator when launching the CMD prompt.
This is usually a firewall or windows update issue and this guide gives a step by step guide.
The secondary logon service is a standard windows service which is available on every windows computer and is required to install PostgreSQL. In some versions it is not started automatically and it will just give an error when trying to connect to PostgreSQL. You need to verify it is turned on via control panel > administrative tools > services > secondary logon > right-click > start AND right-click > properties and choose startup type: automatic so it will be started automatically next time your PC reboots.
Please see this FAQ to alleviate any security bottlenecks.
If you continue to have problems:
Which Operating System, Firewall, and AntiVirus are you using?
Many of those free Norton, Mcaffee, Comodo, Zonealarm, Avira, Avast, AVG, Bitdefender, etc, 'internet security' bundles will not work well with Holdem Manager.
Please do the following steps, so we can get your computer to a state that we know will work with Holdem Manager:
1) Uninstall any 3rd party security software (even windows defender or security essentials) bundles and dont reinstall them until after you reconnect postgresql.
2) Reboot your computer
3) Please install the latest version.
- After downloading, you should right-click the file, go to properties and click unblock.*
* If you do not see an 'unblock' option you can ignore this step.
- Then, right click the file and run as administrator.
4) Enable Windows Firewall's recommended settings through your Control Panel, turn off Windows Defender (unless you are using Windows 10, in which case it should be enabled), and add firewall exceptions for HM and SQL.
5) Install Microsoft Security Essentials (unless you are using Windows 10) for antivirus/malware protection and update it - https://support.microsoft.com/en-us/help/14210
If you continue to have problems you can try to reinstall the same version of postgresql and reconnect your database:
Make sure windows is fully updated until 'No New Important Updates are Found' (this may require multiple restarts and multiple 'check for updates'), including Internet Explorer (even if you use a different web browser).
Please note that reinstalling PostgreSQL will mean losing all your old data. If you have access to HM2 and your database was not corrupt then please follow these instructions for backing up your database as a precaution in case you cannot reconnect after reinstalling PostgreSQL.
If you cannot access the database in HM2 then you can backup your database using this method but if your database was corrupt then the best solution is to reimport all your hands from C:/HM2archive folder or if your pokersite supports it you can request all your hands and summaries and reimport them as restoring a corrupt database will just restore all the problems you had.
Once you have backed up your previous database(s) then follow the instructions below to uninstall and reinstall PostgreSQL using the same database.
1) Uninstall PostgreSQL from the Windows Control Panel.
2) Run the command - start > programs > accessories > command prompt > right-click > run as administrator and type the following and then press enter:
Code:
net user postgres /delete
3) You should get a successfully completed response if done correctly. If you get a permission type error you likely didnt run it as administrator as explained above.
4) Reboot your PC
5) Install the same version of PostgreSQL as your previous database using these instructions.
If none of that helps you will have to reinstall postgresql from scratch:
1) Uninstall PostgreSQL from the Windows Control Panel.
2) Delete the \PostgreSQL\X.x\data folder that is left behind.
3) Delete the sub-folder(s) in c:\users\username\appdata\roaming\HoldemManager\Da tabase (XP - c:\documents and settings\username\application data\HoldemManager\Database).
4) run the command - start > programs > accessories > command prompt > right-click > run as administrator
net user postgres /delete
After you click 'Enter' for the code above also do that same for this code:
sc delete postgresql-8.4
and click 'Enter' again.
5) Restart your PC
6) Install PostgreSQL 9.3 from PostgreSQL.org
7) Once installed you should disable the postgresql logging as instructed here.
If there is still an issue, we need to know the error - it is in the temp folder - bitrockinstaller.txt file. If you can't see it, turn off the windows option that is hiding that directory.
We will also want to see a set of the \HM2Logs files sent via a support ticket.
Can not start PostgreSQL
Posting Permissions
Reply With Quote