Page 1 of 1
PT3 not working after reinstalling postgresql

Posted:
Tue Feb 10, 2009 4:21 pm
by Starkilla
When you install PT3 with postgresql and later decide to reinstall postgresql (because of an error or something) it always ends in a faulty installation for me. I reinstalled postgresql 8.3.5.1 and everytime there is a duplicate error there is a constraint error and the database goes into a loop. I used
http://www.pokertracker.com/products/PT ... greSQL.pdf to reinstall postgresql.
Re: PT3 not working after reinstalling postgresql

Posted:
Tue Feb 10, 2009 4:28 pm
by kraada
Could you please post the full text of the error?
Re: PT3 not working after reinstalling postgresql

Posted:
Tue Feb 10, 2009 5:22 pm
by Starkilla
2009-01-09 10:12:56 CET ANWEISUNG: COPY holdem_hand_summary FROM STDIN;
2009-01-09 10:12:56 CET FEHLER: doppelter Schlüsselwert verletzt Unique-Constraint »hhs-unique_hand_no«
2009-01-09 10:12:56 CET ZUSAMMENHANG: COPY holdem_hand_summary, Zeile 1: »11160106 400 3 1004 1365477120 2009/01/09 05:56:02 2009/01/09 10:03:02 5 2 0 0 4.81 15.28 0.00 0.00 ...«
the error was gone after i installed pt3 with postgresql again. so this is more a notice than a bug report!
Re: PT3 not working after reinstalling postgresql

Posted:
Tue Feb 10, 2009 5:45 pm
by kraada
PT3 is designed to work with PostgreSQL in English; installing not in English can cause problems. The version bundled with PT3 doesn't give you the option to change the language, so that's likely what happened here.
Re: PT3 not working after reinstalling postgresql

Posted:
Tue Feb 10, 2009 7:22 pm
by Starkilla
lol, i knew you would point that out

but i also tried the english version and there i had the same error. i only had that old log file where postgresql was in german.
Re: PT3 not working after reinstalling postgresql

Posted:
Wed Feb 11, 2009 10:36 am
by kraada
The logs for the english version should reside in C:\Program Files\PostgreSQL\8.3\Data\pg_log -- do you not see log files there?
Re: PT3 not working after reinstalling postgresql

Posted:
Wed Feb 11, 2009 4:07 pm
by Starkilla
i deleted the whole folder before i reinstalled pt3 with postgresql so there are no log files.
Re: PT3 not working after reinstalling postgresql

Posted:
Wed Feb 11, 2009 4:39 pm
by kraada
Okay, but do you have PostgreSQL installed now and functioning or are you still having trouble?
Re: PT3 not working after reinstalling postgresql

Posted:
Wed Feb 11, 2009 4:50 pm
by Starkilla
everything is working fine. this post was just a warning to the other users that there could be problems regarding the guide and that postgresql version.