连接:
sudo su - postgres
psql
创建用户:
create user developer with password 'libo510723';
create user developer with superuser password 'libo510723';
创建数据库:
create database three_stage_distribution owner developer;
赋予数据所有权限给用户:
grant all privileges on database three_stage_distribution to developer;
修改密码:
alter user developer with password 'libo510723';
引号外的全当作小写
创建角色:
create role create_database createdb;
赋予用户角色;
grant create_database to developer;
修改linux系统postgres用户的密码:
步骤一:删除用户postgres的密码
sudo passwd -d postgres
步骤二:设置用户postgres的密码
sudo -u postgres passwd
删除用户
drop user developer;