PostgreSQL--(三)備份與回復

1. 備份

$> pg_dump --format=c --file=test1.out pyarddb
gt; pg_dump --format=c --file=test1.out pyarddb
--format:select format of output file(p:plain-text, t:tar-archive, c:custom-archive)
--file:specify output file

2. 回復

$> pg_restore --dbname=pyarddb pyard.backup
gt; pg_restore --dbname=pyarddb pyard.backup
--dbname: select the database and restore into the database