@@ -106,7 +106,7 @@ pg_ctl start -w -t 3600 > /dev/null 2>&1
106
106
107
107
# create tablespace and database for pgbench
108
108
mkdir -p$TBLSPC_PATH /pgbench
109
- psql -p$TEST_PGPORT postgres<< EOF
109
+ psql --no-psqlrc - p$TEST_PGPORT postgres<< EOF
110
110
CREATE TABLESPACE pgbench LOCATION '$TBLSPC_PATH /pgbench';
111
111
CREATE DATABASE pgbench TABLESPACE = pgbench;
112
112
EOF
@@ -125,22 +125,22 @@ grep -c DELETED $BASE_PATH/results/log_show_d_1
125
125
pgbench -p$TEST_PGPORT -i -s$SCALE pgbench> $BASE_PATH /results/pgbench.log2>&1
126
126
127
127
echo " full database backup"
128
- psql -p$TEST_PGPORT postgres -c" checkpoint"
128
+ psql --no-psqlrc - p$TEST_PGPORT postgres -c" checkpoint"
129
129
# pg_rman -p $TEST_PGPORT backup --verbose -d postgres > $BASE_PATH/results/log_full_1 2>&1
130
130
pg_rman -w -p$TEST_PGPORT backup --verbose -d postgres> $BASE_PATH /results/log_full_12>&1
131
131
132
132
pgbench -p$TEST_PGPORT -T$DURATION -c 10 pgbench>> $BASE_PATH /results/pgbench.log2>&1
133
133
echo " incremental database backup"
134
- psql -p$TEST_PGPORT postgres -c" checkpoint"
134
+ psql --no-psqlrc - p$TEST_PGPORT postgres -c" checkpoint"
135
135
# pg_rman -p $TEST_PGPORT backup -b i --verbose -d postgres > $BASE_PATH/results/log_incr1 2>&1
136
136
pg_rman -w -p$TEST_PGPORT backup -b i --verbose -d postgres> $BASE_PATH /results/log_incr12>&1
137
137
138
138
# validate all backup
139
139
pg_rman validate` date +%Y` --verbose> $BASE_PATH /results/log_validate12>&1
140
140
pg_rman -p$TEST_PGPORT show` date +%Y` -a --verbose -d postgres> $BASE_PATH /results/log_show02>&1
141
141
pg_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"
144
144
# pg_rman -p $TEST_PGPORT backup -b i --verbose -d postgres > $BASE_PATH/results/log_incr2 2>&1
145
145
pg_rman -w -p$TEST_PGPORT backup -b i --verbose -d postgres> $BASE_PATH /results/log_incr22>&1
146
146
@@ -217,7 +217,7 @@ diff $BASE_PATH/results/dump_before.sql $BASE_PATH/results/dump_after.sql
217
217
# take a backup and delete backed up online files
218
218
# incrementa backup can't find last full backup because new timeline started.
219
219
echo " full database backup after recovery"
220
- psql -p$TEST_PGPORT postgres -c" checkpoint"
220
+ psql --no-psqlrc - p$TEST_PGPORT postgres -c" checkpoint"
221
221
# pg_rman -p $TEST_PGPORT backup -b f --verbose -d postgres > $BASE_PATH/results/log_full2 2>&1
222
222
pg_rman -w -p$TEST_PGPORT backup -b f --verbose -d postgres> $BASE_PATH /results/log_full22>&1
223
223
@@ -279,4 +279,3 @@ pg_rman -p $TEST_PGPORT show timeline `date +%Y` -a --verbose -d postgres > $BAS
279
279
280
280
# cleanup
281
281
pg_ctl stop -m immediate> /dev/null2>&1
282
-