Creating postgres user on Snow Leopard,

create_postgres_user.sh

# Creating postgres user on Snow Leopard, same as Lion does. 
# hint gotten: http://zanshin.net/2009/09/07/installing-postgresql-on-mac-10-6-snow-leopard/

/usr/sbin/dseditgroup -o create -i 216 -r "PostgreSQL Users" postgres
dscl . -create /Users/postgres
dscl . -create /Users/postgres UniqueID 216
dscl . -create /Users/postgres UserShell /bin/bash
dscl . -create /Users/postgres RealName "Postgres Administrator"
dscl . -create /Users/postgres NFSHomeDirectory /opt/local/share/postgresql84
dscl . -create /Users/postgres PrimaryGroupID 216
dscl . -create /Users/postgres Password Password

# Replace Password appropriately!