–Dump db
pg_dump databasefoo -Fc > dumpfile.dmp
–Dump db compressing dumpfile
pg_dump databasefoo | gzip > dumpfile.dmp.gz
–Dump db using 2 jobs in parallel
pg_dump databasefoo -h host -U user -Fd -f dumpdir -j 2
–Restore db
psql databasefoo < dumpfile.dmp
–Restore db
pg_restore -d databasefoo -Fc dumpfile.dmp
–Restore db compressed dumpfile
gunzip -c dumpfile.dmp.gz | psql databasefoo
–Restore db using 2 jobs in parallel
pg_restore -d databasefoo -h host -U user -Fd -j 2 dumpdir
Commenti