Postgresql 备份 恢复

备份: pg_dump -i -h localhost -p 5432 -U postgres -F p -v -f "/home/root/backup080502.sql" mydatabase 恢复: 用 psq mydatabase 进入数据库, 执行 \i /home/root/backup080502.sql 恢复