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\' ); \
INSERT INTO them VALUES ( CHR(39) || \'stquot\', \'quote1\' );" \
';
****
+#
echo Populated DB server
#
# now, the tests
${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>