Could not connect to server

[2dareis2do]

I was just taking a short break from playing and when I returned to my computer it had started some sort of upgrade. When it was done and i tried restarting PokerTracker I got the following message:

Unable to login to database (postgres). Reason: could not connect to erver: Connection refused (0x0000274D/10061) Is the server running on host "???" and accepting TCP/IP connections on port 5432?

Its probably likely that my firewall settings was changed in the process of the update, thus causing problems for Postgres/PT?? But how can I fix it? Ive tried the advice provided at the troubleshooting page here on pt.com but I havent found any advice that helps.

Im rather desperate to fix this asap.

Anyone??

Kind regards
2dareis2do

[WhiteRider]

If you haven't already restarted your computer, try that first as that could be all that's needed.

If not, click Start in Windows and type 'services' and open the Services window.
Is PostgreSQL in the list? Is it started, or can you start it?

Our Firewall guide is here: Firewall Guide

[2dareis2do]

Thanks for your reply!

Postgres is not in the "Services" list. How can I add it?

Kind regards
John

[WhiteRider]

In that case you'll need to reinstall it. Your existing data should still be there (as long as you didn't format your computer or delete the PostgreSQL folders manually), so when you reinstall you should be able to reconnect to your existing database(s).

You need to know which PostgreSQL version to install so that you can install the same version again: if you don't know what version you had go to C:\Program Files\PostgreSQL and see what version number folder you have. It will be something like 9.0 or 9.3.
Once you know what version you had, install the same version. You can download it from here. Be sure to get the correct version for your operating system.

You can follow our install guides here for more information.

[uberslug]

so I re downloaded 9.3.25 but still no joy.

Still getting this error message

https://gyazo.com/b0a8d20d76d80f568095563281ebdfa5

Do I need to uninstall 9.6?

Also tried to start 9.3 in services but get this error message

https://gyazo.com/3368e21a4996642b667c90a165a2c85c

[uberslug]

After uninstalling 9.6 I get this error message

https://gyazo.com/559c10324e957ebba81742c3f18cd36f

[Flag_Hippo]

Did you receive confirmation that PostgreSQL v9.3 reinstalled successfully? Go to C:\Program Files\PostgreSQL\9.3\data (although you may have it installed in another location) and delete the 'postmaster.pid' file inside that folder (not 'postmaster.opts' which may be there too), reboot your computer and try starting PokerTracker 4 again. If that does not help then click your Windows Start button then type the following command:

services.msc 

and click on it when it appears. Do you see the PostgreSQL service in the list? Is it started, or can you start it? If the PostgreSQL service is not listed at all you will need to install it again and we have a guide for that here. If the PostgreSQL service is listed but not starting then open the Event Viewer (in the same way - if you type 'event' you should see it). In the top left section, expand "Windows Logs" and click on "Application". Do you see any recent errors in the top center section for PostgreSQL? If you do let us know what they say.

[uberslug]

Already tried deleting the postmaster pid file.

In services Postgres9.3 is there I try to start it and it only loads so far then then I get the error message :

https://gyazo.com/dd129c5611efa76f686c899b84e84448

In event viewer there are a bunch of error messages and they all seem to say :

https://gyazo.com/575226e7b90700ea38ba49b6975cc8fe

Edit. Sorry this is not my thread apologies did not know how to delete comment.

[Flag_Hippo]

Did you receive confirmation that PostgreSQL v9.3 reinstalled successfully?

In event viewer there are a bunch of error messages and they all seem to say :

That error suggests it didn't install successfully. Try again and if it does not install successfully send us this file in a Support Ticket:

C:\Users\{Windows Login}\AppData\Local\Temp\install-postgresql.log

If you do not see the AppData folder in Windows File Explorer then please refer to this guide. On the other hand if the PostgreSQL install completes successfully but PokerTracker 4 isn't able to start then please send us your PokerTracker4.log file and PostgreSQL log files in a Support Ticket instead.

[uberslug]

Did you receive confirmation that PostgreSQL v9.3 reinstalled successfully?

In event viewer there are a bunch of error messages and they all seem to say :

That error suggests it didn't install successfully. Try again and if it does not install successfully send us this file in a Support Ticket:

C:\Users\{Windows Login}\AppData\Local\Temp\install-postgresql.log

If you do not see the AppData folder in Windows File Explorer then please refer to this guide. On the other hand if the PostgreSQL install completes successfully but PokerTracker 4 isn't able to start then please send us your PokerTracker4.log file and PostgreSQL log files in a Support Ticket instead.

I think it installed successfully yes however when I went to C:\Users\{Windows Login}\AppData\Local\Temp\install-postgresql.log I could not find \install-postgresql.log

I went to install it again it says 9.3.25 is not supported ?

https://gyazo.com/66e4ba9a13363788a245424f61777723

downloaded it regardless and got to this screen

https://gyazo.com/2ffcfcff3f0d28399ba3079cf868c891

clicked finish and it took me to here.... Do I need to continue ? If so what do I do when I get here?
https://gyazo.com/d673fa0fad07fd476d379eeb84c9d6e7#