all queries via pgpool 10.200.1.60:9999

[pgpool-online-recovery] / t / 3-test.sh

diff --git a/t/3-test.sh b/t/3-test.sh
index fb45fb8..9f509a0 100755 (executable)
--- a/t/3-test.sh
+++ b/t/3-test.sh
@@ -3,15 +3,15 @@
 export PAGER=''
 
 # test database
-psql -h 10.200.1.60 -c 'create database test' --user postgres
+psql -h 10.200.1.60 -p 9999 -c 'create database test' --user postgres
 
-psql -h 10.200.1.60 --user postgres -l
+psql -h 10.200.1.60 -p 9999 --user postgres -l
 
-psql -h 10.200.1.60 -f t/1-create-test.sql test postgres 
+psql -h 10.200.1.60 -p 9999 -f t/1-create-test.sql test postgres 
 
-psql -c 'SELECT * from pg_stat_replication' -h 10.200.1.61 postgres postgres
+psql -c 'SELECT * from pg_stat_replication' -h 10.200.1.60 -p 9999 postgres postgres
 
-psql -h 10.200.1.60 -c 'select * from t' test postgres
-psql -h 10.200.1.61 -c 'select * from t' test postgres
-psql -h 10.200.1.62 -c 'select * from t' test postgres
+psql -h 10.200.1.60 -p 9999 -c 'select * from t' test postgres
+psql -h 10.200.1.61         -c 'select * from t' test postgres
+psql -h 10.200.1.62         -c 'select * from t' test postgres