1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
|
#!/bin/sh
set -e
# Runtime variables
export PGPOOLCONF=$(mktemp)
export PGPOOLPORT=9999
# If we didn't already run inside a pg virtual environment
# start ourself inside one.
if [ -z "$PGVIRTUAL" ]; then
# when running under adt-run, allow "postgres" to access the temporary
# directories
if [ -n "$AUTOPKGTEST_TMP" ]; then
chown -R postgres:postgres "$AUTOPKGTEST_TMP"
unset TMPDIR
fi
/etc/init.d/pgpool2 stop
_SYSTEMCTL_SKIP_REDIRECT=1 /etc/init.d/pgpool2 stop
PGVIRTUAL=1 exec pg_virtualenv -i '--auth-local=peer --auth-host=scram-sha-256' "$0" "$@"
fi
cleanup () {
set +e
echo "Clean up environment"
rm -vf $PGPOOLCONF
/usr/sbin/pgpool -m fast stop 2>&1
}
trap cleanup 0 2 3 15
cd src/test/regression/tests/005.jdbc/
cat >> $PGPOOLCONF <<EOF
listen_addresses = '127.0.0.1'
port = $PGPOOLPORT
backend_hostname0 = '$PGHOST'
backend_port0 = $PGPORT
pool_passwd = ''
allow_clear_text_frontend_auth = true
EOF
cat $PGPOOLCONF
echo
cat > pgpool.properties <<EOF
pgpooltest.host=$PGHOST
pgpooltest.port=$PGPOOLPORT
pgpooltest.user=$PGUSER
pgpooltest.password=$PGPASSWORD
pgpooltest.dbname=postgres
# pgjdbc 42.2.15 adds gssEncMode, disable it here since pgpool2 doesn't support it yet
pgpooltest.options=gssEncMode=disable
pgpooltest.tests=autocommit batch column lock select update insert
EOF
# no need to restore this file, we just unlink it in debian/rules
cat pgpool.properties
echo
/usr/sbin/pgpool -n -f $PGPOOLCONF 2>&1 &
sleep 5
echo
echo "Prepare environment"
# We need to append IF EXISTS to all DROP TABLE statements,
# otherwise the test will fail.
sed 's/DROP\ TABLE\ [^I]/DROP\ TABLE\ IF\ EXISTS\ /' prepare.sql | \
psql -v ON_ERROR_STOP=1 -p $PGPOOLPORT 2>&1
echo
echo "Run JDBC-test"
export LC_ALL=en_US.UTF-8 # Hoge.java has utf-8 comments
chmod +x run.sh
PGPORT=$PGPOOLPORT CLASSPATH=/usr/share/java/postgresql.jar:. ./run.sh
echo
|
