用户相关操作

• \du显示当前集群中所有数据库用户。

postgres=# \du

                                    List of roles
  Role name   |                         Attributes                         | Member of 
---------------+------------------------------------------------------------+-----------
 audit_admin  | No inheritance                                             |{}
 mls_admin    | No inheritance                                             | {}
 tbase        | Superuser, Create role, Create DB, Replication, Bypass RLS | {}
 tbase01_admin | Superuser, Create role, CreateDB                          | {}

• \du+显示当前集群中所有数据库用户（包含注释）。

postgres=# \du+
                                    List of roles
  Role name   |                         Attributes                         | Member of |Description 
---------------+------------------------------------------------------------+-----------+-------------
 audit_admin  | No inheritance                                             |{}        | 
 mls_admin    | No inheritance                                             |{}        | 
 tbase        | Superuser, Create role, Create DB, Replication, Bypass RLS | {}        | 
 tbase01_admin | Superuser, Create role, CreateDB                          | {}        |

• 创建一个新的用户。

postgres=# create role pgxc with login ;
CREATE ROLE

• 配置用户密码。

postgres=# \password pgxc
Enter new password: 
Enter it again: