EDIT: nevermind I got it, i just removed the password, I dont know how to delte threads though....
Hi guys, sorry to bother you with what is hopefully a really easy problem.
I'm having trouble with my PT3 in relation to this:
2008/08/15 15:06:40: Full Tilt: Unable to import hand (#7651813545). Reason: Unable to execute query: COPY holdem_hand_player_statistics FROM STDIN;; Reason: Fatal Error (ERROR: index "hhps:idx5-id_session" contains unexpected zero page at block 0 HINT: Please REINDEX it. CONTEXT: COPY holdem_hand_player_statistics, line 1: "70112 696 696 0 2 8819 2008/08/15 04:05:59 8 f f 0 f 0 f f f f f 0 f 0 t f f t f 0 f 0 t f t t f 0 f..." )
There are two main reasons for this error. The first is a result of data corruption from a computer crash that requires reindexing your database. You can reindex your database from the PostgreSQL command prompt. Click Start --> Programs --> PostgreSQL --> Command prompt. At the prompt that appears, type “reindexdb -a” and hit enter. Be aware that if you have large databases this may take a while, so be patient and wait for it to finish.
(If the re-index doesn't work because you are not logged in as user 'postgres' enter: "reindexdb -U postgres -a").
The instructions are fine, yet when I try to follow them, I am forced to type in a password after the line of text, and it doesnt let me type anything at all?
Then when I hit enter I get this message: reindexdb: could not connect to database: FATAL: password authentication failed for user "Tony"
similarily, if i type: "reindexdb -U postgres -a" i get the message "could not connect to database postgres: FATAL: password authentication failed for user postgres"
I dont even use a password for my computer? Sorry for the questions, thanks in advance.
