how to backup or dump and restore postgresql database

In this tutorial, we show how to backup or dump and how to restore a postgresql database.


For making a backup you can use pg_dump command like below:


pg_dump -Fc -h localhost mydatabase -U myuser -n myschema > test.pgdump


in the above, change hostname (localhost), database name (mydatabase), user (myuser) and schema (myschema) based on yours.
The test.pgdump file is the output backup file.

-F means format and -c is custom-format archive


Also for restoring the database using the backup file we use the pg_restore command like:


pg_restore -U myuser -h localhost -p 5432 -c -d mydatabase test.pgdump


Same as the pg_dump command, please change the hostname, database name and the user according to yours.

Leave a Reply

Your email address will not be published. Required fields are marked *