I have a bash script that does exactly that, but b...

2009-02-09T03:20:00.000-05:00

I have a bash script that does exactly that, but because I need to test remote connections too (and it is easy just to scp from script and than ssh run) - they all connect using tcp/ip.

in essence it looks like that:

#!/bin/bash

TEMP_DIR="/var/tmp/"

if [ $(($#)) -ne 2 ]; then
echo "params: port and data directory name"
exit 1;
fi

if [ $(($1)) -lt 1024 ]; then
echo "port value needs to be between 1024 and 65536. not $(($1))"
exit 1;
fi

export PGPORT=$1
export PGDATA=$TEMP_DIR/database$1

echo "attempting to create database instance $2"

initdb -A trust > /dev/null

if [ $? != 0 ]; then
echo "problems with initdatabase"
exit 1;
fi

echo "starting instance with database \"$2:$PGPORT\""

#enable listening on ethernet interfaces

echo "listen_addresses='*'" >> $PGDATA/postgresql.conf

pg_ctl -w start >/dev/null
if [ $? != 0 ]; then
echo "problems starting up temporary database $2:$PGPORT"
rm -rf $PGDATA
exit 1;
fi

(altho it is a part of much bigger module, and tescase).

Comments on End Point Blog: Test::Database Postgres support

I have a bash script that does exactly that, but b...