Install
$ brew install postgresql
Init
$ initdb /usr/local/var/postgress
$ pg_ctl -D /usr/local/var/postgress -l /usr/local/var/postgres/server.log start
Create User and DB
$ createdb
$ psql
melo=# CREATE USER admin WITH PASSWORD 'password';
CREATE ROLE
melo=# DROP DATABASE postgres;
DROP DATABASE
melo=# CREATE DATABASE mypsql OWNER admin;
CREATE DATABASE
melo=# GRANT ALL PRIVILEGES ON DATABASE mypsql to admin;
GRANT
melo=# ALTER ROLE admin CREATEDB;
ALTER ROLE
melo=# \q
Exit and Login
$ psql -U admin -d mypsql
