1) Backup data with pg_dump
|
1 2 |
pg_dump -i -h localhost -p 5432 -U postgres -F c -b -v -f "/usr/local/backup/10.70.0.61.backup" old_db |
To list all of the available options of pg_dump , please issue following command.
pg_dump -?
- -p, –port=PORT database server port number
- -i, –ignore-version proceed even when server version mismatches
- -h, –host=HOSTNAME database server host or socket directory
- -U, –username=NAME connect as specified database user
- -W, –password force password prompt (should happen automatically)
- -d, –dbname=NAME connect to database name
- -v, –verbose verbose mode
- -F, –format=c|t|p output file format (custom, tar, plain text)
- -c, –clean clean (drop) schema prior to create
- -b, –blobs include large objects in dump
- -v, –verbose verbose mode
- -f, –file=FILENAME output file name
2) Restore data with pg_restore
|
1 2 |
pg_restore -i -h localhost -p 5432 -U postgres -d old_db -v "/usr/local/backup/10.70.0.61.backup" |
To list all of the available options of pg_restore , please issue following command.
pg_restore -?
- -p, –port=PORT database server port number
- -i, –ignore-version proceed even when server version mismatches
- -h, –host=HOSTNAME database server host or socket directory
- -U, –username=NAME connect as specified database user
- -W, –password force password prompt (should happen automatically)
- -d, –dbname=NAME connect to database name
- -v, –verbose verbose mode
DUMP Single Table
|
1 |
pg_dump.exe --host localhost --port 5432 --username "postgres" --no-password --format plain --section pre-data --section data --section post-data --encoding UTF8 --inserts --column-inserts --verbose --file "C:\Users\NIC\Desktop\office.sql" --table "public.c_offices" "secure20160804" |