Maintained with ☕️ by
IcePanel logo

Amazon Aurora for PostgreSQL now supports delegating extension management to lower privileged users

Share

Services

Amazon Aurora PostgreSQL-Compatible Edition now supports the rds\_extension database role which provides a cluster administrator the ability to delegate create, alter, or drop extension operations to lower privileged users. The cluster administrator can use the new rds.allowed\_delegated\_extensions DB parameter to limit which extensions a member of the rds\_extension role can manage. To get started, take a look at our [Working with extensions and foreign data wrappers page](https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Appendix.PostgreSQL.CommonDBATasks.html). Delegation of extension management using the rds\_extension role is available on Aurora PostgreSQL 15.5, 14.10, 13.13, 12.17 and higher in all AWS Regions, including the AWS GovCloud (US) Regions. Amazon Aurora is designed for unparalleled high performance and availability at a global scale with full MySQL and PostgreSQL compatibility. It provides built-in security, continuous backups, serverless compute, up to 15 read replicas, automated multi-Region replication, and integrations with other AWS services. To get started with Amazon Aurora, take a look at our [getting started page](https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/CHAP%5FGettingStartedAurora.html).