PostgreSQL 9.3 setup after the initial Macports installation

I recently installed PostgreSQL 9.3 using MacPorts. I know some of you use HomeBrew but I still have enough things installed using MacPorts, that work and upgrade well, that I'm still in the MacPorts camp. MacPorts installed PostgreSQL OK, but getting the installation initialized and running took a few hours on a Saturday. Here is a shell script to summarize what finally worked for me.

	#!/bin/bash
	PGV=93
	PGBIN=/opt/local/lib/postgresql${PGV}/bin
	PGDEFDB=/opt/local/var/db/postgresql${PGV}/defaultdb
	PGLOG=/opt/local/var/log/postgresql${PGV}/postgres.log
	DBUSER=${USER}
	## I had ALREADY used MacPorts to install the latest PostgreSQL server.
	# sudo port -v selfupdate
	# sudo port -v install postgresql${PGV}-server
	echo initial database setup
	sudo mkdir -p ${PGDEFDB}
	sudo chown postgres:postgres ${PGDEFDB}
	### added cd ${PGBIN} after reading: http://blog.mirotin.net/131/error-initialize-default-postgres-db
	## if you want SQL-ANSI default encoding:
	# sudo su postgres -c "cd ${PGBIN} && ./initdb -D ${PGDEFDB}"
	## if you want UTF8 default encoding:
	sudo su postgres -c "cd ${PGBIN} && ./initdb -E UTF8 -D ${PGDEFDB}"
	echo start server
	## If you want to run the server, log output to console, ^C to stop the server:
	# sudo su postgres -c "${PGBIN}/postgres -D ${PGDEFDB}"
	## If you want to run the server and have the log output go to a file:
	sudo su postgres -c "cd ${PGBIN} && ./pg_ctl -D ${PGDEFDB} -l ${PGLOG} start"
	echo setup automatic server start
	sudo launchctl load -w /Library/LaunchDaemons/org.macports.postgresql${PGV}-server.plist
	echo remember to setup PATH in your .bashrc
	echo example: "export PATH=${PGBIN}:\$PATH"
	echo create dbuser to match OSX username
	${PGBIN}/createuser --superuser ${DBUSER} -U postgres
	echo to create a new db: ${PGBIN}/createdb dbname
	exit 0

view raw gistfile1.sh hosted with ❤ by GitHub

In creating the script above, I started with hints from:
https://coderwall.com/p/xezzaa

I also needed these hints on OS X postgres user creation:
http://www.working-software.com/node/30

sudo dscl . change /Users/postgres NFSHomeDirectory /opt/local/var/db/postgresql82 /opt/local/var/db/postgresql93

This did not work:

sudo dscl . change /Users/postgres RealName "\n PostgreSQL-82 Server" 'PostgreSQL-93 Server'
  <main> attribute status: eDSAttributeNotFound
  <dscl_cmd> DS Error: -14134 (eDSAttributeNotFound)

But this did work:

sudo dscl . -create /Users/postgres RealName "PostgreSQL Administrator"

See: http://gilmation.com/articles/compile-and-configure-postgresql-on-mac-os-x/