PostgreSQL on Mac OSX

Installing postgreSQL was so hard for mac. Because there are zero complete tutorials?? Or they require I know postgreSQL commands beforehand. This tutorial is for total noob.

Steps:

1. $ brew update
2. $ brew doctor
3. $ brew install postgresql

Start or Stop postgresql

$ brew services start postgresql

$ brew services stop postgresql

THEN for MAC creating default db failed, so use command

$ createdb

after that you can login to psql using

$ psql

You can also setup database to specific folder using:

$ psql -d template1

To exit the psql command line use:

CTRL + D