Tag Archives: restore

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 […]