Postgres 9.2

[sjokkomoes]

Hello,

I recently started up HEM2 after some inactive time but could not connect to Postgres. I tried reinstalling Postgres( I used 16 for it) but it is still connecting. I think I need version 9.2 but cannot find it anywhere anymore. Any help?

[fozzy71]

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.25 from the link below:
- https://www.enterprisedb.com/downloa...esql-downloads
- Skip the 'Stack Builder' option at the end of the installation if prompted.

7) Once installed you should disable the postgresql logging as instructed here.

[sjokkomoes]

During installation i get the error "Failed to load SQL modules into the database cluster"
I tried running as admin, did not work. It compelted installation but still same problem with HEM2.

[fozzy71]

During installation i get the error "Failed to load SQL modules into the database cluster"
I tried running as admin, did not work. It compelted installation but still same problem with HEM2.

I am not sure what else to suggest as we don't support HM2 any longer and I personally haven't used HM2 or PSQL since around 2016 when we first started testing HM3 internally.

I do have one other older 'canned reply' with some slightly different steps for reinstalling PSQL for HM2 that you can try below.

1) Uninstall PostgreSQL from the Windows Control Panel.

2) Delete the \PostgreSQL\8.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) Restart your PC

5) Use our combo installer to reinstall PostgreSQL. Make sure you un-check Holdem Manager during installation. http://www.holdemmanager.com/downloa...er_2_Setup.exe

Start HM2 again and create a New Database, and make sure to name it differently than the default name.

*Please update to the latest version - HM2 > settings > check for updates