Page 1 of 1

Unable to create PostgreSQL database

PostPosted: Mon Nov 11, 2024 3:38 pm
by 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?

Re: Unable to create PostgreSQL database

PostPosted: Tue Nov 12, 2024 6:56 am
by 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.

Re: Unable to create PostgreSQL database

PostPosted: Sat Nov 16, 2024 3:44 pm
by Stijn_123
Ok, that fixed it! Thank you!

Re: Unable to create PostgreSQL database

PostPosted: Sun Nov 17, 2024 7:48 am
by Flag_Hippo
Thanks for confirming.

highfalutin