Postgres problems

[Mike2]

Yesterday, my Windows 10 ran an update and today I can't start Holdem Manager anymore.

When I go to "services" and try to start Postgres, I get the following error: "Can't start PostgreSQL 8.4 on local computer. Error 1053: service didn't respond correctly to start task" (my translation).

I tried locating the .pid file, but could not find it: it's not in the Program files folder.

I'm running Windows 10 and HM2 (I believe the latest version but I can't check because I can't open the program any longer)

I tried re-starting a couple of times: that didn't help. I also manually started "Secondary logon" but that didn't change anything.

Hope someone can help!

[udbrky]

This is usually a firewall or windows update issue and the following guide gives a step by step guide:
Hold'Em Manager 2 FAQs - Poker Software :: Can not Connect / Failed to Start PostgreSQL

Uninstall PostgreSQL & try the following steps:

1) Run cmd.exe as Admin (Start > Search 'cmd' > Right-Click > Run As Admin)
2) in CMD window run (type the code then hit Enter key) following command:
net user postgres /del
3) Reboot PC
4) after reboot open cmd.exe again & run following commands:

 net user postgres postgrespass /add
 net localgroup Administrators postgres /add
 net localgroup Users postgres /delete
 runas /user:postgres cmd.exe

When it asks about password please input postgrespass & don`t worry if you don`t see any new symbols\inputs in cmd window. If you did all steps right then you should get new cmd window for postgres user.

5) Download PostgreSQL installer (http://get.enterprisedb.com/postgres...-1-windows.exe) & move (copy/paste) it from the \Downloads folder to C:\
6) in new cmd window for postgres user run following commands:
cd c:\
start postgresql-8.4.22-1-windows.exe

[Mike2]

Hi Chris,

I followed your steps, but that didn't work. Still can't start Postgres.

I did get 1 error for command net localgroup Users postgres /delete. It gave me: "The local group does not exist".

Also tried to start Postgres through Services, but that doesn't work either.

[udbrky]

I have escalated your issue to our 2nd level support techs and they will respond to your email as soon as possible.

[Ishikawa]

Hi,
Please open C:\PostgreSQL\data and post screenshot with content of this folder.

[Mike2]

I get a 1015 error when trying to start Postgresql.

See attached image for screenshot of the folder.

[Ishikawa]

Rename postgresql.conf to postgresql1.conf and postgresql.conf.20160918.ptbackup to postgresql.conf

[Mike2]

Changed those two file names and tried to start server again, but still get the error message: see screenshot

[Ishikawa]

Hmm. May be you should change password for this service in services propertries? Please open properties for SQL service, go to log on tab and send screenshot.

[Mike2]

The password is filled in there. Thanks for helping out man