恢复:
备份:
pg_dump -U "nsc" --dbname "nsc" --table "internal_app_bsatam.final_result_infoV2" --format custom --verbose --file "final_result_infoV2.backup"
windows:
pg_restore.exe --host 10.67.1.176 --port 5432 --username "nsc" --dbname "nsc" --no-password --data-only --table final_result_infov2 --schema internal_app_bsatam --verbose "C:\Users\xiaogensheng\Desktop\final_result_infoV2.backup"
linux:
pg_restore -U nsc --dbname "nsc" --data-only --table final_result_infov2 --schema internal_app_bsatam --verbose "final_result_infoV2.backup"
备份:
windows:
pg_dump.exe --host 10.67.1.176 --port 5432 --username "nsc" --no-password --format custom --verbose --file "C:\Users\xiaogensheng\Desktop\x1.backup" --table "internal_app_bsatam.final_result_infov2" "nsc"
pg_dump -U "nsc" --dbname "nsc" --table "internal_app_bsatam.final_result_infoV2" --format custom --verbose --file "final_result_infoV2.backup"