start pgsql from console code example
Example 1: start postgres server
pg_ctl -D /usr/local/var/postgres start
Example 2: start postgres server
pg_ctl -D /usr/local/var/postgres stop
pg_ctl -D /usr/local/var/postgres start
pg_ctl -D /usr/local/var/postgres stop