tmc_db01 backup 순서

tmc_db01 backup 순서

[root@tmc_db01 db]# env PGOPTIONS="-c statement_timeout=0" /usr/local/postgresql9/bin/pg_dump -h localhost -p 5432 -U postgres -Fc cafedb > /var/tinierme/db/cafedb.`date +%Y%m%d`.dat

[root@tmc_db01 db]#time ionice -c2 -n7 nice -n19 rsync --bwlimit=61440 --progress /var/tinierme/db/cafedb.20160101.dat interdev@ip:/var/atgames/db

interdev@ip's password:
cafedb.20160101.dat
   187508615 100%   53.66MB/s    0:00:03 (xfer#1, to-check=0/1)

sent 187531603 bytes  received 42 bytes  19740173.16 bytes/sec
total size is 187508615  speedup is 1.00

real    0m8.829s
user    0m2.820s
sys     0m0.964s