Postgres Backup & Restore

From UVOO Tech Wiki

Revision as of 22:17, 9 April 2022 by Busk (talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Jump to navigation Jump to search

.env

export PGPASSWORD=mypass
export PGUSER=admin
export PGDATABASE=mydb
export PGHOST=myhostorip

nohup pg_dump -Fc $DB > $DB-$(date +%d-%m-%y_%H-%M).pgdumpFc

pg_restore

https://stackoverflow.com/questions/2732474/restore-a-postgres-backup-file-using-the-command-line

Retrieved from "https://tech.uvoo.io/index.php?title=Postgres_Backup_%26_Restore&oldid=2913"