postgre 第一次登录

sudo -u postgres psql postgres
#创建用户
CREATE USER dbuser;
#创建数据库
CREATE DATABASE exampledb OWNER dbuser;

#增加权限
alter role yanzeng with createdb;
alter role "yanzeng-li" with createdb;