How to fix this problem: unable to login to database

[noSTDplz]

Hi

I need to fix this problem when I try to start pt4.
Problem is :
Unable to login to database. Reason: could not connect to server.
Connection refused (0x000274D/10061) is the server running an host "???"
And accepting TCP/IP connections on port 5432?

Thank you

[Flag_Hippo]

Go to this folder:

C:\Program Files\PostgreSQL\x.y\data\

where x.y is your PostgreSQL version although you may have it installed in another location. 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.

[noSTDplz]

Go to this folder:

C:\Program Files\PostgreSQL\x.y\data\

where x.y is your PostgreSQL version although you may have it installed in another location. 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.

hi, there is not 'postmaster.pid' file.
in the folder there is only 'postmaster.opts' file

[Flag_Hippo]

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? 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.

[komarac_zg]

I solved it with this:

Click Start type notepad, right click on it and choose Run as Administrator. Once it opens up go to File -> Open and open C:\Program Files\PostgreSQL\9.0\data\pg_hba.conf (you may need to change the File Type box to show All Files to see it). Once open scroll to the bottom and where it says md5 change it to trust, save the file and restart the server and then you should be able to connect using any password.