PostgreSQL 使用pg_dump备份和恢复数据库

[klren0312]

pg_dump -U postgres -h localhost -p 5432 -d mydb -t mytable -F c -f /backup/mytable.dump

pg_restore -U postgres -h localhost -p 5432 -d mydb -c -F c /backup/mydb.dump

参考资料

https://www.cnblogs.com/echohye/p/18454715#:~:text=%E4%BD%BF%E7%94%A8%20pg_restore%20%E5%8F%AF%E8%BD%BB%E6%9D%BE%E8%BF%98%E5%8E%9F%E5%A4%87%E4%BB%BD%E6%95%B0%E6%8D%AE%EF%BC%8C%E7%89%B9%E5%88%AB%E6%98%AF%E8%87%AA%E5%AE%9A%E4%B9%89%E6%A0%BC%E5%BC%8F%E5%92%8C%20TAR%20%E6%A0%BC%E5%BC%8F%E7%9A%84%E5%A4%87%E4%BB%BD%E6%96%87%E4%BB%B6%E3%80%82,%E5%A4%87%E4%BB%BD%E6%A0%BC%E5%BC%8F%E6%8E%A8%E8%8D%90%E4%BD%BF%E7%94%A8%E8%87%AA%E5%AE%9A%E4%B9%89%E6%A0%BC%E5%BC%8F%EF%BC%88-F%20c%EF%BC%89%EF%BC%8C%E6%94%AF%E6%8C%81%E9%83%A8%E5%88%86%E8%BF%98%E5%8E%9F%E4%BB%A5%E5%8F%8A%E9%AB%98%E6%95%88%E7%9A%84%E6%95%B0%E6%8D%AE%E6%81%A2%E5%A4%8D%E3%80%82%20%E6%9C%89%E6%97%B6%E5%80%99%E6%88%91%E4%BB%AC%E8%BF%9B%E8%A1%8C%E6%95%B0%E6%8D%AE%E5%BA%93%E8%BF%81%E7%A7%BB%E6%97%B6%EF%BC%8C%E4%BD%BF%E7%94%A8pgAdmin%E8%BF%9B%E8%A1%8C%E5%A4%87%E4%BB%BD%EF%BC%8C%E5%BD%93%E5%86%8D%E6%AC%A1%E8%BF%98%E5%8E%9F%E7%9A%84%E6%97%B6%E5%80%99%EF%BC%8C%E6%9C%89%E5%8F%AF%E8%83%BD%E4%BC%9A%E6%8A%A5%E9%94%99%E3%80%82%20%E5%85%B6%E4%B8%AD%E4%B8%80%E4%B8%AA%E5%8E%9F%E5%9B%A0%E5%B0%B1%E6%98%AF%E6%88%91%E4%BB%AC%E4%BD%BF%E7%94%A8%E7%9A%84%E5%A4%87%E4%BB%BD%E5%B7%A5%E5%85%B7%E9%92%88%E5%AF%B9%E7%9A%84%E6%98%AFpg16%E7%89%88%E6%9C%AC%EF%BC%8C%E4%B8%8D%E6%94%AF%E6%8C%81%E5%BD%93%E5%89%8D%E7%89%88%E6%9C%AC%E7%AD%89%E7%AD%89%E3%80%82%20%E6%89%80%E4%BB%A5%E6%88%91%E4%BB%AC%E5%B0%BD%E9%87%8F%E4%BD%BF%E7%94%A8%E5%90%8C%E7%89%88%E6%9C%AC%E7%9A%84%E5%B7%A5%E5%85%B7%E8%BF%9B%E8%A1%8C%E5%A4%87%E4%BB%BD%EF%BC%8C%E4%BB%A5%E6%96%B0%E6%95%B0%E6%8D%AE%E5%BA%93%E7%89%88%E6%9C%AC%E4%B8%BA%E4%B8%BB