How to properly restore a Postgress database dump?

Question

PostgreSQL

All the best! I'm trying to restore the database from the sql.gz dump with the command gunzip -c sql.gz | psql old
At first it cursed me for the role

ERROR: role "old" does not exist

I created it, but now the following error that can not be defeated :(

ERROR: multiple primary keys for table "actions" are not allowed
ERROR: multiple primary keys for table "users" are not allowed
WARNING: no privileges could be revoked for "public"
REVOKE
WARNING: no privileges could be revoked for "public"

Сильно не ругайте,я новичок в sql

Answer 1

The problem is rather related to the fact that before restoring the dump, you need to delete all table rows from the database you want to restore.