Pinocchio
08-15-2009, 10:05 AM
Hi
I am currently trying to restore my HEM db after reformatting my pc and i am having a couple of issues. I backed up db both through postgres and by exporting the HH. I think some of the HH managed to get get corrupt because when I try and import them through HEM the import process freezes about 30% of the way through, so i have only managed to recover 30% of my data.
When I try and restore through pgadminIII i am getting the following error message. I pretty sure I followed the instruction on how to back a db in the FAQ correctly...
Here is the error message I receive from pgadminIII. Is there anyway to solve this? TY
pg_restore: creating SEQUENCE OWNED BY players_player_id_seq
pg_restore: executing SEQUENCE SET players_player_id_seq
pg_restore: creating SEQUENCE pokerhands_pokerhand_id_seq
pg_restore: [archiver (db)] Error from TOC entry 1615; 1259 114897 SEQUENCE pokerhands_pokerhand_id_seq postgres
pg_restore: [archiver (db)] could not execute query: ERROR: relation "pokerhands_pokerhand_id_seq" already exists
Command was: CREATE SEQUENCE pokerhands_pokerhand_id_seq
INCREMENT BY 1
NO MAXVALUE
NO MINVALUE
CACHE 1;
pg_restore: creating SEQUENCE OWNED BY pokerhands_pokerhand_id_seq
pg_restore: executing SEQUENCE SET pokerhands_pokerhand_id_seq
pg_restore: creating SEQUENCE rakeback_rakeback_id_seq
pg_restore: [archiver (db)] Error from TOC entry 1630; 1259 114974 SEQUENCE rakeback_rakeback_id_seq postgres
pg_restore: [archiver (db)] could not execute query: ERROR: relation "rakeback_rakeback_id_seq" already exists
Command was: CREATE SEQUENCE rakeback_rakeback_id_seq
INCREMENT BY 1
NO MAXVALUE
NO MINVALUE
CACHE 1;
pg_restore: creating SEQUENCE OWNED BY rakeback_rakeback_id_seq
pg_restore: executing SEQUENCE SET rakeback_rakeback_id_seq
pg_restore: creating SEQUENCE tables_table_id_seq
pg_restore: [archiver (db)] Error from TOC entry 1624; 1259 114940 SEQUENCE tables_table_id_seq postgres
pg_restore: [archiver (db)] could not execute query: ERROR: relation "tables_table_id_seq" already exists
Command was: CREATE SEQUENCE tables_table_id_seq
INCREMENT BY 1
NO MAXVALUE
NO MINVALUE
CACHE 1;
pg_restore: creating SEQUENCE OWNED BY tables_table_id_seq
pg_restore: executing SEQUENCE SET tables_table_id_seq
pg_restore: creating DEFAULT bonus_id
pg_restore: creating DEFAULT compiledplayerresults_id
pg_restore: creating DEFAULT compiledplayerresults_id
pg_restore: creating DEFAULT gametype_id
pg_restore: creating DEFAULT note_id
pg_restore: creating DEFAULT importedfile_id
pg_restore: creating DEFAULT manuallyenteredsession_id
pg_restore: creating DEFAULT player_id
pg_restore: creating DEFAULT pokerhand_id
pg_restore: creating DEFAULT rakeback_id
pg_restore: creating DEFAULT table_id
pg_restore: restoring data for table "actiontypes"
pg_restore: [archiver (db)] Error from TOC entry 2025; 0 114809 TABLE DATA actiontypes postgres
pg_restore: [archiver (db)] COPY failed: ERROR: duplicate key value violates unique constraint "actiontypes_pkey"
CONTEXT: COPY actiontypes, line 1: "-1 "
pg_restore: restoring data for table "aliases"
pg_restore: restoring data for table "allinsituations"
pg_restore: [archiver (db)] Error from TOC entry 2032; 0 114852 TABLE DATA allinsituations postgres
pg_restore: [archiver (db)] COPY failed: ERROR: duplicate key value violates unique constraint "allinsituations_pkey"
CONTEXT: COPY allinsituations, line 32: "3571 472 -188"
pg_restore: restoring data for table "allinsituations_hero"
pg_restore: restoring data for table "bonuses"
pg_restore: restoring data for table "compiledplayerresults"
pg_restore: restoring data for table "compiledplayerresults_month"
pg_restore: [archiver (db)] Error from TOC entry 2055; 0 115015 TABLE DATA compiledplayerresults_month postgres
pg_restore: [archiver (db)] COPY failed: ERROR: duplicate key value violates unique constraint "compiledplayerresults_month_idx1"
CONTEXT: COPY compiledplayerresults_month, line 1: "25361 1 25 0 0.5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0..."
pg_restore: restoring data for table "compiledplayerresultspositionaction"
pg_restore: restoring data for table "compiledplayerresultspositionaction_month"
pg_restore: [archiver (db)] Error from TOC entry 2056; 0 115019 TABLE DATA compiledplayerresultspositionaction_month postgres
pg_restore: [archiver (db)] COPY failed: ERROR: duplicate key value violates unique constraint "compiledplayerresultspositionaction_month_idx1"
CONTEXT: COPY compiledplayerresultspositionaction_month, line 1: "25353 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ..."
pg_restore: restoring data for table "compiledresults"
pg_restore: restoring data for table "compiledresults_month"
pg_restore: [archiver (db)] Error from TOC entry 2058; 0 115029 TABLE DATA compiledresults_month postgres
pg_restore: [archiver (db)] COPY failed: ERROR: duplicate key value violates unique constraint "compiledresults_month_pkey"
CONTEXT: COPY compiledresults_month, line 1: "8059 200904 5 2 0 17 25284"
pg_restore: restoring data for table "gametypes"
pg_restore: [archiver (db)] Error from TOC entry 2023; 0 114795 TABLE DATA gametypes postgres
pg_restore: [archiver (db)] COPY failed: ERROR: duplicate key value violates unique constraint "gametypes_pkey"
CONTEXT: COPY gametypes, line 1: "1 $0.05/0.1 NL 10 5 0 f 0 1"
pg_restore: restoring data for table "handhistories"
pg_restore: [custom archiver] could not read from input file: Invalid argument
pg_restore: *** aborted because of error
Process returned exit code 1.
I am currently trying to restore my HEM db after reformatting my pc and i am having a couple of issues. I backed up db both through postgres and by exporting the HH. I think some of the HH managed to get get corrupt because when I try and import them through HEM the import process freezes about 30% of the way through, so i have only managed to recover 30% of my data.
When I try and restore through pgadminIII i am getting the following error message. I pretty sure I followed the instruction on how to back a db in the FAQ correctly...
Here is the error message I receive from pgadminIII. Is there anyway to solve this? TY
pg_restore: creating SEQUENCE OWNED BY players_player_id_seq
pg_restore: executing SEQUENCE SET players_player_id_seq
pg_restore: creating SEQUENCE pokerhands_pokerhand_id_seq
pg_restore: [archiver (db)] Error from TOC entry 1615; 1259 114897 SEQUENCE pokerhands_pokerhand_id_seq postgres
pg_restore: [archiver (db)] could not execute query: ERROR: relation "pokerhands_pokerhand_id_seq" already exists
Command was: CREATE SEQUENCE pokerhands_pokerhand_id_seq
INCREMENT BY 1
NO MAXVALUE
NO MINVALUE
CACHE 1;
pg_restore: creating SEQUENCE OWNED BY pokerhands_pokerhand_id_seq
pg_restore: executing SEQUENCE SET pokerhands_pokerhand_id_seq
pg_restore: creating SEQUENCE rakeback_rakeback_id_seq
pg_restore: [archiver (db)] Error from TOC entry 1630; 1259 114974 SEQUENCE rakeback_rakeback_id_seq postgres
pg_restore: [archiver (db)] could not execute query: ERROR: relation "rakeback_rakeback_id_seq" already exists
Command was: CREATE SEQUENCE rakeback_rakeback_id_seq
INCREMENT BY 1
NO MAXVALUE
NO MINVALUE
CACHE 1;
pg_restore: creating SEQUENCE OWNED BY rakeback_rakeback_id_seq
pg_restore: executing SEQUENCE SET rakeback_rakeback_id_seq
pg_restore: creating SEQUENCE tables_table_id_seq
pg_restore: [archiver (db)] Error from TOC entry 1624; 1259 114940 SEQUENCE tables_table_id_seq postgres
pg_restore: [archiver (db)] could not execute query: ERROR: relation "tables_table_id_seq" already exists
Command was: CREATE SEQUENCE tables_table_id_seq
INCREMENT BY 1
NO MAXVALUE
NO MINVALUE
CACHE 1;
pg_restore: creating SEQUENCE OWNED BY tables_table_id_seq
pg_restore: executing SEQUENCE SET tables_table_id_seq
pg_restore: creating DEFAULT bonus_id
pg_restore: creating DEFAULT compiledplayerresults_id
pg_restore: creating DEFAULT compiledplayerresults_id
pg_restore: creating DEFAULT gametype_id
pg_restore: creating DEFAULT note_id
pg_restore: creating DEFAULT importedfile_id
pg_restore: creating DEFAULT manuallyenteredsession_id
pg_restore: creating DEFAULT player_id
pg_restore: creating DEFAULT pokerhand_id
pg_restore: creating DEFAULT rakeback_id
pg_restore: creating DEFAULT table_id
pg_restore: restoring data for table "actiontypes"
pg_restore: [archiver (db)] Error from TOC entry 2025; 0 114809 TABLE DATA actiontypes postgres
pg_restore: [archiver (db)] COPY failed: ERROR: duplicate key value violates unique constraint "actiontypes_pkey"
CONTEXT: COPY actiontypes, line 1: "-1 "
pg_restore: restoring data for table "aliases"
pg_restore: restoring data for table "allinsituations"
pg_restore: [archiver (db)] Error from TOC entry 2032; 0 114852 TABLE DATA allinsituations postgres
pg_restore: [archiver (db)] COPY failed: ERROR: duplicate key value violates unique constraint "allinsituations_pkey"
CONTEXT: COPY allinsituations, line 32: "3571 472 -188"
pg_restore: restoring data for table "allinsituations_hero"
pg_restore: restoring data for table "bonuses"
pg_restore: restoring data for table "compiledplayerresults"
pg_restore: restoring data for table "compiledplayerresults_month"
pg_restore: [archiver (db)] Error from TOC entry 2055; 0 115015 TABLE DATA compiledplayerresults_month postgres
pg_restore: [archiver (db)] COPY failed: ERROR: duplicate key value violates unique constraint "compiledplayerresults_month_idx1"
CONTEXT: COPY compiledplayerresults_month, line 1: "25361 1 25 0 0.5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0..."
pg_restore: restoring data for table "compiledplayerresultspositionaction"
pg_restore: restoring data for table "compiledplayerresultspositionaction_month"
pg_restore: [archiver (db)] Error from TOC entry 2056; 0 115019 TABLE DATA compiledplayerresultspositionaction_month postgres
pg_restore: [archiver (db)] COPY failed: ERROR: duplicate key value violates unique constraint "compiledplayerresultspositionaction_month_idx1"
CONTEXT: COPY compiledplayerresultspositionaction_month, line 1: "25353 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ..."
pg_restore: restoring data for table "compiledresults"
pg_restore: restoring data for table "compiledresults_month"
pg_restore: [archiver (db)] Error from TOC entry 2058; 0 115029 TABLE DATA compiledresults_month postgres
pg_restore: [archiver (db)] COPY failed: ERROR: duplicate key value violates unique constraint "compiledresults_month_pkey"
CONTEXT: COPY compiledresults_month, line 1: "8059 200904 5 2 0 17 25284"
pg_restore: restoring data for table "gametypes"
pg_restore: [archiver (db)] Error from TOC entry 2023; 0 114795 TABLE DATA gametypes postgres
pg_restore: [archiver (db)] COPY failed: ERROR: duplicate key value violates unique constraint "gametypes_pkey"
CONTEXT: COPY gametypes, line 1: "1 $0.05/0.1 NL 10 5 0 f 0 1"
pg_restore: restoring data for table "handhistories"
pg_restore: [custom archiver] could not read from input file: Invalid argument
pg_restore: *** aborted because of error
Process returned exit code 1.