백업

@gp_db21에 로그인해서, 백업을 실시

# su - root

pass:*********

★이하의 쉘을 실시한다.

# /var/atgames/db/dbBackup_step2.sh localhost atgames04;

# /var/atgames/db/dbBackup_step2.sh localhost atgames05;

# /var/atgames/db/dbBackup_step2.sh localhost atgames06;

# /var/atgames/db/dbBackup_step2.sh localhost atgames08;

# /var/atgames/db/dbBackup_step2.sh localhost atgames10;

# /var/atgames/db/dbBackup_step2.sh localhost atgames12;

★gp_stor01에 로그인해서, 백업의 확인。

gp_stor01은 직접적으로는、로그인안되므로,db_40등에 들어가서 ssh gp_stor01의 IP어드레스에 들어가며 ㄴ확인할수 있습니다.

/var/atgames/db/

@gp_db39에 로그인해서 백업 실시

# su - root

pass:*********

★manager01의 백업

★gp_db39(master)에 로그인해서 백업실시(manager01) 

#/var/atgames/db/

# env PGOPTIONS="-c statement_timeout=0" /usr/local/postgresql9/bin/pg_dump -h localhost -p 5432 -U postgres -Fc atgames09 > /var/atgames/db/manager01.`date +%Y%m%d`.dat

백업의 확인

#/var/atgames/db/

@qzdb1에 로그인해서 백업 실시

# su - root

pass:*********

★Quizｄｂ、Quizdb2의 백업

★qzdb1(master)에 로그인해서 백업실시(qzdb1)

#/var/atgames/db/

# env PGOPTIONS="-c statement_timeout=0" /usr/local/postgresql9/bin/pg_dump -h localhost -p 5432 -U postgres -Fc dbquiz > /var/atgames/db/dbquiz.`date +%Y%m%d`.dat

# env PGOPTIONS="-c statement_timeout=0" /usr/local/postgresql9/bin/pg_dump -h localhost -p 5432 -U postgres -Fc dbquiz2 > /var/atgames/db/dbquiz2.`date +%Y%m%d`.dat
백업 확인

#/var/atgames/db/

@gp_db4에 로그인해서 백업 실시

# su - root

pass:*********

#cd /var/atgames/db

#/var/atgames/db/dbBackup_step2.sh localhost atgames07;

★gp_stor01에 로그인해서, 백업 확인

@gp_db4에 로그인해서 백업을 실시한다.

# su - root

pass:*********

# /var/atgames/db/dbBackup_step2.sh localhost atgames01;

# /var/atgames/db/dbBackup_step2.sh localhost atgames02;

# /var/atgames/db/dbBackup_step2.sh localhost atgames03;

# /var/atgames/db/dbBackup_step2.sh localhost atgames09;

# /var/atgames/db/dbBackup_step2.sh localhost selfydb;

★위의 쉘을 실행하면 백업이 된다.

★gp_stor01에 들어가서 백업의 확인

teraterm

【atgames01의 백업 @gp_db4】

/var/atgames/db/BK_atgames01.sh

【atgames02とatgames03의 백업 @gp_db4】

/var/atgames/db/BK_atgames0203.sh

【atgames07의 백업 @gp_db4】

/var/atgames/db/BK_atgames07.sh

【atgames09とselfydb의 백업 @gp_db4】

/var/atgames/db/BK_atgames09_selfydb.sh

【atgames04とatgames05とatgames06とatgames08とatgames10とatgames12의 백업 @gp_db21】

/var/atgames/db/BK_atgames04_05_06_08_10_12.sh

★파일 전송

@gp_db36(db_31,toydb2로 백업파일을 보낸다.)

# time ionice -c2 -n7 nice -n19 rsync --bwlimit=61440 --progress /var/atgames/db/daily/gp_db36_DB_PITRbackup_20110225052501.tar.gz interdev@172.19.1.31:/mnt/xfs/dump/

