@@ -106,7 +106,7 @@ pg_ctl start -w -t 3600 > /dev/null 2>&1
106106
107107# create tablespace and database for pgbench
108108mkdir -p$TBLSPC_PATH /pgbench
109- psql -p$TEST_PGPORT postgres<< EOF
109+ psql --no-psqlrc - p$TEST_PGPORT postgres<< EOF
110110CREATE TABLESPACE pgbench LOCATION '$TBLSPC_PATH /pgbench';
111111CREATE DATABASE pgbench TABLESPACE = pgbench;
112112EOF
@@ -125,22 +125,22 @@ grep -c DELETED $BASE_PATH/results/log_show_d_1
125125pgbench -p$TEST_PGPORT -i -s$SCALE pgbench> $BASE_PATH /results/pgbench.log2>&1
126126
127127echo " full database backup"
128- psql -p$TEST_PGPORT postgres -c" checkpoint"
128+ psql --no-psqlrc - p$TEST_PGPORT postgres -c" checkpoint"
129129# pg_rman -p $TEST_PGPORT backup --verbose -d postgres > $BASE_PATH/results/log_full_1 2>&1
130130pg_rman -w -p$TEST_PGPORT backup --verbose -d postgres> $BASE_PATH /results/log_full_12>&1
131131
132132pgbench -p$TEST_PGPORT -T$DURATION -c 10 pgbench>> $BASE_PATH /results/pgbench.log2>&1
133133echo " incremental database backup"
134- psql -p$TEST_PGPORT postgres -c" checkpoint"
134+ psql --no-psqlrc - p$TEST_PGPORT postgres -c" checkpoint"
135135# pg_rman -p $TEST_PGPORT backup -b i --verbose -d postgres > $BASE_PATH/results/log_incr1 2>&1
136136pg_rman -w -p$TEST_PGPORT backup -b i --verbose -d postgres> $BASE_PATH /results/log_incr12>&1
137137
138138# validate all backup
139139pg_rman validate` date +%Y` --verbose> $BASE_PATH /results/log_validate12>&1
140140pg_rman -p$TEST_PGPORT show` date +%Y` -a --verbose -d postgres> $BASE_PATH /results/log_show02>&1
141141pg_dumpall> $BASE_PATH /results/dump_before_rtx.sql
142- target_xid=` psql -p$TEST_PGPORT pgbench -tAq -c" INSERT INTO pgbench_history VALUES (1) RETURNING(xmin);" `
143- psql -p$TEST_PGPORT postgres -c" checkpoint"
142+ target_xid=` psql --no-psqlrc - p$TEST_PGPORT pgbench -tAq -c" INSERT INTO pgbench_history VALUES (1) RETURNING(xmin);" `
143+ psql --no-psqlrc - p$TEST_PGPORT postgres -c" checkpoint"
144144# pg_rman -p $TEST_PGPORT backup -b i --verbose -d postgres > $BASE_PATH/results/log_incr2 2>&1
145145pg_rman -w -p$TEST_PGPORT backup -b i --verbose -d postgres> $BASE_PATH /results/log_incr22>&1
146146
@@ -217,7 +217,7 @@ diff $BASE_PATH/results/dump_before.sql $BASE_PATH/results/dump_after.sql
217217# take a backup and delete backed up online files
218218# incrementa backup can't find last full backup because new timeline started.
219219echo " full database backup after recovery"
220- psql -p$TEST_PGPORT postgres -c" checkpoint"
220+ psql --no-psqlrc - p$TEST_PGPORT postgres -c" checkpoint"
221221# pg_rman -p $TEST_PGPORT backup -b f --verbose -d postgres > $BASE_PATH/results/log_full2 2>&1
222222pg_rman -w -p$TEST_PGPORT backup -b f --verbose -d postgres> $BASE_PATH /results/log_full22>&1
223223
@@ -279,4 +279,3 @@ pg_rman -p $TEST_PGPORT show timeline `date +%Y` -a --verbose -d postgres > $BAS
279279
280280# cleanup
281281pg_ctl stop -m immediate> /dev/null2>&1
282-