diff -r 864e2d701dd4 -r a171da778817 src/server/plugins/postgresql/test/createtestdb.sh
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/src/server/plugins/postgresql/test/createtestdb.sh	Sat Feb 19 16:34:29 2022 +0100
@@ -0,0 +1,49 @@
+#!/bin/sh
+
+BUILD_ROOT=../../../../..
+
+PGTEST=$BUILD_ROOT/build/server/plugins/postgresql/test
+TESTDB=$PGTEST/data
+
+echo "## prepare testdb directory"
+rm -Rf $TESTDB
+mkdir $TESTDB
+if [ $? -ne 0 ]; then
+	exit 1
+fi
+
+TESTDB_ABS=`realpath $TESTDB`
+echo "testdb path: " $TESTDB_ABS
+
+echo "## init testdb"
+initdb -D $TESTDB_ABS
+if [ $? -ne 0 ]; then
+	exit 1
+fi
+
+cp pg/postgresql.conf $TESTDB
+mkdir $TESTDB/run
+
+echo "## start database"
+pg_ctl -D $TESTDB_ABS start
+if [ $? -ne 0 ]; then
+	echo "## start failed"
+	exit 1
+fi
+
+echo "## create testdb"
+createdb -h $TESTDB_ABS/run testdb
+if [ $? -ne 0 ]; then
+	echo "## createdb failed"
+	echo "## stop database"
+	pg_ctl -D $TESTDB_ABS stop
+	exit 1
+fi
+echo "success"
+
+echo "## stop database"
+pg_ctl -D $TESTDB_ABS stop
+exit $?
+
+
+