mac install postgres

https://medium.com/@Umesh_Kafle/postgresql-and-postgis-installation-in-mac-os-87fa98a6814d

 

createdb postgis_test

psql postgis_test

 

Start manually:

pg_ctl -D /usr/local/var/postgres start

Stop manually:

pg_ctl -D /usr/local/var/postgres stop

$ brew services list
$ brew services restart postgresql

$ createdb mydb
$ psql -s mydb
# create user guott password 'password';
# GRANT ALL PRIVILEGES ON DATABASE mydb TO guott;

 Create Super User: /usr/local/opt/postgres/bin/createuser -s postgres