When I try to launch it.
I get a pop up that says "This server is not responding to connection attempts. Please restart the PostgreSQL service, then PokerTracker and try again."
Do you guys know what's going on?
I only get this problem with my PC and not on my Mac.
Okay, it works if I launch the postgre sql before PT4, but I don't understand why I have to do this sometimes to get the PT4 launched.
Originally posted by Dr1fter808
Okay, it works if I launch the postgre sql before PT4, but I don't understand why I have to do this sometimes to get the PT4 launched.
Sometimes the process that provides the postresql service fails while running and needs to be restarted.
On your PC hold down the windows key, and tap R
You will see this dialogue open:
When you press enter, you'll get the services control pane:
If the postgresql line does not say "running" and "automatic" you can click "start" or "restart" in the left-hand panel. If the service is running, use "restart", otherwise use "start". They system may detect that it is running when it crashes without informing the services control manager.
If the "startup type" column contains anything other than "automatic" the right-click the line and choose "Properties". You can set the startup type in there. There are two choices "Automatic" and "Automatic (delayed start)". Just the plain Automatic is what my system uses. You will (or should) only need to do this once.
BTW the above was done in Windows 10
Thanks V. I appreciate it.
My problem seems to have started after I switched to Windows 11 but yeah I can always start the database in the service app.
Originally posted by Dr1fter808
Thanks V. I appreciate it.My problem seems to have started after I switched to Windows 11 but yeah I can always start the database in the service app.
If the service is not running automatically, then perhaps PT4 tech support can help. They're very good.
Also, I didn't mention that running the service control app requires admin privs — at least on W10. I've no idea about W11
If the PostgreSQL isn't starting when your computer does try adding exceptions in your security software for:
C:\Program Files\PostgreSQL\x\bin\pg_ctl.exe
C:\Program Files\PostgreSQL\x\bin\postgres.exe
where x is the version of PostgreSQL installed on your computer. Restart your computer and if PostgreSQL still isn't starting check Windows Event Viewer (Windows Logs -> Application) for any PostgreSQL errors timestamped after the restart and check what they say.
- Rob
Originally posted by PokerTracker
If the PostgreSQL isn't starting when your computer does try adding exceptions in your security software for:C:\Program Files\PostgreSQL\x\bin\pg_ctl.exe
C:\Program Files\PostgreSQL\x\bin\postgres.exewhere x is the version of PostgreSQL installed on your computer. Restart your computer and if PostgreSQL still isn't starting check Windows Event Viewer (Windows Logs -> Application) for any PostgreSQL errors timestamped after the restart and check what they say.
- Rob
It's happening again. All of my poker stuff is in the D: drive, not the ordinary C: drive btw.
I think I figured it out. It happens when I use CCleaner to sweep my PC. It just somehow stops PostgreSQL.
Originally posted by VorpalF2F
Originally posted by Dr1fter808
Okay, it works if I launch the postgre sql before PT4, but I don't understand why I have to do this sometimes to get the PT4 launched.Sometimes the process that provides the postresql service fails while running and needs to be restarted.
On your PC hold down the windows key, and tap R
You will see this dialogue open:
When you press enter, you'll get the services control pane:
If the postgresql line does not say "running" and "automatic" you can click "start" or "restart" in the left-hand panel. If the service is running, use "restart", otherwise use "start". They system may detect that it is running when it crashes without informing the services control manager.
If the "startup type" column contains anything other than "automatic" the right-click the line and choose "Properties". You can set the startup type in there. There are two choices "Automatic" and "Automatic (delayed start)". Just the plain Automatic is what my system uses. You will (or should) only need to do this once.BTW the above was done in Windows 10
Thanks, restarting or starting PostgreSQL in the "services.msc" works every time to fix the issue.
