sudo su postgres psql password postgres
输入密码
q
本机调试的时候,最好在装完以后添加一个pgsql的管理员帐号,否则phppgadmin不让登陆
创建用户
sudo su - postgres psql create user "myUser" with password '12345'; create database "myDB" owner "myUser"; grant all privileges on database "myDB" to "myUser"; q
修改已有的db owner
ALTER DATABASE xxx OWNER TO yyy;
附