mac os x 中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';