--- /dev/null
+#!/usr/bin/sh
+#
+# run as (postgresql) superuser
+
+psql -e <<EOF
+-- createuser -DRS pharext
+CREATE
+ USER "pharext"
+ NOCREATEDB
+ NOREPLICATION
+ NOSUPERUSER
+;
+
+-- createdb pharext -O pharext -E utf8 -l en_US.utf8
+CREATE
+ DATABASE "pharext"
+ OWNER "pharext"
+ TEMPLATE "template0"
+ ENCODING 'utf8'
+ LC_CTYPE 'en_US.utf8'
+ LC_COLLATE 'en_US.utf8'
+;
+
+\c pharext
+
+CREATE
+ EXTENSION "uuid-ossp"
+;
+
+EOF