【www.bbyears.com--PostgreSQL】
start
pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start
stop
pg_ctl -D /usr/local/var/postgres stop -s -m fast
create db and user
postgresql 的 bin 目录, 默认并没有加入 path, 要么在. bash_profile 里面加入, 要么进入安装的目录
cd /usr/local/Cellar/postgresql/9.3.5/bin
creatdb yemai
进入sql
psql yemai
运行建用户的sql
CREATE USER yemai WITH PASSWORD "yemai";