A gist for installing PostgreSQL with appropriate configuration on MacOS X.

postgres-macosx-install

#!/usr/bin/env bash

# A gist for installing PostgreSQL with appropriate
# configuration on MacOS X.
#
# MIT License
# 
# Copyright © 2014 Romain Champourlier <romain@softr.li>

brew update
brew install postgres

# Configure for UTF-8
initdb --encoding=UTF8 --lc-collate=en_US.UTF-8 --lc-ctype=en_US.UTF-8 --pgdata=/usr/local/var/postgres

# Link startup items
ln -sfv /usr/local/opt/postgresql/*.plist ~/Library/LaunchAgents

# Configure launch agents
launchctl load ~/Library/LaunchAgents/homebrew.mxcl.postgresql.plist

# Start it now
launchctl start homebrew.mxcl.postgresql

# Add the extension for PGAdmin
psql postgres -c 'CREATE EXTENSION "adminpack";'