Page 1 of 1

Database issue. Cannot connect

PostPosted: Tue Nov 18, 2025 8:25 pm
by Drezayzel
I receive the following error upon startup of PT4.

Unable to login to database (potgres). Reason: Connection to server at "localhost" (::1), port 5432 failed. Connection refused. Is the server running on that host and accepting TCP/IP connections?



If I ignore this message and continue to use PT4, I am met with attempts to access a database. The error returns as follows: Unable to connect to PostgreSQL database. This server is not responding to connection attempts. Please restart PostgreSQL and PokerTracker, then try again

I hope the answer isn't in the faq... please help if possible.

Re: Database issue. Cannot connect

PostPosted: Tue Nov 18, 2025 8:43 pm
by Drezayzel
I think I've found instructions to fix this issue somewhere in the forums. will try all that now

Re: Database issue. Cannot connect

PostPosted: Tue Nov 18, 2025 9:58 pm
by Drezayzel
I try to create a new databas since the active one lists N/A as the size so clearly is worthless.

I now have an error about trailing junk after numeric literal


This is getting fairly frustrating.....

Re: Database issue. Cannot connect

PostPosted: Tue Nov 18, 2025 10:29 pm
by Drezayzel
now when i launch pt4, i am taken to the select database screen.

therein lies another error, connecting to the default database.

when i try to create a new one, i get the error above.

please help

Re: Database issue. Cannot connect

PostPosted: Wed Nov 19, 2025 7:12 am
by Flag_Hippo
Drezayzel wrote:I try to create a new databas since the active one lists N/A as the size so clearly is worthless.

I now have an error about trailing junk after numeric literal

The trailing junk error only happens in newer versions of PostgreSQL that are not supported by PokerTracker 4. Please uninstall the version(s) of PostgreSQL you currently have installed:

Guide: Uninstalling PostgreSQL

and then manually download and install PostgreSQL v16:

Guide: Installing PostgreSQL

Re: Database issue. Cannot connect

PostPosted: Wed Nov 19, 2025 11:54 am
by Drezayzel
Thank you for the help. PT4 now loads as desired.

Re: Database issue. Cannot connect

PostPosted: Thu Nov 20, 2025 7:29 am
by Flag_Hippo
Pleased to hear it :)