PT3 not working after reinstalling postgresql

[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.

[kraada]

Could you please post the full text of the error?

[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!

[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.

[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.

[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?

[Starkilla]

i deleted the whole folder before i reinstalled pt3 with postgresql so there are no log files.

[kraada]

Okay, but do you have PostgreSQL installed now and functioning or are you still having trouble?

[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.