失敗（退出程式碼：1）。從 pgAdmin4 postgresql 10.5 中的 .tar 文件執行恢復數據庫時

我正在學習 SQL 課程的介紹，但我無法載入我的第一個數據庫。我有一個文件 dvdrental.tar，我創建了一個新的數據庫 dvdrental > 右鍵點擊 > 還原 > 選擇文件 > 在還原選項下選擇“數據”，我收到以下錯誤。

我在 Mac OSX 上，如果有幫助的話，pgAmin 實例正在載入到 Chrome 中。我嘗試過兩次刪除和重新添加數據庫，但仍然出現相同的錯誤。我還嘗試重新安裝 pgAdmin 並完全重新安裝 postgresql，包括刪除使用者帳戶。我剛剛嘗試在 Windows 環境中進行全新安裝，但我得到了完全相同的錯誤。

從那以後，我也多次完全重新啟動電腦。我還驗證了其他 tar 文件和 sql 文件不起作用。

這是完整的錯誤，我不知道它是什麼意思，因為我是 SQL 的新手，只是設置它：

/Library/PostgreSQL/10/bin/pg_restore --host "localhost" --port "5432" --username "postgres" --no-password --dbname "dvdrental" --section=data --verbose "/Users/chasehippen/Downloads/Postgresql/dvdrental.tar"

   pg_restore: connecting to database for restore
   pg_restore: implied data-only restore
   pg_restore: processing data for table "public.actor"
   pg_restore: [archiver (db)] Error while PROCESSING TOC:
   pg_restore: [archiver (db)] Error from TOC entry 2610; 0 16430 TABLE DATA actor postgres
   pg_restore: [archiver (db)] could not execute query: ERROR:  relation "actor" does not exist
       Command was: COPY actor (actor_id, first_name, last_name, last_update) FROM stdin;
   pg_restore: executing SEQUENCE SET actor_actor_id_seq
   pg_restore: [archiver (db)] Error from TOC entry 2643; 0 0 SEQUENCE SET actor_actor_id_seq postgres
   pg_restore: [archiver (db)] could not execute query: ERROR:  relation "actor_actor_id_seq" does not exist
   LINE 1: SELECT pg_catalog.setval('actor_actor_id_seq', 200, true);
                                    ^
       Command was: SELECT pg_catalog.setval('actor_actor_id_seq', 200, true);
   pg_restore: processing data for table "public.address"
   pg_restore: [archiver (db)] Error from TOC entry 2618; 0 16471 TABLE DATA address postgres
   pg_restore: [archiver (db)] could not execute query: ERROR:  relation "address" does not exist
       Command was: COPY address (address_id, address, address2, district, city_id, postal_code, phone, last_update) FROM stdin;
   pg_restore: executing SEQUENCE SET address_address_id_seq
   pg_restore: [archiver (db)] Error from TOC entry 2644; 0 0 SEQUENCE SET address_address_id_seq postgres
   pg_restore: [archiver (db)] could not execute query: ERROR:  relation "address_address_id_seq" does not exist
   LINE 1: SELECT pg_catalog.setval('address_address_id_seq', 605, true...
                                    ^
       Command was: SELECT pg_catalog.setval('address_address_id_seq', 605, true);
   pg_restore: processing data for table "public.category"
   pg_restore: [archiver (db)] Error from TOC entry 2612; 0 16437 TABLE DATA category postgres
   pg_restore: [archiver (db)] could not execute query: ERROR:  relation "category" does not exist
       Command was: COPY category (category_id, name, last_update) FROM stdin;
   pg_restore: executing SEQUENCE SET category_category_id_seq
   pg_restore: [archiver (db)] Error from TOC entry 2645; 0 0 SEQUENCE SET category_category_id_seq postgres
   pg_restore: [archiver (db)] could not execute query: ERROR:  relation "category_category_id_seq" does not exist
   LINE 1: SELECT pg_catalog.setval('category_category_id_seq', 16, tru...
                                    ^
       Command was: SELECT pg_catalog.setval('category_category_id_seq', 16, true);
   pg_restore: processing data for table "public.city"
   pg_restore: [archiver (db)] Error from TOC entry 2620; 0 16478 TABLE DATA city postgres
   pg_restore: [archiver (db)] could not execute query: ERROR:  relation "city" does not exist
       Command was: COPY city (city_id, city, country_id, last_update) FROM stdin;
   pg_restore: executing SEQUENCE SET city_city_id_seq
   pg_restore: [archiver (db)] Error from TOC entry 2646; 0 0 SEQUENCE SET city_city_id_seq postgres
   pg_restore: [archiver (db)] could not execute query: ERROR:  relation "city_city_id_seq" does not exist
   LINE 1: SELECT pg_catalog.setval('city_city_id_seq', 600, true);
                                    ^
       Command was: SELECT pg_catalog.setval('city_city_id_seq', 600, true);
   pg_restore: processing data for table "public.country"
   pg_restore: [archiver (db)] Error from TOC entry 2622; 0 16485 TABLE DATA country postgres
   pg_restore: [archiver (db)] could not execute query: ERROR:  relation "country" does not exist
       Command was: COPY country (country_id, country, last_update) FROM stdin;
   pg_restore: executing SEQUENCE SET country_country_id_seq
   pg_restore: [archiver (db)] Error from TOC entry 2647; 0 0 SEQUENCE SET country_country_id_seq postgres
   pg_restore: [archiver (db)] could not execute query: ERROR:  relation "country_country_id_seq" does not exist
   LINE 1: SELECT pg_catalog.setval('country_country_id_seq', 109, true...
                                    ^
       Command was: SELECT pg_catalog.setval('country_country_id_seq', 109, true);
   pg_restore: processing data for table "public.customer"
   pg_restore: [archiver (db)] Error from TOC entry 2608; 0 16419 TABLE DATA customer postgres
   pg_restore: [archiver (db)] could not execute query: ERROR:  relation "customer" does not exist
       Command was: COPY customer (customer_id, store_id, first_name, last_name, email, address_id, activebool, create_date, last_update, active) FROM stdin;
   pg_restore: executing SEQUENCE SET customer_customer_id_seq
   pg_restore: [archiver (db)] Error from TOC entry 2648; 0 0 SEQUENCE SET customer_customer_id_seq postgres
   pg_restore: [archiver (db)] could not execute query: ERROR:  relation "customer_customer_id_seq" does not exist
   LINE 1: SELECT pg_catalog.setval('customer_customer_id_seq', 599, tr...
                                    ^
       Command was: SELECT pg_catalog.setval('customer_customer_id_seq', 599, true);
   pg_restore: processing data for table "public.film"
   pg_restore: [archiver (db)] Error from TOC entry 2614; 0 16444 TABLE DATA film postgres
   pg_restore: [archiver (db)] could not execute query: ERROR:  relation "film" does not exist
       Command was: COPY film (film_id, title, description, release_year, language_id, rental_duration, rental_rate, length, replacement_cost, rating, last_update, special_features, fulltext) FROM stdin;
   pg_restore: processing data for table "public.film_actor"
   pg_restore: [archiver (db)] Error from TOC entry 2615; 0 16456 TABLE DATA film_actor postgres
   pg_restore: [archiver (db)] could not execute query: ERROR:  relation "film_actor" does not exist
       Command was: COPY film_actor (actor_id, film_id, last_update) FROM stdin;
   pg_restore: processing data for table "public.film_category"
   pg_restore: [archiver (db)] Error from TOC entry 2616; 0 16460 TABLE DATA film_category postgres
   pg_restore: [archiver (db)] could not execute query: ERROR:  relation "film_category" does not exist
       Command was: COPY film_category (film_id, category_id, last_update) FROM stdin;
   pg_restore: executing SEQUENCE SET film_film_id_seq
   pg_restore: [archiver (db)] Error from TOC entry 2649; 0 0 SEQUENCE SET film_film_id_seq postgres
   pg_restore: [archiver (db)] could not execute query: ERROR:  relation "film_film_id_seq" does not exist
   LINE 1: SELECT pg_catalog.setval('film_film_id_seq', 1000, true);
                                    ^
       Command was: SELECT pg_catalog.setval('film_film_id_seq', 1000, true);
   pg_restore: processing data for table "public.inventory"
   pg_restore: [archiver (db)] Error from TOC entry 2624; 0 16502 TABLE DATA inventory postgres
   pg_restore: [archiver (db)] could not execute query: ERROR:  relation "inventory" does not exist
       Command was: COPY inventory (inventory_id, film_id, store_id, last_update) FROM stdin;
   pg_restore: executing SEQUENCE SET inventory_inventory_id_seq
   pg_restore: [archiver (db)] Error from TOC entry 2650; 0 0 SEQUENCE SET inventory_inventory_id_seq postgres
   pg_restore: [archiver (db)] could not execute query: ERROR:  relation "inventory_inventory_id_seq" does not exist
   LINE 1: SELECT pg_catalog.setval('inventory_inventory_id_seq', 4581,...
                                    ^
       Command was: SELECT pg_catalog.setval('inventory_inventory_id_seq', 4581, true);
   pg_restore: processing data for table "public.language"
   pg_restore: [archiver (db)] Error from TOC entry 2626; 0 16509 TABLE DATA language postgres
   pg_restore: [archiver (db)] could not execute query: ERROR:  relation "language" does not exist
       Command was: COPY language (language_id, name, last_update) FROM stdin;
   pg_restore: executing SEQUENCE SET language_language_id_seq
   pg_restore: [archiver (db)] Error from TOC entry 2651; 0 0 SEQUENCE SET language_language_id_seq postgres
   pg_restore: [archiver (db)] could not execute query: ERROR:  relation "language_language_id_seq" does not exist
   LINE 1: SELECT pg_catalog.setval('language_language_id_seq', 6, true...
                                    ^
       Command was: SELECT pg_catalog.setval('language_language_id_seq', 6, true);
   pg_restore: processing data for table "public.payment"
   pg_restore: [archiver (db)] Error from TOC entry 2628; 0 16521 TABLE DATA payment postgres
   pg_restore: [archiver (db)] could not execute query: ERROR:  relation "payment" does not exist
       Command was: COPY payment (payment_id, customer_id, staff_id, rental_id, amount, payment_date) FROM stdin;
   pg_restore: executing SEQUENCE SET payment_payment_id_seq
   pg_restore: [archiver (db)] Error from TOC entry 2652; 0 0 SEQUENCE SET payment_payment_id_seq postgres
   pg_restore: [archiver (db)] could not execute query: ERROR:  relation "payment_payment_id_seq" does not exist
   LINE 1: SELECT pg_catalog.setval('payment_payment_id_seq', 32098, tr...
                                    ^
       Command was: SELECT pg_catalog.setval('payment_payment_id_seq', 32098, true);
   pg_restore: processing data for table "public.rental"
   pg_restore: [archiver (db)] Error from TOC entry 2630; 0 16527 TABLE DATA rental postgres
   pg_restore: [archiver (db)] could not execute query: ERROR:  relation "rental" does not exist
       Command was: COPY rental (rental_id, rental_date, inventory_id, customer_id, return_date, staff_id, last_update) FROM stdin;
   pg_restore: executing SEQUENCE SET rental_rental_id_seq
   pg_restore: [archiver (db)] Error from TOC entry 2653; 0 0 SEQUENCE SET rental_rental_id_seq postgres
   pg_restore: [archiver (db)] could not execute query: ERROR:  relation "rental_rental_id_seq" does not exist
   LINE 1: SELECT pg_catalog.setval('rental_rental_id_seq', 16049, true...
                                    ^
       Command was: SELECT pg_catalog.setval('rental_rental_id_seq', 16049, true);
   pg_restore: processing data for table "public.staff"
   pg_restore: [archiver (db)] Error from TOC entry 2632; 0 16539 TABLE DATA staff postgres
   pg_restore: [archiver (db)] could not execute query: ERROR:  relation "staff" does not exist
       Command was: COPY staff (staff_id, first_name, last_name, address_id, email, store_id, active, username, password, last_update, picture) FROM stdin;
   pg_restore: executing SEQUENCE SET staff_staff_id_seq
   pg_restore: [archiver (db)] Error from TOC entry 2654; 0 0 SEQUENCE SET staff_staff_id_seq postgres
   pg_restore: [archiver (db)] could not execute query: ERROR:  relation "staff_staff_id_seq" does not exist
   LINE 1: SELECT pg_catalog.setval('staff_staff_id_seq', 2, true);
                                    ^
       Command was: SELECT pg_catalog.setval('staff_staff_id_seq', 2, true);
   pg_restore: processing data for table "public.store"
   pg_restore: [archiver (db)] Error from TOC entry 2634; 0 16550 TABLE DATA store postgres
   pg_restore: [archiver (db)] could not execute query: ERROR:  relation "store" does not exist
       Command was: COPY store (store_id, manager_staff_id, address_id, last_update) FROM stdin;
   pg_restore: executing SEQUENCE SET store_store_id_seq
   pg_restore: [archiver (db)] Error from TOC entry 2655; 0 0 SEQUENCE SET store_store_id_seq postgres
   pg_restore: [archiver (db)] could not execute query: ERROR:  relation "store_store_id_seq" does not exist
   LINE 1: SELECT pg_catalog.setval('store_store_id_seq', 2, true);
                                    ^
       Command was: SELECT pg_catalog.setval('store_store_id_seq', 2, true);
   WARNING: errors ignored on restore: 28

通過取消選中數據選項解決

引用自：https://dba.stackexchange.com/questions/214640