PWD=`pwd` DATA=data BKUP=bkup ARCH=$PWD/arch rm -rf arch mkdir arch rm -rf $DATA initdb -D $DATA echo "restart_after_crash = off" >> $DATA/postgresql.conf echo "archive_mode=on" >> $DATA/postgresql.conf echo "archive_command='cp %p ${ARCH}/%f'" >> $DATA/postgresql.conf echo "restart_after_crash = off" >> $DATA/postgresql.conf rm /tmp/hoge pg_ctl -D $DATA start rm -rf $BKUP pg_basebackup -D $BKUP -h /tmp echo "archive_mode=off" >> $BKUP/postgresql.conf echo "restore_command='cp ${ARCH}/%f %p'" >> $BKUP/postgresql.conf touch bkup/recovery.signal psql -c 'create table t(a int); insert into t (select a from generate_series(0, 600000) a)' touch /tmp/hoge psql -c 'insert into t (select a from generate_series(0, 600000) a)' rm /tmp/hoge sleep 5 pg_ctl -D $DATA -w start psql -c 'checkpoint' pg_ctl -D $DATA -w stop echo "#########################" pg_ctl -D $BKUP -w start sleep 10 pg_ctl -D $BKUP -w stop