mac install postgres

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

posted on 2019-07-11 11:08 攻城狮科学家 阅读( ...) 评论( ...) 编辑 收藏

转载于:https://www.cnblogs.com/dataclimber/p/11168760.html