postgres:ERROR: Permission denied to create role.
时间: 2024-02-28 15:55:20 浏览: 99
This error message indicates that the user attempting to create a new database role does not have the necessary permissions to do so.
To resolve this issue, you need to grant the CREATE ROLE privilege to the user or role that is trying to create a new database role. You can do this using the GRANT command, like this:
```
GRANT CREATE ROLE TO <username>;
```
Replace `<username>` with the name of the user or role that needs the CREATE ROLE privilege. Once you have granted this privilege, the user should be able to create new database roles without encountering the "permission denied" error.
阅读全文