src/server/plugins/postgresql/test/createtestdb.sh

Sun, 25 Sep 2022 10:36:28 +0200

author
Olaf Wintermann <olaf.wintermann@gmail.com>
date
Sun, 25 Sep 2022 10:36:28 +0200
changeset 388
30d29ef5b79a
parent 288
7dd45173f68a
permissions
-rwxr-xr-x

change uid before most of the config is loaded

#!/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 "## create test data"
psql -h $TESTDB_ABS/run -d testdb -f postgresql_vfs.sql
if [ $? -ne 0 ]; then
	echo "## create test data (1) failed"
	echo "## stop database"
	pg_ctl -D $TESTDB_ABS stop
	exit 1
fi
psql -h $TESTDB_ABS/run -d testdb -f postgresql_vfs_testdata.sql
if [ $? -ne 0 ]; then
	echo "## create test data (2) 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 $?


mercurial