Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --------------------------------------------------------------------------------
- Database Backup:
- --------------------------------------------------------------------------------
- taskset -c 2,3,4,5,6,7 pg_dump -U postgres -Fc ameyodb -f ameyodb_22Oct2018 .dump
- taskset -c 2,3,4,5,6,7 pg_dump -i -vv -U postgres --clean ameyodb -F c -f ameyodb_22Oct2018_3.sql
- taskset -c 2,3,4,5,6,7 pg_dump -U -j 5 postgres ameyodb | gzip > ameyodb_22Oct2018_4.sql.gz
- --------------------------------------------------------------------------------
- Database Restore:
- --------------------------------------------------------------------------------
- taskset -c 2-15 pg_restore -U postgres -d ameyodb -j 13 -v ameyodb_22Oct2018_2.dump
- taskset -c 2-15 pg_restore -i -e -vv -j 13 -U postgres -d ameyodb ameyodb_22Oct2018.dump
- --------------------------------------------------------------------------------
Add Comment
Please, Sign In to add comment