PT3: Problem mit Wiederherstellung einer Postgres Datenbank

    • circe
      circe
      Bronze
      Dabei seit: 18.03.2005 Beiträge: 1.495
      Hallöchen,

      beim Versuch, das mit PGadmin erstellt Backup einer Datenbank einzuspielen, erhalte ich die nachfolgenden Fehlermeldungen.

      Kann mir bitte jemand sagen, warum die Wiederherstellung der Datenbank nicht funktioniert?

      Liebe Grüße

      Christian


      C:\Programme\PostgreSQL\8.3\bin\pg_restore.exe -h localhost -p 5432 -U postgres -d "PT3 DB" "C:\Dokumente und Einstellungen\Christian\Desktop\my_handhistories_08_02_2009.backup"
      pg_restore: [archiver (db)] Error while PROCESSING TOC:
      pg_restore: [archiver (db)] Error from TOC entry 1564; 1259 17306 TABLE holdem_cache postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: relation "holdem_cache" already exists
      Command was:
      CREATE TABLE holdem_cache (
      id_player integer NOT NULL,
      id_limit integer NOT NULL,
      cnt_players integer NOT NULL...
      pg_restore: [archiver (db)] Error from TOC entry 1536; 1259 16659 TABLE holdem_hand_histories postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: relation "holdem_hand_histories" already exists
      Command was: CREATE TABLE holdem_hand_histories (
      id_hand integer NOT NULL,
      history text
      );
      pg_restore: [archiver (db)] Error from TOC entry 1558; 1259 17252 TABLE holdem_hand_player_combinations postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: relation "holdem_hand_player_combinations" already exists
      Command was: CREATE TABLE holdem_hand_player_combinations (
      id_hand integer NOT NULL,
      id_player integer NOT NULL,
      flg_f_highc...
      pg_restore: [archiver (db)] Error from TOC entry 1559; 1259 17259 TABLE holdem_hand_player_detail postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: relation "holdem_hand_player_detail" already exists
      Command was: CREATE TABLE holdem_hand_player_detail (
      id_hand integer NOT NULL,
      id_player integer NOT NULL,
      seat smallint,
      ...
      pg_restore: [archiver (db)] Error from TOC entry 1560; 1259 17266 TABLE holdem_hand_player_statistics postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: relation "holdem_hand_player_statistics" already exists
      Command was: CREATE TABLE holdem_hand_player_statistics (
      id_hand integer NOT NULL,
      id_player integer NOT NULL,
      id_player_rea...
      pg_restore: [archiver (db)] Error from TOC entry 1561; 1259 17277 TABLE holdem_hand_summary postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: relation "holdem_hand_summary" already exists
      Command was: CREATE TABLE holdem_hand_summary (
      id_hand integer NOT NULL,
      id_site smallint,
      id_limit smallint,
      id_table i...
      pg_restore: [archiver (db)] Error from TOC entry 1537; 1259 16667 TABLE holdem_limit postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: relation "holdem_limit" already exists
      Command was: CREATE TABLE holdem_limit (
      id_limit smallint NOT NULL,
      limit_name text,
      amt_sb numeric(7,2),
      amt_bb numeric...
      pg_restore: [archiver (db)] Error from TOC entry 1538; 1259 16675 TABLE holdem_table postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: relation "holdem_table" already exists
      Command was: CREATE TABLE holdem_table (
      id_table integer NOT NULL,
      table_name text
      );
      pg_restore: [archiver (db)] Error from TOC entry 1562; 1259 17287 TABLE holdem_table_session_summary postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: relation "holdem_table_session_summary" already exists
      Command was: CREATE TABLE holdem_table_session_summary (
      id_session integer NOT NULL,
      id_site smallint,
      id_player integer,
      ...
      pg_restore: [archiver (db)] Error from TOC entry 1555; 1259 17048 TABLE lookup_actions postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: relation "lookup_actions" already exists
      Command was: CREATE TABLE lookup_actions (
      id_action integer NOT NULL,
      action text
      );
      pg_restore: [archiver (db)] Error from TOC entry 1550; 1259 17004 TABLE lookup_hand_groups postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: relation "lookup_hand_groups" already exists
      Command was: CREATE TABLE lookup_hand_groups (
      id_group smallint NOT NULL,
      group_name text NOT NULL
      );
      pg_restore: [archiver (db)] Error from TOC entry 1551; 1259 17012 TABLE lookup_hand_ranks postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: relation "lookup_hand_ranks" already exists
      Command was: CREATE TABLE lookup_hand_ranks (
      id_hand_rank smallint NOT NULL,
      id_group smallint NOT NULL,
      group_name text NOT...
      pg_restore: [archiver (db)] Error from TOC entry 1552; 1259 17020 TABLE lookup_hole_cards postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: relation "lookup_hole_cards" already exists
      Command was: CREATE TABLE lookup_hole_cards (
      id_holecard integer NOT NULL,
      hole_cards character varying(3) NOT NULL,
      flg_pai...
      pg_restore: [archiver (db)] Error from TOC entry 1553; 1259 17031 TABLE lookup_positions postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: relation "lookup_positions" already exists
      Command was: CREATE TABLE lookup_positions (
      cnt_players smallint NOT NULL,
      "position" smallint NOT NULL,
      description charact...
      pg_restore: [archiver (db)] Error from TOC entry 1554; 1259 17040 TABLE lookup_sites postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: relation "lookup_sites" already exists
      Command was: CREATE TABLE lookup_sites (
      id_site integer NOT NULL,
      site_abbrev character varying(3),
      site_name text
      );
      pg_restore: [archiver (db)] Error from TOC entry 1548; 1259 16988 TABLE lookup_tourney_table_type postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: relation "lookup_tourney_table_type" already exists
      Command was: CREATE TABLE lookup_tourney_table_type (
      id_type smallint NOT NULL,
      description text
      );
      pg_restore: [archiver (db)] Error from TOC entry 1549; 1259 16996 TABLE lookup_tourney_type postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: relation "lookup_tourney_type" already exists
      Command was: CREATE TABLE lookup_tourney_type (
      id_type smallint NOT NULL,
      description text
      );
      pg_restore: [archiver (db)] Error from TOC entry 1556; 1259 17056 TABLE notes postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: relation "notes" already exists
      Command was: CREATE TABLE notes (
      id_note integer NOT NULL,
      id_x integer NOT NULL,
      enum_type character(3) NOT NULL,
      date_...
      pg_restore: [archiver (db)] Error from TOC entry 1563; 1259 17294 TABLE player postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: relation "player" already exists
      Command was: CREATE TABLE player (
      id_player integer NOT NULL,
      id_site smallint,
      player_name text,
      player_name_search tex...
      pg_restore: [archiver (db)] Error from TOC entry 1557; 1259 17075 TABLE settings postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: relation "settings" already exists
      Command was: CREATE TABLE settings (
      setting_name text NOT NULL,
      setting_value text NOT NULL
      );
      pg_restore: [archiver (db)] Error from TOC entry 1543; 1259 16940 TABLE tourney_holdem_blinds postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: relation "tourney_holdem_blinds" already exists
      Command was: CREATE TABLE tourney_holdem_blinds (
      id_blinds smallint NOT NULL,
      blinds_name text,
      amt_sb numeric(11,2),
      am...
      pg_restore: [archiver (db)] Error from TOC entry 1565; 1259 17311 TABLE tourney_holdem_cache postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: relation "tourney_holdem_cache" already exists
      Command was: CREATE TABLE tourney_holdem_cache (
      id_player integer NOT NULL,
      id_blinds integer NOT NULL,
      cnt_players integer ...
      pg_restore: [archiver (db)] Error from TOC entry 1547; 1259 16980 TABLE tourney_holdem_hand_histories postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: relation "tourney_holdem_hand_histories" already exists
      Command was: CREATE TABLE tourney_holdem_hand_histories (
      id_hand integer NOT NULL,
      history text
      );
      pg_restore: [archiver (db)] Error from TOC entry 1540; 1259 16710 TABLE tourney_holdem_hand_player_combinations postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: relation "tourney_holdem_hand_player_combinations" already exists
      Command was: CREATE TABLE tourney_holdem_hand_player_combinations (
      id_hand integer NOT NULL,
      id_player integer NOT NULL,
      flg...
      pg_restore: [archiver (db)] Error from TOC entry 1541; 1259 16766 TABLE tourney_holdem_hand_player_detail postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: relation "tourney_holdem_hand_player_detail" already exists
      Command was: CREATE TABLE tourney_holdem_hand_player_detail (
      id_hand integer NOT NULL,
      id_player integer NOT NULL,
      seat smal...
      pg_restore: [archiver (db)] Error from TOC entry 1542; 1259 16833 TABLE tourney_holdem_hand_player_statistics postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: relation "tourney_holdem_hand_player_statistics" already exists
      Command was: CREATE TABLE tourney_holdem_hand_player_statistics (
      id_hand integer NOT NULL,
      id_player integer NOT NULL,
      id_pl...
      pg_restore: [archiver (db)] Error from TOC entry 1539; 1259 16691 TABLE tourney_holdem_hand_summary postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: relation "tourney_holdem_hand_summary" already exists
      Command was: CREATE TABLE tourney_holdem_hand_summary (
      id_hand integer NOT NULL,
      id_site smallint NOT NULL,
      id_tourney integ...
      pg_restore: [archiver (db)] Error from TOC entry 1545; 1259 16961 TABLE tourney_holdem_results postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: relation "tourney_holdem_results" already exists
      Command was: CREATE TABLE tourney_holdem_results (
      id_tourney integer NOT NULL,
      id_site integer NOT NULL,
      id_player integer N...
      pg_restore: [archiver (db)] Error from TOC entry 1544; 1259 16948 TABLE tourney_holdem_summary postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: relation "tourney_holdem_summary" already exists
      Command was: CREATE TABLE tourney_holdem_summary (
      id_tourney integer NOT NULL,
      id_site smallint NOT NULL,
      id_table_type smal...
      pg_restore: [archiver (db)] Error from TOC entry 1546; 1259 16972 TABLE tourney_holdem_table postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: relation "tourney_holdem_table" already exists
      Command was: CREATE TABLE tourney_holdem_table (
      id_table integer NOT NULL,
      table_name text
      );
      pg_restore: [archiver (db)] Error from TOC entry 2163; 0 16659 TABLE DATA holdem_hand_histories postgres
      pg_restore: [archiver (db)] COPY failed: ERROR: duplicate key value violates unique constraint "holdem_hand_histories_primary_key"
      CONTEXT: COPY holdem_hand_histories, line 1: "1 EverestPoker Game #3415715261: Table Berlin-21 - $0.25/$0.50 - No Limit Hold'em - 15:41:55 - 2008/..."
      pg_restore: [archiver (db)] Error from TOC entry 2185; 0 17252 TABLE DATA holdem_hand_player_combinations postgres
      pg_restore: [archiver (db)] COPY failed: ERROR: duplicate key value violates unique constraint "holdem_hand_player_combinations_primary_key"
      CONTEXT: COPY holdem_hand_player_combinations, line 1: "15 1 f t f f f f f f f 2 0 1 f f f f f f 0 0 f t f f f f f f f 1 0 1 f f f f 0 0 f t f f f f f f f 1..."
      pg_restore: [archiver (db)] Error from TOC entry 2186; 0 17259 TABLE DATA holdem_hand_player_detail postgres
      pg_restore: [archiver (db)] COPY failed: ERROR: extra data after last expected column
      CONTEXT: COPY holdem_hand_player_detail, line 429614: "506410 4682 8 24 39 49.00 0.50 0.00 2.00 0.00 1.00 0.00 3.00 4 6 7 6 t f t f t f t f t f t f f 2.00 ..."
      pg_restore: [archiver (db)] Error from TOC entry 2187; 0 17266 TABLE DATA holdem_hand_player_statistics postgres
      pg_restore: [archiver (db)] COPY failed: ERROR: duplicate key value violates unique constraint "holdem_hand_player_statistics_primary_key"
      CONTEXT: COPY holdem_hand_player_statistics, line 1: "311072 32657 32657 0 1 102183 2008-11-05 12:52:07 0 f f 0 f 0 f t f f f 0 f 0 f f f f f 0 f 0 f f f ..."
      pg_restore: [archiver (db)] Error from TOC entry 2188; 0 17277 TABLE DATA holdem_hand_summary postgres
      pg_restore: [archiver (db)] COPY failed: ERROR: duplicate key value violates unique constraint "holdem_hand_summary_primary_key"
      CONTEXT: COPY holdem_hand_summary, line 1: "175411 100 1 620 15857732869 2008-03-09 19:40:25 2008-10-20 15:36:43 9 3 0 0 6.10 25.65 0.00 0.00 1...."
      pg_restore: [archiver (db)] Error from TOC entry 2164; 0 16667 TABLE DATA holdem_limit postgres
      pg_restore: [archiver (db)] COPY failed: ERROR: duplicate key value violates unique constraint "holdem_limit_primary_key"
      CONTEXT: COPY holdem_limit, line 1: "1 $0.50 NL 1.00 0.50 t 2"
      pg_restore: [archiver (db)] Error from TOC entry 2165; 0 16675 TABLE DATA holdem_table postgres
      pg_restore: [archiver (db)] COPY failed: ERROR: duplicate key value violates unique constraint "holdem_table_primary_key"
      CONTEXT: COPY holdem_table, line 1: "1 Berlin-21"
      pg_restore: [archiver (db)] Error from TOC entry 2189; 0 17287 TABLE DATA holdem_table_session_summary postgres
      pg_restore: [archiver (db)] COPY failed: ERROR: duplicate key value violates unique constraint "holdem_table_session_summary_primary_key"
      CONTEXT: COPY holdem_table_session_summary, line 1: "233268 500 1 1 1 7 2008-11-22 14:55:15 2008-11-22 15:37:33 43 6 212.75 19.25 2.50 0.97 46 5 413 0 f"
      pg_restore: [archiver (db)] Error from TOC entry 2182; 0 17048 TABLE DATA lookup_actions postgres
      pg_restore: [archiver (db)] COPY failed: ERROR: duplicate key value violates unique constraint "lookup_actions_primary_key"
      CONTEXT: COPY lookup_actions, line 70: "0 "
      pg_restore: [archiver (db)] Error from TOC entry 2177; 0 17004 TABLE DATA lookup_hand_groups postgres
      pg_restore: [archiver (db)] COPY failed: ERROR: duplicate key value violates unique constraint "lookup_hand_groups_primary_key"
      CONTEXT: COPY lookup_hand_groups, line 1: "1 Straight Flush"
      pg_restore: [archiver (db)] Error from TOC entry 2178; 0 17012 TABLE DATA lookup_hand_ranks postgres
      pg_restore: [archiver (db)] COPY failed: ERROR: duplicate key value violates unique constraint "lookup_hand_ranks_primary_key"
      CONTEXT: COPY lookup_hand_ranks, line 1: "1 1 Straight Flush Royal Flush"
      pg_restore: [archiver (db)] Error from TOC entry 2179; 0 17020 TABLE DATA lookup_hole_cards postgres
      pg_restore: [archiver (db)] COPY failed: ERROR: duplicate key value violates unique constraint "lookup_hole_cards_primary_key"
      CONTEXT: COPY lookup_hole_cards, line 1: "1 AA t f f f f 0"
      pg_restore: [archiver (db)] Error from TOC entry 2180; 0 17031 TABLE DATA lookup_positions postgres
      pg_restore: [archiver (db)] COPY failed: ERROR: duplicate key value violates unique constraint "lookup_positions_primary_key"
      CONTEXT: COPY lookup_positions, line 1: "2 0 BB t f f f"
      pg_restore: [archiver (db)] Error from TOC entry 2181; 0 17040 TABLE DATA lookup_sites postgres
      pg_restore: [archiver (db)] COPY failed: ERROR: duplicate key value violates unique constraint "lookup_sites_primary_key"
      CONTEXT: COPY lookup_sites, line 1: "100 PS PokerStars"
      pg_restore: [archiver (db)] Error from TOC entry 2175; 0 16988 TABLE DATA lookup_tourney_table_type postgres
      pg_restore: [archiver (db)] COPY failed: ERROR: duplicate key value violates unique constraint "lookup_tourney_table_type_primary_key"
      CONTEXT: COPY lookup_tourney_table_type, line 1: "0 N/A"
      pg_restore: [archiver (db)] Error from TOC entry 2176; 0 16996 TABLE DATA lookup_tourney_type postgres
      pg_restore: [archiver (db)] COPY failed: ERROR: duplicate key value violates unique constraint "lookup_tourney_type_primary_key"
      CONTEXT: COPY lookup_tourney_type, line 1: "0 N/A"
      pg_restore: [archiver (db)] Error from TOC entry 2190; 0 17294 TABLE DATA player postgres
      pg_restore: [archiver (db)] COPY failed: ERROR: duplicate key value violates unique constraint "player_primary_key"
      CONTEXT: COPY player, line 1: "0 0 [Split Pot] [Split Pot] 0 0 f"
      pg_restore: [archiver (db)] Error from TOC entry 2184; 0 17075 TABLE DATA settings postgres
      pg_restore: [archiver (db)] COPY failed: ERROR: duplicate key value violates unique constraint "settings_primary_key"
      CONTEXT: COPY settings, line 1: "nlpl_mult 2"
      pg_restore: [archiver (db)] Error from TOC entry 2170; 0 16940 TABLE DATA tourney_holdem_blinds postgres
      pg_restore: [archiver (db)] COPY failed: ERROR: duplicate key value violates unique constraint "tourney_holdem_blinds_id_blinds_primary_key"
      CONTEXT: COPY tourney_holdem_blinds, line 1: "1 15/30 NL 15.00 30.00 t 2"
      pg_restore: [archiver (db)] Error from TOC entry 2192; 0 17311 TABLE DATA tourney_holdem_cache postgres
      pg_restore: [archiver (db)] COPY failed: ERROR: duplicate key value violates unique constraint "tourney_holdem_cache_primary_key"
      CONTEXT: COPY tourney_holdem_cache, line 1: "22145 8 9 520 41 111 57 54 2 0 1 0 1 2 10 18 5 6 7 19 17 10 5 54 20 13 26 26 17 1 465 2 169 30 0 16 ..."
      pg_restore: [archiver (db)] Error from TOC entry 2174; 0 16980 TABLE DATA tourney_holdem_hand_histories postgres
      pg_restore: [archiver (db)] COPY failed: ERROR: duplicate key value violates unique constraint "tourney_holdem_hand_histories_primary_key"
      CONTEXT: COPY tourney_holdem_hand_histories, line 1: "1 Full Tilt Poker Game #6766651100: $1 + $0.25 Sit & Go (51433566), Table 1 - 15/30 - No Limit Hold'..."
      pg_restore: [archiver (db)] Error from TOC entry 2167; 0 16710 TABLE DATA tourney_holdem_hand_player_combinations postgres
      pg_restore: [archiver (db)] COPY failed: ERROR: duplicate key value violates unique constraint "tourney_holdem_hand_player_combinations_primary_key"
      CONTEXT: COPY tourney_holdem_hand_player_combinations, line 1: "25101 1555 t f f f f f f f f 2 0 0 f f f f f t 0 0 t f f f f f f f f 0 0 0 f f f f 0 0 f t f f f f f..."
      pg_restore: [archiver (db)] Error from TOC entry 2168; 0 16766 TABLE DATA tourney_holdem_hand_player_detail postgres
      pg_restore: [archiver (db)] COPY failed: ERROR: duplicate key value violates unique constraint "tourney_holdem_hand_player_primary_key"
      CONTEXT: COPY tourney_holdem_hand_player_detail, line 1: "25100 1555 9 0 0 1500.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1 0 0 0 f f f f f f f f f f f f f 90.00 ..."
      pg_restore: [archiver (db)] Error from TOC entry 2169; 0 16833 TABLE DATA tourney_holdem_hand_player_statistics postgres
      pg_restore: [archiver (db)] COPY failed: ERROR: duplicate key value violates unique constraint "tourney_holdem_hand_player_statistics_primary_key"
      CONTEXT: COPY tourney_holdem_hand_player_statistics, line 1: "25100 1555 1555 0 1 231 2008-08-15 09:40:58 0 f f 0 f 0 f t f f f 0 f 0 f f f f f 0 f 0 f f f f f 0 ..."
      pg_restore: [archiver (db)] Error from TOC entry 2166; 0 16691 TABLE DATA tourney_holdem_hand_summary postgres
      pg_restore: [archiver (db)] COPY failed: ERROR: duplicate key value violates unique constraint "tourney_holdem_hand_summary_primary_key"
      CONTEXT: COPY tourney_holdem_hand_summary, line 1: "1 300 1 1 995 6766651100 2008-06-10 07:13:10 2008-10-20 18:12:50 9 0 0 0 0.00 0.00 0.00 0.00 75.00 0..."
      pg_restore: [archiver (db)] Error from TOC entry 2172; 0 16961 TABLE DATA tourney_holdem_results postgres
      pg_restore: [archiver (db)] COPY failed: ERROR: duplicate key value violates unique constraint "tourney_holdem_results_primary_key"
      CONTEXT: COPY tourney_holdem_results, line 1: "231 300 1555 1555 2008-08-15 09:40:58 2008-08-15 10:15:35 5 0.00 0.00 0.00 0 0 0.00 f"
      pg_restore: [archiver (db)] Error from TOC entry 2171; 0 16948 TABLE DATA tourney_holdem_summary postgres
      pg_restore: [archiver (db)] COPY failed: ERROR: duplicate key value violates unique constraint "tourney_holdem_summary_primary_key"
      CONTEXT: COPY tourney_holdem_summary, line 1: "1 300 200 200 51433566 2008-06-10 07:13:00 2008-06-10 08:13:00 1.00 0.25 6766651100 6766895934 0 16..."
      pg_restore: [archiver (db)] Error from TOC entry 2145; 2606 17286 CONSTRAINT hhs-unique_hand_no postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: relation "hhs-unique_hand_no" already exists
      Command was: ALTER TABLE ONLY holdem_hand_summary
      ADD CONSTRAINT "hhs-unique_hand_no" UNIQUE (id_site, hand_no);
      pg_restore: [archiver (db)] Error from TOC entry 2160; 2606 17310 CONSTRAINT holdem_cache_primary_key postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: multiple primary keys for table "holdem_cache" are not allowed
      Command was: ALTER TABLE ONLY holdem_cache
      ADD CONSTRAINT holdem_cache_primary_key PRIMARY KEY (id_player, id_limit, cnt_players);
      pg_restore: [archiver (db)] Error from TOC entry 2066; 2606 16666 CONSTRAINT holdem_hand_histories_primary_key postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: multiple primary keys for table "holdem_hand_histories" are not allowed
      Command was: ALTER TABLE ONLY holdem_hand_histories
      ADD CONSTRAINT holdem_hand_histories_primary_key PRIMARY KEY (id_hand);
      pg_restore: [archiver (db)] Error from TOC entry 2131; 2606 43008 CONSTRAINT holdem_hand_player_combinations_primary_key postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: multiple primary keys for table "holdem_hand_player_combinations" are not allowed
      Command was: ALTER TABLE ONLY holdem_hand_player_combinations
      ADD CONSTRAINT holdem_hand_player_combinations_primary_key PRIMARY KEY ...
      pg_restore: [archiver (db)] Error from TOC entry 2135; 2606 43006 CONSTRAINT holdem_hand_player_detail_primary_key postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: multiple primary keys for table "holdem_hand_player_detail" are not allowed
      Command was: ALTER TABLE ONLY holdem_hand_player_detail
      ADD CONSTRAINT holdem_hand_player_detail_primary_key PRIMARY KEY (id_player, ...
      pg_restore: [archiver (db)] Error from TOC entry 2143; 2606 43004 CONSTRAINT holdem_hand_player_statistics_primary_key postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: multiple primary keys for table "holdem_hand_player_statistics" are not allowed
      Command was: ALTER TABLE ONLY holdem_hand_player_statistics
      ADD CONSTRAINT holdem_hand_player_statistics_primary_key PRIMARY KEY (id_...
      pg_restore: [archiver (db)] Error from TOC entry 2150; 2606 17284 CONSTRAINT holdem_hand_summary_primary_key postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: multiple primary keys for table "holdem_hand_summary" are not allowed
      Command was: ALTER TABLE ONLY holdem_hand_summary
      ADD CONSTRAINT holdem_hand_summary_primary_key PRIMARY KEY (id_hand);
      pg_restore: [archiver (db)] Error from TOC entry 2068; 2606 16674 CONSTRAINT holdem_limit_primary_key postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: multiple primary keys for table "holdem_limit" are not allowed
      Command was: ALTER TABLE ONLY holdem_limit
      ADD CONSTRAINT holdem_limit_primary_key PRIMARY KEY (id_limit);
      pg_restore: [archiver (db)] Error from TOC entry 2070; 2606 16682 CONSTRAINT holdem_table_primary_key postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: multiple primary keys for table "holdem_table" are not allowed
      Command was: ALTER TABLE ONLY holdem_table
      ADD CONSTRAINT holdem_table_primary_key PRIMARY KEY (id_table);
      pg_restore: [archiver (db)] Error from TOC entry 2152; 2606 17293 CONSTRAINT holdem_table_session_summary_primary_key postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: multiple primary keys for table "holdem_table_session_summary" are not allowed
      Command was: ALTER TABLE ONLY holdem_table_session_summary
      ADD CONSTRAINT holdem_table_session_summary_primary_key PRIMARY KEY (id_se...
      pg_restore: [archiver (db)] Error from TOC entry 2122; 2606 17055 CONSTRAINT lookup_actions_primary_key postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: multiple primary keys for table "lookup_actions" are not allowed
      Command was: ALTER TABLE ONLY lookup_actions
      ADD CONSTRAINT lookup_actions_primary_key PRIMARY KEY (id_action);
      pg_restore: [archiver (db)] Error from TOC entry 2112; 2606 17011 CONSTRAINT lookup_hand_groups_primary_key postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: multiple primary keys for table "lookup_hand_groups" are not allowed
      Command was: ALTER TABLE ONLY lookup_hand_groups
      ADD CONSTRAINT lookup_hand_groups_primary_key PRIMARY KEY (id_group);
      pg_restore: [archiver (db)] Error from TOC entry 2114; 2606 17019 CONSTRAINT lookup_hand_ranks_primary_key postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: multiple primary keys for table "lookup_hand_ranks" are not allowed
      Command was: ALTER TABLE ONLY lookup_hand_ranks
      ADD CONSTRAINT lookup_hand_ranks_primary_key PRIMARY KEY (id_hand_rank);
      pg_restore: [archiver (db)] Error from TOC entry 2116; 2606 17030 CONSTRAINT lookup_hole_cards_primary_key postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: multiple primary keys for table "lookup_hole_cards" are not allowed
      Command was: ALTER TABLE ONLY lookup_hole_cards
      ADD CONSTRAINT lookup_hole_cards_primary_key PRIMARY KEY (id_holecard);
      pg_restore: [archiver (db)] Error from TOC entry 2118; 2606 17039 CONSTRAINT lookup_positions_primary_key postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: multiple primary keys for table "lookup_positions" are not allowed
      Command was: ALTER TABLE ONLY lookup_positions
      ADD CONSTRAINT lookup_positions_primary_key PRIMARY KEY (cnt_players, "position");
      pg_restore: [archiver (db)] Error from TOC entry 2120; 2606 17047 CONSTRAINT lookup_sites_primary_key postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: multiple primary keys for table "lookup_sites" are not allowed
      Command was: ALTER TABLE ONLY lookup_sites
      ADD CONSTRAINT lookup_sites_primary_key PRIMARY KEY (id_site);
      pg_restore: [archiver (db)] Error from TOC entry 2108; 2606 16995 CONSTRAINT lookup_tourney_table_type_primary_key postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: multiple primary keys for table "lookup_tourney_table_type" are not allowed
      Command was: ALTER TABLE ONLY lookup_tourney_table_type
      ADD CONSTRAINT lookup_tourney_table_type_primary_key PRIMARY KEY (id_type);
      pg_restore: [archiver (db)] Error from TOC entry 2110; 2606 17003 CONSTRAINT lookup_tourney_type_primary_key postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: multiple primary keys for table "lookup_tourney_type" are not allowed
      Command was: ALTER TABLE ONLY lookup_tourney_type
      ADD CONSTRAINT lookup_tourney_type_primary_key PRIMARY KEY (id_type);
      pg_restore: [archiver (db)] Error from TOC entry 2125; 2606 17063 CONSTRAINT notes_primary_key postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: multiple primary keys for table "notes" are not allowed
      Command was: ALTER TABLE ONLY notes
      ADD CONSTRAINT notes_primary_key PRIMARY KEY (id_note);
      pg_restore: [archiver (db)] Error from TOC entry 2158; 2606 17302 CONSTRAINT player_primary_key postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: multiple primary keys for table "player" are not allowed
      Command was: ALTER TABLE ONLY player
      ADD CONSTRAINT player_primary_key PRIMARY KEY (id_player);
      pg_restore: [archiver (db)] Error from TOC entry 2127; 2606 17082 CONSTRAINT settings_primary_key postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: multiple primary keys for table "settings" are not allowed
      Command was: ALTER TABLE ONLY settings
      ADD CONSTRAINT settings_primary_key PRIMARY KEY (setting_name);
      pg_restore: [archiver (db)] Error from TOC entry 2072; 2606 16706 CONSTRAINT thhs-unique_hand_no postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: relation "thhs-unique_hand_no" already exists
      Command was: ALTER TABLE ONLY tourney_holdem_hand_summary
      ADD CONSTRAINT "thhs-unique_hand_no" UNIQUE (id_site, hand_no);
      pg_restore: [archiver (db)] Error from TOC entry 2094; 2606 16947 CONSTRAINT tourney_holdem_blinds_id_blinds_primary_key postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: multiple primary keys for table "tourney_holdem_blinds" are not allowed
      Command was: ALTER TABLE ONLY tourney_holdem_blinds
      ADD CONSTRAINT tourney_holdem_blinds_id_blinds_primary_key PRIMARY KEY (id_blinds);
      pg_restore: [archiver (db)] Error from TOC entry 2162; 2606 17315 CONSTRAINT tourney_holdem_cache_primary_key postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: multiple primary keys for table "tourney_holdem_cache" are not allowed
      Command was: ALTER TABLE ONLY tourney_holdem_cache
      ADD CONSTRAINT tourney_holdem_cache_primary_key PRIMARY KEY (id_player, id_blinds,...
      pg_restore: [archiver (db)] Error from TOC entry 2106; 2606 16987 CONSTRAINT tourney_holdem_hand_histories_primary_key postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: multiple primary keys for table "tourney_holdem_hand_histories" are not allowed
      Command was: ALTER TABLE ONLY tourney_holdem_hand_histories
      ADD CONSTRAINT tourney_holdem_hand_histories_primary_key PRIMARY KEY (id_...
      pg_restore: [archiver (db)] Error from TOC entry 2081; 2606 43010 CONSTRAINT tourney_holdem_hand_player_combinations_primary_key postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: multiple primary keys for table "tourney_holdem_hand_player_combinations" are not allowed
      Command was: ALTER TABLE ONLY tourney_holdem_hand_player_combinations
      ADD CONSTRAINT tourney_holdem_hand_player_combinations_primary_...
      pg_restore: [archiver (db)] Error from TOC entry 2085; 2606 43012 CONSTRAINT tourney_holdem_hand_player_detail_primary_key postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: multiple primary keys for table "tourney_holdem_hand_player_detail" are not allowed
      Command was: ALTER TABLE ONLY tourney_holdem_hand_player_detail
      ADD CONSTRAINT tourney_holdem_hand_player_detail_primary_key PRIMARY ...
      pg_restore: [archiver (db)] could not execute query: ERROR: index "tourney_holdem_hand_player_detail_primary_key" for table "tourney_holdem_hand_player_detail" does not exist
      Command was: ALTER TABLE tourney_holdem_hand_player_detail CLUSTER ON tourney_holdem_hand_player_detail_primary_key;
      pg_restore: [archiver (db)] Error from TOC entry 2092; 2606 43014 CONSTRAINT tourney_holdem_hand_player_statistics_primary_key postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: multiple primary keys for table "tourney_holdem_hand_player_statistics" are not allowed
      Command was: ALTER TABLE ONLY tourney_holdem_hand_player_statistics
      ADD CONSTRAINT tourney_holdem_hand_player_statistics_primary_key ...
      pg_restore: [archiver (db)] Error from TOC entry 2077; 2606 16704 CONSTRAINT tourney_holdem_hand_summary_primary_key postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: multiple primary keys for table "tourney_holdem_hand_summary" are not allowed
      Command was: ALTER TABLE ONLY tourney_holdem_hand_summary
      ADD CONSTRAINT tourney_holdem_hand_summary_primary_key PRIMARY KEY (id_hand);
      pg_restore: [archiver (db)] Error from TOC entry 2102; 2606 16969 CONSTRAINT tourney_holdem_results_primary_key postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: multiple primary keys for table "tourney_holdem_results" are not allowed
      Command was: ALTER TABLE ONLY tourney_holdem_results
      ADD CONSTRAINT tourney_holdem_results_primary_key PRIMARY KEY (id_tourney, id_pl...
      pg_restore: [archiver (db)] Error from TOC entry 2098; 2606 16958 CONSTRAINT tourney_holdem_summary_primary_key postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: multiple primary keys for table "tourney_holdem_summary" are not allowed
      Command was: ALTER TABLE ONLY tourney_holdem_summary
      ADD CONSTRAINT tourney_holdem_summary_primary_key PRIMARY KEY (id_tourney);
      pg_restore: [archiver (db)] Error from TOC entry 2104; 2606 16979 CONSTRAINT tourney_holdem_table_primary_key postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: multiple primary keys for table "tourney_holdem_table" are not allowed
      Command was: ALTER TABLE ONLY tourney_holdem_table
      ADD CONSTRAINT tourney_holdem_table_primary_key PRIMARY KEY (id_table);
      pg_restore: [archiver (db)] Error from TOC entry 2128; 1259 17255 INDEX hhpc:idx1-id_hand postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: relation "hhpc:idx1-id_hand" already exists
      Command was: CREATE INDEX "hhpc:idx1-id_hand" ON holdem_hand_player_combinations USING btree (id_hand);
      pg_restore: [archiver (db)] Error from TOC entry 2129; 1259 43015 INDEX hhpc:idx2-id_player postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: relation "hhpc:idx2-id_player" already exists
      Command was: CREATE INDEX "hhpc:idx2-id_player" ON holdem_hand_player_combinations USING btree (id_player);
      pg_restore: [archiver (db)] Error from TOC entry 2132; 1259 17262 INDEX hhpd:idx1-id_hand postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: relation "hhpd:idx1-id_hand" already exists
      Command was: CREATE INDEX "hhpd:idx1-id_hand" ON holdem_hand_player_detail USING btree (id_hand);
      pg_restore: [archiver (db)] Error from TOC entry 2133; 1259 17263 INDEX hhpd:idx2-id_player postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: relation "hhpd:idx2-id_player" already exists
      Command was: CREATE INDEX "hhpd:idx2-id_player" ON holdem_hand_player_detail USING btree (id_player);
      pg_restore: [archiver (db)] Error from TOC entry 2136; 1259 17269 INDEX hhps:idx1-id_hand postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: relation "hhps:idx1-id_hand" already exists
      Command was: CREATE INDEX "hhps:idx1-id_hand" ON holdem_hand_player_statistics USING btree (id_hand);
      pg_restore: [archiver (db)] Error from TOC entry 2137; 1259 17270 INDEX hhps:idx2-id_player postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: relation "hhps:idx2-id_player" already exists
      Command was: CREATE INDEX "hhps:idx2-id_player" ON holdem_hand_player_statistics USING btree (id_player);
      pg_restore: [archiver (db)] Error from TOC entry 2138; 1259 17271 INDEX hhps:idx3-id_limit postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: relation "hhps:idx3-id_limit" already exists
      Command was: CREATE INDEX "hhps:idx3-id_limit" ON holdem_hand_player_statistics USING btree (id_limit);
      pg_restore: [archiver (db)] Error from TOC entry 2139; 1259 17272 INDEX hhps:idx4-date_played postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: relation "hhps:idx4-date_played" already exists
      Command was: CREATE INDEX "hhps:idx4-date_played" ON holdem_hand_player_statistics USING btree (date_played);
      pg_restore: [archiver (db)] Error from TOC entry 2140; 1259 17273 INDEX hhps:idx5-id_session postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: relation "hhps:idx5-id_session" already exists
      Command was: CREATE INDEX "hhps:idx5-id_session" ON holdem_hand_player_statistics USING btree (id_session);
      pg_restore: [archiver (db)] Error from TOC entry 2141; 1259 17274 INDEX hhps:idx6-position postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: relation "hhps:idx6-position" already exists
      Command was: CREATE INDEX "hhps:idx6-position" ON holdem_hand_player_statistics USING btree ("position");
      pg_restore: [archiver (db)] Error from TOC entry 2146; 1259 17280 INDEX hhs:idx1-date_played postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: relation "hhs:idx1-date_played" already exists
      Command was: CREATE INDEX "hhs:idx1-date_played" ON holdem_hand_summary USING btree (date_played);
      pg_restore: [archiver (db)] Error from TOC entry 2147; 1259 17281 INDEX hhs:idx2-id_limit postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: relation "hhs:idx2-id_limit" already exists
      Command was: CREATE INDEX "hhs:idx2-id_limit" ON holdem_hand_summary USING btree (id_limit);
      pg_restore: [archiver (db)] Error from TOC entry 2148; 1259 17282 INDEX hhs:idx3-hand_no postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: relation "hhs:idx3-hand_no" already exists
      Command was: CREATE INDEX "hhs:idx3-hand_no" ON holdem_hand_summary USING btree (hand_no);
      pg_restore: [archiver (db)] Error from TOC entry 2153; 1259 17290 INDEX htss:idx1-id_player postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: relation "htss:idx1-id_player" already exists
      Command was: CREATE INDEX "htss:idx1-id_player" ON holdem_table_session_summary USING btree (id_player);
      pg_restore: [archiver (db)] Error from TOC entry 2154; 1259 17291 INDEX htss:idx2-id_table postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: relation "htss:idx2-id_table" already exists
      Command was: CREATE INDEX "htss:idx2-id_table" ON holdem_table_session_summary USING btree (id_table);
      pg_restore: [archiver (db)] Error from TOC entry 2155; 1259 43016 INDEX htss:idx3-date_start postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: relation "htss:idx3-date_start" already exists
      Command was: CREATE INDEX "htss:idx3-date_start" ON holdem_table_session_summary USING btree (date_start);
      pg_restore: [archiver (db)] Error from TOC entry 2123; 1259 17064 INDEX idx1:notes-id_x postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: relation "idx1:notes-id_x" already exists
      Command was: CREATE INDEX "idx1:notes-id_x" ON notes USING btree (id_x);
      pg_restore: [archiver (db)] Error from TOC entry 2156; 1259 17300 INDEX idx1:player_name_search postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: relation "idx1:player_name_search" already exists
      Command was: CREATE INDEX "idx1:player_name_search" ON player USING btree (player_name_search);
      pg_restore: [archiver (db)] Error from TOC entry 2078; 1259 16765 INDEX thhpc:idx1-id_hand postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: relation "thhpc:idx1-id_hand" already exists
      Command was: CREATE INDEX "thhpc:idx1-id_hand" ON tourney_holdem_hand_player_combinations USING btree (id_hand);
      pg_restore: [archiver (db)] Error from TOC entry 2079; 1259 43017 INDEX thhpc:idx1-id_player postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: relation "thhpc:idx1-id_player" already exists
      Command was: CREATE INDEX "thhpc:idx1-id_player" ON tourney_holdem_hand_player_combinations USING btree (id_player);
      pg_restore: [archiver (db)] Error from TOC entry 2082; 1259 16831 INDEX thhpd:idx1-id_hand postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: relation "thhpd:idx1-id_hand" already exists
      Command was: CREATE INDEX "thhpd:idx1-id_hand" ON tourney_holdem_hand_player_detail USING btree (id_hand);
      pg_restore: [archiver (db)] Error from TOC entry 2083; 1259 16832 INDEX thhpd:idx2-id_player postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: relation "thhpd:idx2-id_player" already exists
      Command was: CREATE INDEX "thhpd:idx2-id_player" ON tourney_holdem_hand_player_detail USING btree (id_player);
      pg_restore: [archiver (db)] Error from TOC entry 2086; 1259 16935 INDEX thhps:idx1-id_hand postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: relation "thhps:idx1-id_hand" already exists
      Command was: CREATE INDEX "thhps:idx1-id_hand" ON tourney_holdem_hand_player_statistics USING btree (id_hand);
      pg_restore: [archiver (db)] Error from TOC entry 2087; 1259 16936 INDEX thhps:idx2-id_player postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: relation "thhps:idx2-id_player" already exists
      Command was: CREATE INDEX "thhps:idx2-id_player" ON tourney_holdem_hand_player_statistics USING btree (id_player);
      pg_restore: [archiver (db)] Error from TOC entry 2088; 1259 16937 INDEX thhps:idx3-id_blinds postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: relation "thhps:idx3-id_blinds" already exists
      Command was: CREATE INDEX "thhps:idx3-id_blinds" ON tourney_holdem_hand_player_statistics USING btree (id_blinds);
      pg_restore: [archiver (db)] Error from TOC entry 2089; 1259 16938 INDEX thhps:idx4-date_played postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: relation "thhps:idx4-date_played" already exists
      Command was: CREATE INDEX "thhps:idx4-date_played" ON tourney_holdem_hand_player_statistics USING btree (date_played);
      pg_restore: [archiver (db)] Error from TOC entry 2090; 1259 16939 INDEX thhps:idx5-position postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: relation "thhps:idx5-position" already exists
      Command was: CREATE INDEX "thhps:idx5-position" ON tourney_holdem_hand_player_statistics USING btree ("position");
      pg_restore: [archiver (db)] Error from TOC entry 2073; 1259 16707 INDEX thhs:idx1-date_played postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: relation "thhs:idx1-date_played" already exists
      Command was: CREATE INDEX "thhs:idx1-date_played" ON tourney_holdem_hand_summary USING btree (date_played);
      pg_restore: [archiver (db)] Error from TOC entry 2074; 1259 16708 INDEX thhs:idx2-id_blinds postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: relation "thhs:idx2-id_blinds" already exists
      Command was: CREATE INDEX "thhs:idx2-id_blinds" ON tourney_holdem_hand_summary USING btree (id_blinds);
      pg_restore: [archiver (db)] Error from TOC entry 2075; 1259 16709 INDEX thhs:idx3-hand_no postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: relation "thhs:idx3-hand_no" already exists
      Command was: CREATE INDEX "thhs:idx3-hand_no" ON tourney_holdem_hand_summary USING btree (hand_no);
      pg_restore: [archiver (db)] Error from TOC entry 2099; 1259 16970 INDEX thr:idx1-id_site postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: relation "thr:idx1-id_site" already exists
      Command was: CREATE INDEX "thr:idx1-id_site" ON tourney_holdem_results USING btree (id_site);
      pg_restore: [archiver (db)] Error from TOC entry 2100; 1259 16971 INDEX thr:idx2-id_player postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: relation "thr:idx2-id_player" already exists
      Command was: CREATE INDEX "thr:idx2-id_player" ON tourney_holdem_results USING btree (id_player);
      pg_restore: [archiver (db)] Error from TOC entry 2095; 1259 16959 INDEX ths:idx1-date_start postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: relation "ths:idx1-date_start" already exists
      Command was: CREATE INDEX "ths:idx1-date_start" ON tourney_holdem_summary USING btree (date_start);
      pg_restore: [archiver (db)] Error from TOC entry 2096; 1259 16960 INDEX ths:idx2-id_site postgres
      pg_restore: [archiver (db)] could not execute query: ERROR: relation "ths:idx2-id_site" already exists
      Command was: CREATE INDEX "ths:idx2-id_site" ON tourney_holdem_summary USING btree (id_site);
      WARNING: errors ignored on restore: 124

      Prozess beendete mit Exitcode 1.
  • 11 Antworten
    • netsrak
      netsrak
      Gold
      Dabei seit: 11.03.2006 Beiträge: 37.246
      Hört sich so an als ob die Datenbank schon existiert.
      Im pgadmin nochmal löschen,
      leere neue Datenbank mit Namen PT3 oder was auch immer anlegen und dann den Restore in diese neue DB ausführen
    • circe
      circe
      Bronze
      Dabei seit: 18.03.2005 Beiträge: 1.495
      Hallöchen,

      besten Dank für die Antwort. Die Zahl der Fehlermeldungen ist nun deutlich zurückgegangen.

      Das sieht nun mittlerweile so aus:

      C:\Programme\PostgreSQL\8.3\bin\pg_restore.exe -h localhost -p 5432 -U postgres -d test "C:\Dokumente und Einstellungen\Christian\Desktop\my_handhistories_08_02_2009.backup"
      pg_restore: [archiver (db)] Error while PROCESSING TOC:
      pg_restore: [archiver (db)] Error from TOC entry 2186; 0 17259 TABLE DATA holdem_hand_player_detail postgres
      pg_restore: [archiver (db)] COPY failed: ERROR: extra data after last expected column
      CONTEXT: COPY holdem_hand_player_detail, line 429614: "506410 4682 8 24 39 49.00 0.50 0.00 2.00 0.00 1.00 0.00 3.00 4 6 7 6 t f t f t f t f t f t f f 2.00 ..."
      WARNING: errors ignored on restore: 1

      Prozess beendete mit Exitcode 1.


      Was könnte ich sonst noch versuchen, um die Fehler zu beseitigen?

      Liebe Grüße

      Christian
    • MrQNo
      MrQNo
      Bronze
      Dabei seit: 30.09.2006 Beiträge: 1.898
      Da geht wohl nicht viel ... Aus irgendwelchen Gründen passt diese eine Zeile des Backups nicht zur Datenbank. Es ist mir zwar unverständlich, wie so etwas passieren kann, aber anscheinend geht es.

      Lösungsversuch: Such im Backup die Zeile, die mit COPY holdem_hand_player_detail, line 429614: "506410 4682 8 24 39 49.00 0.50 0.00 2.00 0.00 1.00 0.00 3.00 4 6 7 6 t f t f t f t f t f t f f 2.00 beginnt (die ... sind wohl eine von der Fehlermeldung erzeugte Abkürzung), und lösch diese Zeile. Wenns danach geht, hast du Glück gehabt. Wenn nicht, können dir nur die Spezialisten helfen.
    • circe
      circe
      Bronze
      Dabei seit: 18.03.2005 Beiträge: 1.495
      Das ist also so gedacht, daß ich mit einem Binäreditor dieses Backup bearbeiten soll? Ich habe bisher 2 Editoren getestet, jedoch konnte keiner von beiden das große Backup laden.

      Da habe ich mir mühsam eine sehr große Sammlung von Händen aufgebaut (3,91 GB) und wegen eines Restore Problems soll das nun alles futsch sein?

      Das Backup dürfte ok sein, es scheitert jedoch an der Wiederherstellung. Die ganze mühevolle Arbeit soll umsonst gewesen sein?

      Bin diesbezüglich derzeit ziemlich angenervt.

      Liebe Grüße

      Christian
    • Ajezz
      Ajezz
      Black
      Dabei seit: 19.07.2005 Beiträge: 10.245
      Poste mal im SQL-Bereich des PT-Forums.
    • circe
      circe
      Bronze
      Dabei seit: 18.03.2005 Beiträge: 1.495
      Original von Ajezz
      Poste mal im SQL-Bereich des PT-Forums.
      Hallöchen,

      wo bitte befindet sich der SQL Teil des PT Forums?

      Meinst Du evtl. die SQL Einführung in der Rubrik "wichtige Links" ?

      Liebe Grüße


      Christian
    • Ajezz
      Ajezz
      Black
      Dabei seit: 19.07.2005 Beiträge: 10.245
      http://www.pokertracker.com/forums/viewforum.php?f=17
    • circe
      circe
      Bronze
      Dabei seit: 18.03.2005 Beiträge: 1.495
      Original von Ajezz
      http://www.pokertracker.com/forums/viewforum.php?f=17
      Besten Dank für den Link. Ich habe dieses Forum bei ps.de vermutet und deswegen zunächst vergeblich danach gesucht.

      Liebe Grüße

      Christian
    • Ajezz
      Ajezz
      Black
      Dabei seit: 19.07.2005 Beiträge: 10.245
      Deswegen hatte ich auch "PT-Forum" geschrieben. =)
    • circe
      circe
      Bronze
      Dabei seit: 18.03.2005 Beiträge: 1.495
      Original von Ajezz
      Deswegen hatte ich auch "PT-Forum" geschrieben. =)
      Auch bei ps.de gibt es ein PT Forum. Remis?

      Liebe Grüßé

      Christian
    • Ajezz
      Ajezz
      Black
      Dabei seit: 19.07.2005 Beiträge: 10.245
      Gut, remis. ;)