PostgreSQL常用操作

1.数据库备份恢复：pg_restore -h localhost -p 5432 -U postgres -W -d jeecg_boot -v "D:\Majit\jeecg-boot\jeect_boot.backup"

2.//导出sql文件
pg_dump -U postgres fhadmin_a>D:\fhadmin_a.sql
//导出backup文件
pg_dump -h localhost -p 5432 -U postgres -F c -b -v -f "D:/fhadmin_b.backup" -d fhadmin_a