postgresql 命令创建数据库、用户、角色

gnn

eg：创建jira数据库

1. psql -U noway -d postgres
   
2. 
   
3. 
   
4. 
   
5. create user jira with password 'jira';
   
6. 
   
7. create database jira owner jira;
   
8. 
   
9. grant all privileges on database jira to jira;

复制代码

eg: 创建wiki数据库

1. psql -U noway -d postgres
   
2. 
   
3. 
   
4. 
   
5. create user confluence with password 'confluence';
   
6. 
   
7. create database confluence owner confluence;
   
8. 
   
9. grant all privileges on database confluence to confluence;

复制代码

eg: 创建conf数据库

1. psql -U noway -d postgres
   
2. 
   
3. 
   
4. 
   
5. create user conf with password 'conf';
   
6. 
   
7. create database conf owner conf;
   
8. 
   
9. grant all privileges on database conf to conf;

复制代码