# time ionice -c2 -n7 nice -n19 rsync --bwlimit=61440 --progress /var/atgames/db/daily/gp_db36_DB_PITRbackup_20110225052501.tar.gz interdev@172.19.6.52:/mnt/xfs/dump/

@gp_db32(db_37,db_14로 백업파일을 보낸다.)

# time ionice -c2 -n7 nice -n19 rsync --bwlimit=61440 --progress /var/atgames/db/daily/gp_db32_DB_PITRbackup_20110225052501.tar.gz interdev@172.19.1.37:/mnt/xfs/dump/

time ionice -c2 -n7 nice -n19 rsync --bwlimit=61440 --progress /var/atgames/db/daily/gp_db32_DB_PITRbackup_20110225052501.tar.gz interdev@172.19.6.14:/mnt/xfs/dump/

@gp_db39(db_34,db_3로 백업파일을 보낸다.)

# time ionice -c2 -n7 nice -n19 rsync --bwlimit=61440 --progress /var/atgames/db/daily/gp_db39_DB_PITRbackup_20110225052501.tar.gz interdev@172.19.1.34:/mnt/xfs/dump/

#time ionice -c2 -n7 nice -n19 rsync --bwlimit=61440 --progress /var/atgames/db/daily/gp_db39_DB_PITRbackup_20110225052501.tar.gz interdev@172.19.6.3:/mnt/xfs/dump/

@gp_db4(db_31,db_14,db_3에서  백업 파일을 가져온다)

# time ionice -c2 -n7 nice -n19 rsync --bwlimit=61440 --progress interdev@172.19.1.31:/mnt/xfs/dump/gp_db36_DB_PITRbackup_20110225052501.tar.gz   /mnt/xfs/dump/

# time ionice -c2 -n7 nice -n19 rsync --bwlimit=61440 --progress interdev@172.19.6.14:/mnt/xfs/dump/gp_db32_DB_PITRbackup_20110225052501.tar.gz   /mnt/xfs/dump/

# time ionice -c2 -n7 nice -n19 rsync --bwlimit=61440 --progress interdev@172.19.6.3:/mnt/xfs/dump/gp_db39_DB_PITRbackup_20110225052501.tar.gz    /mnt/xfs/dump/

★파일 전개

# su - root

# cd /mnt/xfs

@gp_db31, toydb2

tar xzf /mnt/xfs/dump/gp_db36_DB_PITRbackup_20110224052501.tar.gz

@gp_db37, db14

tar xzf /mnt/xfs/dump/gp_db32_DB_PITRbackup_20110224052501.tar.gz

@gp_db34, db3

tar xzf /mnt/xfs/dump/gp_db39_DB_PITRbackup_20110224052501.tar.gz

★이미 데이터 폴더가 들어가 있는 경우에는 삭제한 후에 전개할 것

@gp_db31,toydb2, @gp_db37, db14, @gp_db34, db3

 /mnt/xfs의 밑에 데이터 폴더가 들어가 있다.

★gp_db4에 로그인 한다.

# su - root

#cd /mnt/xfs/dump/atgames01

#time ionice -c2 -n7 nice -n19 tar xzf ../gp_db36_DB_PITRbackup_20110224052501.tar.gz

#cd /mnt/xfs/dump/atgames0203/

#time ionice -c2 -n7 nice -n19 tar xzf ../gp_db32_DB_PITRbackup_20110224052501.tar.gz

#cd /mnt/xfs/dump/atgames09selfydb/

#time ionice -c2 -n7 nice -n19 tar xzf ../gp_db39_DB_PITRbackup_20110224052501.tar.gz

★data 폴더의 위치

★이미 데이터 폴더가 들어가 있는 경우에는 삭제한 후에 전개할 것

# cd /mnt/xfs/dump/atgames01

# cd /mnt/xfs/dump/atgames0203

# cd /mnt/xfs/dump/atgames09selfydb