![]() ![]() By using the PostgreSQL AuditĮxtension (pgAudit) with your RDS for PostgreSQL DB instance, you canĬapture the detailed records that are typically needed by auditors or to meet regulatory If you want to see the list of owners for the oracle schema, use the \dnįinancial institutions, government agencies, and many industries need to keepĪudit logs to meet regulatory requirements. Require rds_superuser permissions, as follows:ĪLTER SCHEMA oracle OWNER TO rds_superuser ![]() To learn more, seeĭepending on your version of RDS for PostgreSQL, installing an extension might As another example, you can log query execution plans by Pg_cron module, as detailed in Scheduling maintenance with the PostgreSQL pg_cron extension. For example, you can add scheduling capability by adding the Other modules are available to add to the list. Typically, the default DB cluster parameter group loads only the pg_stat_statements, but several Of shared_preload_libraries in your RDS for PostgreSQL DB instance's custom DB parameter group. In some cases, rather than installing an extension, you might add a specific module to the list ![]() See Working with Trusted Language Extensions for PostgreSQL. Using this extension, developers can create their own PostgreSQL extensions in a safeĮnvironment that simplifies the setup and configuration requirements. The extension pg_tle, which you can add to your RDS for PostgreSQL DB instance. As of RDS for PostgreSQL 14.5, RDS for PostgreSQL supports Trusted Language Extensions for PostgreSQL. ![]()
0 Comments
Leave a Reply. |