Problem trying to configure Postgresql database

[Lynch]

I have a problem when trying to configure Postgresql database

Unable to create PostgreSQL database: PT4 DB
Reason: Error: Unable to execute query: Fatal Error; Reason: ERROR: column "some_time" does not exist LINE 11: SELECT (EXTRACT(ISOYEAR FROM some_time AT TIME ZONE 'UTC... ^

Thank you

[Flag_Hippo]

This issue occurs with very old PostgreSQL versions such as v8.4 which reached its end-of-life in 2014 and is below the minimum required version for PokerTracker 4. To fix the issue you will need to install and use PostgreSQL version 16 - see this guide.

[Lynch]

thanks, I did it but now have this issue:

Unable to create PostgreSQL database: PT4 DB
Reason: This server is not responding to connection attempts. Please restart the PostgreSQL service, then PokerTracker and try again

Thanks

[Flag_Hippo]

When you installed PostgreSQL did it say it completed successfully or not? What version of PostgreSQL did you install? Do the port and password used for the PostgreSQL install match the port and password used in PokerTracker 4? 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? What is its 'Status' and 'Startup Type'?

[Lynch]

Yes it said completed successfully
I installed PostgreSQL 18
the port and password used for the PostgreSQL install match the port and password used in PokerTracker 4

I see the PostgreSQL service in the list.
Its status is "en cours d'execution" in french: it means "running" i think
Its startup type is "automatique" in french

Thanks

[Flag_Hippo]

Thanks that sounds like it should be working. If you're using any security software see this guide otherwise start PokerTracker 4 using the logging enabled link on your Windows Start Menu and then attach your log file to a Support Ticket where a technician can follow up with you:

C:\Users\{Windows Login}\AppData\Local\PokerTracker 4\Logs\PokerTracker4.log

To access the log file open File Explorer in Windows and enter the following in the address bar:

%localappdata%\PokerTracker 4\Logs

The file we need will be the text file called 'PokerTracker4' or 'PokerTracker4.log' that is in that folder.

[Lynch]

OK thanks I sent a ticket with the log file