Restore a PostgreSQL database from an archive file created by pg_dump
February 26, 2022
$ pg_restore --verbose --clean --no-acl --no-owner -h HOSTNAME -d DB_NAME FILE_PATH
--verbose
: Specifies verbose mode. If specified, pg_dump will output detailed object comments, start and end times to the dump file, and progress messages to stderr.--clean
: Organize (delete) the database objects before recreating them.--no-acl
: Access privileges (grant/revoke command) will not be restored.--no-owner
: Do not output commands to match object ownership to the original database.-h HOSTNAME
: Specify the host name.-d DB_NAME
: Specify the database name.