PostgreSQL
Installation
MacOS
brew install postgresql
brew services start postgresql
brew cask install pgadmin4
# HostName 127.0.0.1
# Port 5432
# DataBase postgre
# UserName ${MAC_USER_NAME}
User Guide
PostgreSQL 11.2 手册
PostgreSQL 11.5 Documentation
# MacOS
psql postgres
## Init
CREATE USER marxiotadmin WITH ENCRYPTED PASSWORD 'marxiot1688';
du
CREATE DATABASE marxiot OWNER marxiotadmin;
l
GRANT ALL PRIVILEGES ON DATABASE marxiot TO marxiotadmin;
l
# Clean
REVOKE ALL ON DATABASE marxiot from marxiotadmin;
l
DROP DATABASE IF EXISTS marxiot;
l
DROP USER marxiotadmin;
du