DevelopersDevOpsNewsOpen Source

EDB Announces Portfolio Release For PostgreSQL 16.1


EnterpriseDB (EDB) has announced its portfolio release for PostgreSQL 16.1, including robust tools and enhancements to EDB Postgres Extended (PGE) and EDB Postgres Advanced Server (EPAS).

The introduction of the Privilege Analysis feature in EPAS significantly streamlines the process of tracing database object access and generating comprehensive reports on both unused and utilized privilege access. This feature enhances the ability to proactively mitigate excess access to database objects, ensuring responsible data management and providing regulators and security teams with detailed reports.

With this release, EDB also introduces critical advancements with sophisticated role membership controls. This empowers administrators to meticulously manage user activities, extending even to admin-level actions. The update provides enhanced visibility into table and index usage, setting the stage for optimal performance during high-intensity workloads.

Additional highlights of the release include:

● Transparent Data Encryption (TDE) enhancements leverage Advanced Encryption Standard (AES), a best practice for securing data and helping address regulatory requirements such as GDPR, HIPAA, PCI DSS, and FIPS 140-2. Now, customers can choose AES-128 when performance and power consumption need to be considered and AES-256 to meet regulatory requirements or when looking for maximum security.

● Stored Procedure Language (SPL) Check reduces cost and saves time by detecting errors in storage procedure code before production.

● Enhanced Oracle Compatibility features expand support to popular Oracle subprograms like DBMS_SESSION, DBMS_SQL, and UTL_File alongside expanded coverage for the most popular SQL functions still encountered by EDB’s Migration Portal, making it likely to reduce significantly code needing to be modified when migrating from Oracle.

● Enhanced Oracle Compatibility features broaden the support to encompass popular Oracle subprograms such as DBMS_SESSION, DBMS_SQL, and UTL_File. This expansion also includes increased coverage for prevalent SQL functions frequently encountered by EDB’s Migration Portal. As a result, there is a substantial likelihood of reducing the amount of code that requires modification during the migration process from Oracle.