@@ -51,6 +51,8 @@ while [ $# -gt 0 ]; do
5151esac
5252done
5353
54+ export LANG=C
55+
5456# delete old database cluster
5557pg_ctl stop -m immediate> /dev/null2>&1
5658rm -rf$PGDATA
@@ -138,7 +140,7 @@ pg_rman -w -p $TEST_PGPORT backup -b i --verbose -d postgres > $BASE_PATH/result
138140# validate all backup
139141pg_rman validate` date +%Y` --verbose> $BASE_PATH /results/log_validate12>&1
140142pg_rman -p$TEST_PGPORT show` date +%Y` -a --verbose -d postgres> $BASE_PATH /results/log_show02>&1
141- pg_dumpall> $BASE_PATH /results/dump_before_rtx.sql
143+ pg_dumpall-p $TEST_PGPORT > $BASE_PATH /results/dump_before_rtx.sql
142144target_xid=` psql -p$TEST_PGPORT pgbench -tAq -c" INSERT INTO pgbench_history VALUES (1) RETURNING(xmin);" `
143145psql -p$TEST_PGPORT postgres -c" checkpoint"
144146# pg_rman -p $TEST_PGPORT backup -b i --verbose -d postgres > $BASE_PATH/results/log_incr2 2>&1
@@ -156,7 +158,7 @@ sleep `expr $DURATION / 2`
156158pg_ctl stop -m immediate> /dev/null2>&1
157159cp -rp$PGDATA $PGDATA .bak
158160pg_ctl start -w -t 3600> /dev/null2>&1
159- pg_dumpall> $BASE_PATH /results/dump_before.sql
161+ pg_dumpall-p $TEST_PGPORT > $BASE_PATH /results/dump_before.sql
160162
161163# revert to crushed cluster
162164pg_ctl stop> /dev/null2>&1
@@ -211,7 +213,7 @@ find $BACKUP_PATH/backup/srvlog -type f | wc -l
211213pg_ctl start -w -t 3600> /dev/null2>&1
212214
213215# compare recovery results
214- pg_dumpall> $BASE_PATH /results/dump_after.sql
216+ pg_dumpall-p $TEST_PGPORT > $BASE_PATH /results/dump_after.sql
215217diff$BASE_PATH /results/dump_before.sql$BASE_PATH /results/dump_after.sql
216218
217219# take a backup and delete backed up online files
@@ -254,7 +256,7 @@ grep -c "recovery_target_" $PGDATA/recovery.conf
254256# recovery database
255257pg_ctl start -w -t 3600> /dev/null2>&1
256258
257- pg_dumpall> $BASE_PATH /results/dump_after_rtx.sql
259+ pg_dumpall-p $TEST_PGPORT > $BASE_PATH /results/dump_after_rtx.sql
258260diff$BASE_PATH /results/dump_before_rtx.sql$BASE_PATH /results/dump_after_rtx.sql
259261
260262# show timeline