Unable to login to database postgres

Questions and discussion about PokerTracker 4 for Windows

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Unable to login to database postgres

Postby Mauro Chavez » Mon Jul 27, 2020 9:20 pm

Hi I tried to open my database and now a textbox says
Unable to login to database postgres. Reason: could not connect to server. Connection refused (0x00000274D/10061) Is the server running on host ??? and accepting TCP/IP connections on port 5432?

After I press in connect it show me another windows and says Unable to connect to this database. Plase check the configuration
What should I do to not lost my database?!!!
Mauro Chavez
 
Posts: 5
Joined: Sat May 30, 2020 9:29 pm

Re: Unable to login to database postgres

Postby Flag_Hippo » Tue Jul 28, 2020 4:46 am

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. 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? 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.
Flag_Hippo
Moderator
 
Posts: 17115
Joined: Tue Jan 31, 2012 7:50 am

Re: Unable to login to database postgres

Postby Mauro Chavez » Tue Jul 28, 2020 9:32 pm

Thank you for your fast response!
Before the problems begins, I made this https://support.microsoft.com/en-us/hel ... -safe-mode because I had other problems in my pc. I tried to delete the file that you mentioned but is not appear there.
I could fix the problem, the database was disabled and I saw it in the services now it's working fine. Have a nice day!
Mauro Chavez
 
Posts: 5
Joined: Sat May 30, 2020 9:29 pm


Return to PokerTracker 4

Who is online

Users browsing this forum: No registered users and 0 guests