osx-postgres-mem.sh

#!/bin/sh

## set up postgres (in this case 9.0 from macports
export PGCTL=/opt/local/lib/postgresql90/bin/pg_ctl
export CREATEUSER=/opt/local/lib/postgresql90/bin/createuser
export PGDATA=/Volumes/pgtmp/postgres

case $1 in 
	start)
		## Make a RAM filesystem
		diskutil erasevolume HFS+ "pgtmp" `hdiutil attach -nomount ram://1048576`
		## start postgres
		${PGCTL} -D ${PGDATA} init
		${PGCTL} -D ${PGDATA} start
		sleep 2;
		psql -c "CREATE DATABASE ckantest;" postgres
		;;
	stop)
		## stop postgres
		${PGCTL} -D ${PGDATA} stop
		## poof!
		umount /Volumes/pgtmp
		;;
esac