postgres.md

Resources

• Costs of a PostgreSQL connection

OSX

brew install postgresql

# Init postgres db and conf files
initdb /usr/local/var/postgres -E utf8

# Start server
pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start

# Setup postgres superuser for dev
psql -U joe postgres
create role postgres SUPERUSER login;
\q