Unable to create PostgreSQL database

[Stijn_123]

Hi,

I installed the latest version of PostgreSQL by following 'How to manually update PostgreSQL', but I get an error when trying to create a temporary database:

Unable to create PostgreSQL database: PT4_2024_11_11_183644 Reason: Erro: Unable to execute query: Fatal Error; Reason: ERROR: trailing junk after numeric literal at or near “1GROUP” LINE 17: …mit, cash_hand_summary.cnt_players, FRO WHERE 1=11=1GROUP BY …^

How can this be fixed pls?

[Flag_Hippo]

When you say you installed "the latest version of PostgreSQL" does that mean you installed PostgreSQL v17? PostgreSQL v17 has only been recently released and it has not been tested with PokerTracker 4. As per the guide PokerTracker v4.18 supports up to PostgreSQL v16 so if you have installed PostgreSQL v17 please uninstall it and install v16 instead.

[Stijn_123]

Ok, that fixed it! Thank you!

[Flag_Hippo]

Thanks for confirming.