2010-12-17 09:00:02.361 JST [][][] LOG: received fast shutdown request 2010-12-17 09:00:02.361 JST [][][] LOG: shutting down 2010-12-17 09:00:04.461 JST [][][] LOG: database system is shut down 2010-12-17 09:00:04.506 JST [][][] LOG: logger shutting down 2010-12-17 11:20:40.521 JST [][][] LOG: database system was shut down at 2010-12-17 09:00:04 JST 2010-12-17 11:20:40.521 JST [][][] LOG: could ..
[root@Postgres002 src]# wget http://cds.sun.com/is-bin/INTERSHOP.enfinity/WFS/CDS-CDS_Developer-Site/en_US/-/USD/VerifyItem-Start/jdk-6u24-linux-x64-rpm.bin?BundledLineItemUUID=WWuJ_hCxeA0AAAEuR8sWt.hA&OrderID=aXCJ_hCx3_UAAAEuN8sWt.hA&ProductID=oSKJ_hCwOlYAAAEtBcoADqmS&FileName=/jdk-6u24-linux-x64-rpm.bin [1] 11854 [2] 11855 [3] 11856 --2011-03-24 15:28:05-- http://cds.sun.com/is-bin/INTERSHOP.e..
[root@gp_db31 sh]# cat dbPITRbackup.sh #!/bin/bash STARTDATE=`date +%Y%m%d%H%M%S` su - postgres -c "touch -t `date +%Y%m%d%H`00 /var/atgames/db/pg_standby/archive`hostname | cut -c 6-`/baseline" # echo "### PITR BACKUP START(`date +%Y/%m/%d_%H:%M:%S`) ###" /usr/local/postgresql/bin/psql -h localhost -p 5432 -U postgres -c "SELECT pg_start_backup('backup_label_`echo -n ${STARTDATE}`');" echo "cat..
postgresql 정지수순 atgames01gp_db31(master): /etc/rc.d/init.d/gp_postgres stopgp_db36(slave):/etc/rc.d/init.d/gp_postgres stop atgames02,03gp_db37(master):/etc/rc.d/init.d/gp_postgres stopgp_db32(slave):/etc/rc.d/init.d/gp_postgres stop atgames07gp_db33(master):/etc/rc.d/init.d/gp_postgres_atgames12gp_db38(slave):/etc/rc.d/init.d/gp_postgres_atgames12 atgames09,selfydb,manage01gp_db34(master):/etc/..
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/dbinterdev@ip's password: cafedb.20160101.dat 187508..