Postgresql 创建账户,修改密码
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;
附