作者:滚猪儿 | 来源:互联网 | 2023-09-23 06:22
$ brew install postgresql -v
$ initdb /usr/local/var/postgres -E utf8
$ mkdir -p ~/Library/LaunchAgents
$ cp /usr/local/Cellar/postgresql/9.6.1/homebrew.mxcl.postgresql.plist ~/Library/LaunchAgents/
$ launchctl load -w ~/Library/LaunchAgents/homebrew.mxcl.postgresql.plist
$ pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start
pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log status
$ pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log stop -s -m fast
createuser postgres -P
createuser animal_dev -P
createuser animal_prod -P
使用dataGrip连接数据库
CREATE SCHEMA animal_dev AUTHORIZATION animal_dev;
GRANT ALL ON SCHEMA animal_dev TO animal_dev;
CREATE TABLE fud_test (
id serial primary key,
description CHARACTER VARYING(1024)
);
ALTER table fud_test owner to animal_dev;
--------------------------------------------------------------
CREATE SCHEMA animal_prod AUTHORIZATION animal_prod;
GRANT ALL ON SCHEMA animal_prod TO animal_prod;
CREATE TABLE fud_test (
id serial primary key,
description CHARACTER VARYING(1024)
);
ALTER table fud_test owner to animal_prod;