IT Japan

tmc_db01 backup 수순 본문

IT/PostgreSQL

tmc_db01 backup 수순

swhwang 2016. 3. 21. 16:55
반응형
[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.20110606.dat interdev@172.29.1.109:/var/atgames/db

interdev@172.29.1.109's password:
cafedb.20110606.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


반응형
Comments