EnterpriseDB (“EDB”) announced its portfolio release for PostgreSQL 16.1, including robust tools and enhancements to EDB Postgres Extended (PGE) and EDB Postgres Advanced Server (EPAS).
Postgres is the most admired and desired database and the choice for enterprises looking to leave legacy systems and adopt open source alternatives that can support mission critical applications in highly regulated environments. As one of the leading contributors to Postgres, EDB addresses these demands by meeting strict data protection requirements and ensuring sensitive data is adequately protected with flexible cryptographic support for PGE and 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.
As companies increasingly transition away from Oracle, EPAS plays an increasingly crucial role in facilitating this migration by minimizing the necessity for manual rewrites. This is achieved through the implementation of solutions for the most common incompatibilities directly within the EDB Migration Portal.
Additionally with this release, EDB introduces critical advancements with sophisticated role membership controls. This empowers administrators to meticulously manage user activities, extending even to admin-level actions. Additionally, 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:
- Stored Procedure Language (SPL) Check reduces cost and saves time by detecting errors in storage procedure code before production.
- 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.
