반응형
Notice
Recent Posts
Recent Comments
Link
IT Japan
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.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
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
반응형
'IT > PostgreSQL' 카테고리의 다른 글
| PostgreSQL의 날짜 계산 (0) | 2016.03.21 |
|---|---|
| PostgreSQL의 파라미터 튜닝 (0) | 2016.03.21 |
| postgresql.conf 기본적인 튜닝 (0) | 2016.03.21 |
| PostgreSQL 8.3 이상에서 postgresql.conf를 서버 스펙에 따른 디폴트 값을 설정하여 성능 튜닝 (0) | 2016.03.21 |
| PostgreSQL의 튜닝（postgresql.conf 의설정） (0) | 2016.03.21 |
Comments