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

Thu, 19 Sep 2024 22:17:24 +0200

author
Olaf Wintermann <olaf.wintermann@gmail.com>
date
Thu, 19 Sep 2024 22:17:24 +0200
changeset 559
3966dc878a28
parent 288
7dd45173f68a
permissions
-rwxr-xr-x

log event free

#!/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