pg_store with example.dump failed

[molinjun]

I have installed pg with docker locally, and I can access it successfully. I have created the user craig ，database pgguide。However, when I restore the dump file as sub command, I encounter with a error。

 $ pg_restore --no-owner -h localhost --dbname pgguide example.dump
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 2251; 0 0 COMMENT EXTENSION plpgsql
pg_restore: [archiver (db)] could not execute query: ERROR:  must be owner of extension plpgsql
    Command was: COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';



pg_restore: [archiver (db)] Error from TOC entry 2252; 0 0 COMMENT EXTENSION hstore
pg_restore: [archiver (db)] could not execute query: ERROR:  must be owner of extension hstore
    Command was: COMMENT ON EXTENSION hstore IS 'data type for storing sets of (key, value) pairs';



pg_restore: [archiver (db)] Error from TOC entry 166; 1259 444692 TABLE products craig
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "products" already exists
    Command was: CREATE TABLE products (
    id integer NOT NULL,
    title character varying(255),
    price numeric,
    created_at timesta...
pg_restore: [archiver (db)] Error from TOC entry 165; 1259 444690 SEQUENCE products_id_seq craig
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "products_id_seq" already exists
    Command was: CREATE SEQUENCE products_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;



pg_restore: [archiver (db)] Error from TOC entry 2253; 0 0 SEQUENCE OWNED BY products_id_seq craig
pg_restore: [archiver (db)] could not execute query: ERROR:  must be owner of relation products_id_seq
    Command was: ALTER SEQUENCE products_id_seq OWNED BY products.id;



pg_restore: [archiver (db)] Error from TOC entry 2254; 0 0 SEQUENCE SET products_id_seq craig
pg_restore: [archiver (db)] could not execute query: ERROR:  permission denied for sequence products_id_seq
    Command was: SELECT pg_catalog.setval('products_id_seq', 20, true);



pg_restore: [archiver (db)] Error from TOC entry 168; 1259 444703 TABLE purchase_items craig
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "purchase_items" already exists
    Command was: CREATE TABLE purchase_items (
    id integer NOT NULL,
    purchase_id integer,
    product_id integer,
    price numeric,
 ...
pg_restore: [archiver (db)] Error from TOC entry 167; 1259 444701 SEQUENCE purchase_items_id_seq craig
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "purchase_items_id_seq" already exists
    Command was: CREATE SEQUENCE purchase_items_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;



pg_restore: [archiver (db)] Error from TOC entry 2255; 0 0 SEQUENCE OWNED BY purchase_items_id_seq craig
pg_restore: [archiver (db)] could not execute query: ERROR:  must be owner of relation purchase_items_id_seq
    Command was: ALTER SEQUENCE purchase_items_id_seq OWNED BY purchase_items.id;



pg_restore: [archiver (db)] Error from TOC entry 2256; 0 0 SEQUENCE SET purchase_items_id_seq craig
pg_restore: [archiver (db)] could not execute query: ERROR:  permission denied for sequence purchase_items_id_seq
    Command was: SELECT pg_catalog.setval('purchase_items_id_seq', 1458, true);



pg_restore: [archiver (db)] Error from TOC entry 162; 1259 444669 TABLE purchases craig
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "purchases" already exists
    Command was: CREATE TABLE purchases (
    id integer NOT NULL,
    created_at timestamp with time zone,
    name character varying(255),
...
pg_restore: [archiver (db)] Error from TOC entry 161; 1259 444667 SEQUENCE purchases_id_seq craig
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "purchases_id_seq" already exists
    Command was: CREATE SEQUENCE purchases_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;



pg_restore: [archiver (db)] Error from TOC entry 2257; 0 0 SEQUENCE OWNED BY purchases_id_seq craig
pg_restore: [archiver (db)] could not execute query: ERROR:  must be owner of relation purchases_id_seq
    Command was: ALTER SEQUENCE purchases_id_seq OWNED BY purchases.id;



pg_restore: [archiver (db)] Error from TOC entry 2258; 0 0 SEQUENCE SET purchases_id_seq craig
pg_restore: [archiver (db)] could not execute query: ERROR:  permission denied for sequence purchases_id_seq
    Command was: SELECT pg_catalog.setval('purchases_id_seq', 1000, true);



pg_restore: [archiver (db)] Error from TOC entry 164; 1259 444680 TABLE users craig
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "users" already exists
    Command was: CREATE TABLE users (
    id integer NOT NULL,
    email character varying(255),
    password character varying(255),
    det...
pg_restore: [archiver (db)] Error from TOC entry 163; 1259 444678 SEQUENCE users_id_seq craig
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "users_id_seq" already exists
    Command was: CREATE SEQUENCE users_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;



pg_restore: [archiver (db)] Error from TOC entry 2259; 0 0 SEQUENCE OWNED BY users_id_seq craig
pg_restore: [archiver (db)] could not execute query: ERROR:  must be owner of relation users_id_seq
    Command was: ALTER SEQUENCE users_id_seq OWNED BY users.id;



pg_restore: [archiver (db)] Error from TOC entry 2260; 0 0 SEQUENCE SET users_id_seq craig
pg_restore: [archiver (db)] could not execute query: ERROR:  permission denied for sequence users_id_seq
    Command was: SELECT pg_catalog.setval('users_id_seq', 50, true);



pg_restore: [archiver (db)] Error from TOC entry 2232; 2604 444695 DEFAULT id craig
pg_restore: [archiver (db)] could not execute query: ERROR:  must be owner of relation products
    Command was: ALTER TABLE ONLY products ALTER COLUMN id SET DEFAULT nextval('products_id_seq'::regclass);



pg_restore: [archiver (db)] Error from TOC entry 2233; 2604 444706 DEFAULT id craig
pg_restore: [archiver (db)] could not execute query: ERROR:  must be owner of relation purchase_items
    Command was: ALTER TABLE ONLY purchase_items ALTER COLUMN id SET DEFAULT nextval('purchase_items_id_seq'::regclass);



pg_restore: [archiver (db)] Error from TOC entry 2230; 2604 444672 DEFAULT id craig
pg_restore: [archiver (db)] could not execute query: ERROR:  must be owner of relation purchases
    Command was: ALTER TABLE ONLY purchases ALTER COLUMN id SET DEFAULT nextval('purchases_id_seq'::regclass);



pg_restore: [archiver (db)] Error from TOC entry 2231; 2604 444683 DEFAULT id craig
pg_restore: [archiver (db)] could not execute query: ERROR:  must be owner of relation users
    Command was: ALTER TABLE ONLY users ALTER COLUMN id SET DEFAULT nextval('users_id_seq'::regclass);



pg_restore: [archiver (db)] Error from TOC entry 2245; 0 444692 TABLE DATA products craig
pg_restore: [archiver (db)] could not execute query: ERROR:  permission denied for relation products
    Command was: COPY products (id, title, price, created_at, deleted_at, tags) FROM stdin;

pg_restore: [archiver (db)] Error from TOC entry 2246; 0 444703 TABLE DATA purchase_items craig
pg_restore: [archiver (db)] could not execute query: ERROR:  permission denied for relation purchase_items
    Command was: COPY purchase_items (id, purchase_id, product_id, price, quantity, state) FROM stdin;

pg_restore: [archiver (db)] Error from TOC entry 2243; 0 444669 TABLE DATA purchases craig
pg_restore: [archiver (db)] could not execute query: ERROR:  permission denied for relation purchases
    Command was: COPY purchases (id, created_at, name, address, state, zipcode, user_id) FROM stdin;

pg_restore: [archiver (db)] Error from TOC entry 2244; 0 444680 TABLE DATA users craig
pg_restore: [archiver (db)] could not execute query: ERROR:  permission denied for relation users
    Command was: COPY users (id, email, password, details, created_at, deleted_at) FROM stdin;

pg_restore: [archiver (db)] Error from TOC entry 2239; 2606 444700 CONSTRAINT products_pkey craig
pg_restore: [archiver (db)] could not execute query: ERROR:  must be owner of relation products
    Command was: ALTER TABLE ONLY products
    ADD CONSTRAINT products_pkey PRIMARY KEY (id);



pg_restore: [archiver (db)] Error from TOC entry 2235; 2606 444677 CONSTRAINT purchases_pkey craig
pg_restore: [archiver (db)] could not execute query: ERROR:  must be owner of relation purchases
    Command was: ALTER TABLE ONLY purchases
    ADD CONSTRAINT purchases_pkey PRIMARY KEY (id);



pg_restore: [archiver (db)] Error from TOC entry 2237; 2606 444688 CONSTRAINT users_pkey craig
pg_restore: [archiver (db)] could not execute query: ERROR:  must be owner of relation users
    Command was: ALTER TABLE ONLY users
    ADD CONSTRAINT users_pkey PRIMARY KEY (id);



pg_restore: [archiver (db)] Error from TOC entry 2242; 2606 444715 FK CONSTRAINT purchase_items_product_id_fkey craig
pg_restore: [archiver (db)] could not execute query: ERROR:  must be owner of relation purchase_items
    Command was: ALTER TABLE ONLY purchase_items
    ADD CONSTRAINT purchase_items_product_id_fkey FOREIGN KEY (product_id) REFERENCES produc...
pg_restore: [archiver (db)] Error from TOC entry 2241; 2606 444710 FK CONSTRAINT purchase_items_purchase_id_fkey craig
pg_restore: [archiver (db)] could not execute query: ERROR:  must be owner of relation purchase_items
    Command was: ALTER TABLE ONLY purchase_items
    ADD CONSTRAINT purchase_items_purchase_id_fkey FOREIGN KEY (purchase_id) REFERENCES purc...
pg_restore: [archiver (db)] Error from TOC entry 2240; 2606 444720 FK CONSTRAINT purchases_user_id_fkey craig
pg_restore: [archiver (db)] could not execute query: ERROR:  must be owner of relation purchases
    Command was: ALTER TABLE ONLY purchases
    ADD CONSTRAINT purchases_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(id);



WARNING: errors ignored on restore: 32

Is the dump file not latest or I did with a wrong way? beg for ur answer.