#
# first, populate a DB to test against
sudo rm -fr DIR/pgsql
+echo Starting DB server
perl
system 'DIR/bin.sys/initdb -D DIR/pgsql/data';
****
-sudo rm test-stdout
+#
+# I don not understand why, but the DB fails to start if this rm is present.
+#sudo rm test-stdout
+#
+# Start the DB server
background
DIR/bin.sys/postgres -D DIR/pgsql/data -p PORT_N -k DIR/pgsql
****
+#
sleep 1
+echo Waiting for DB server
perl
+system 'DIR/bin.sys/pg_ctl -w -D DIR/pgsql/data status';
system 'createdb -h localhost -p PORT_N test';
-system 'psql -h localhost -p PORT_N -d test \
+system 'DIR/bin.sys/psql -h localhost -p PORT_N -d test \
-c "CREATE TABLE them ( name text, id text ); \
INSERT INTO them VALUES ( \'Philip Hazel\', \'ph10\' ); \
INSERT INTO them VALUES ( \'Aristotle\', \'aaaa\' ); \
';
****
#
+echo Populated DB server
+#
# now, the tests
exim -d-all+lookup -be
${lookup pgsql {select name from them where id='ph10';}}
${lookup pgsql {delete from them where id='aaaa'}}
****
exim -d -bh 10.0.0.0
+helo test
mail from:<a@b>
rcpt to:<c@d>
rcpt to:<c@d>
****
#
perl
-system 'pg_ctl stop -D DIR/pgsql/data -m immediate';
+system 'DIR/bin.sys/pg_ctl stop -D DIR/pgsql/data -m immediate';
****
+sleep 2
killdaemon
sudo rm -fr DIR/pgsql