@@ -51,6 +51,8 @@ while [ $# -gt 0 ]; do
51
51
esac
52
52
done
53
53
54
+ export LANG=C
55
+
54
56
# delete old database cluster
55
57
pg_ctl stop -m immediate> /dev/null2>&1
56
58
rm -rf$PGDATA
@@ -138,7 +140,7 @@ pg_rman -w -p $TEST_PGPORT backup -b i --verbose -d postgres > $BASE_PATH/result
138
140
# validate all backup
139
141
pg_rman validate` date +%Y` --verbose> $BASE_PATH /results/log_validate12>&1
140
142
pg_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
142
144
target_xid=` psql -p$TEST_PGPORT pgbench -tAq -c" INSERT INTO pgbench_history VALUES (1) RETURNING(xmin);" `
143
145
psql -p$TEST_PGPORT postgres -c" checkpoint"
144
146
# 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`
156
158
pg_ctl stop -m immediate> /dev/null2>&1
157
159
cp -rp$PGDATA $PGDATA .bak
158
160
pg_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
160
162
161
163
# revert to crushed cluster
162
164
pg_ctl stop> /dev/null2>&1
@@ -211,7 +213,7 @@ find $BACKUP_PATH/backup/srvlog -type f | wc -l
211
213
pg_ctl start -w -t 3600> /dev/null2>&1
212
214
213
215
# compare recovery results
214
- pg_dumpall> $BASE_PATH /results/dump_after.sql
216
+ pg_dumpall-p $TEST_PGPORT > $BASE_PATH /results/dump_after.sql
215
217
diff$BASE_PATH /results/dump_before.sql$BASE_PATH /results/dump_after.sql
216
218
217
219
# take a backup and delete backed up online files
@@ -254,7 +256,7 @@ grep -c "recovery_target_" $PGDATA/recovery.conf
254
256
# recovery database
255
257
pg_ctl start -w -t 3600> /dev/null2>&1
256
258
257
- pg_dumpall> $BASE_PATH /results/dump_after_rtx.sql
259
+ pg_dumpall-p $TEST_PGPORT > $BASE_PATH /results/dump_after_rtx.sql
258
260
diff$BASE_PATH /results/dump_before_rtx.sql$BASE_PATH /results/dump_after_rtx.sql
259
261
260
262
# show timeline