postgresql 备份与恢复

备份

C:PostgreSQL11in>pg_dump -h localhost -p 5432 -U postgres Mes > d:/1.bak

恢复

C:PostgreSQL11in>psql -h localhost -p 5433 -U postgres -d Mes < d:/1.bak