Postgres installation on mac

Postgresql

### Install
brew install postgresql
postgres --version
brew services start postgresql


### Upgrade
brew upgrade postgresql
brew postgresql-upgrade-database
brew services restart postgresql


### Create a physical postgresql database
initdb /usr/local/var/postgres

### Start/Stop postgresql
pg_ctl -D /usr/local/var/postgres start
pg_ctl -D /usr/local/var/postgres stop

### Create actual database
Create ==> createdb mydatabasename
Remove ==> dropdb mydatabasename

Connect ==> psql mydatabasename

CREATE DATABASE mydatabasename;
DROP DATABASE mydatabasename;