EDB Postgres Advanced Server

EDB’s enhanced Postgres database designed to meet the needs of the enterprise.

EDB Postgres Advanced Server (EPAS) builds on open source PostgreSQL, the world's most advanced open-source database management system, adding powerful enterprise-class functionality.

Icon

Enterprise-class Tools

To enhance performance and security

Icon

Deployable Anywhere

From cloud to bare metal

Icon

Increased Productivity

Features that support DBAs and developers

Icon

Oracle® Database Compatibility

No emulation or translation layers are needed

For Database Administrators

EDB Postgres Advanced Server enables database administrators to manage more databases more effectively with enterprise ready features and tools.

  •  

    Resource Manager manages CPU and I/O resources, enabling DBAs to prioritize business-critical processes over lower-priority loads.

  •  

    Cache Restart Manager provides consistent performance across database offline maintenance cycles.

  •  

    SQL Session/System Wait Diagnostics provide detailed statistics to help diagnose and fix performance bottlenecks.

  •  

    EDB Loader inserts bulk data with parallel file loads and flags problem data for postload corrections.

  •  

    Eliminate data silos with data adaptors for Hadoop, MongoDB and MySQL.

Graphic

For Developers

Graphic

EDB Postgres Advanced Server contains advanced features help develpers code faster and reduce complexity.

  •  

    Write database procedures using their favorite programing languages (Java, .NET, C, C++, Javascript, Python, and more).

  •  

    Easily debug server side code with EDB Postgres Enterprise Manager's debugger.

  •  

    Use ready-to-run function packages to reduce development time or build your own custom function packages for re-use with your team.

  •  

    Benefit from native support for JSON, JSONB (fast binary), Key-Value pairs and XML by combining structured and unstructured data in the same transactionally consistent database.

  •  

    Use a suite of advanced programming features such as hierarchical queries, user defined data types, nested tables, and user defined exceptions to reduce development time and code complexity.

  •  

    Provide a variety of query optimizer hints to influence the choice of access plans when you know more about the data and record structures than the optimizer's assumptions.

セキュリティ

EDB Postgres Advanced Server includes security features that make it ideal for any enterprise requiring strong protection of sensitive data. Even the U.S. Department of Defense offers the Secure Technology Implementation Guide (STIG) for government systems deploying EDB Advanced Server. Security features include:

  •  

    In-database password policy management

  •  

    Enhanced auditing for compliance

  •  

    Data Encryption (non-transparent / transparent) and PCI Compliance guides

  •  

    Built-in SQL firewall (SQL/Protect)

  •  

    Procedural language protection (EDB Wrap) to protect in-code intellectual property

  •  

    Support for LDAP, Kerberos and Active Directory

Graphic

Database Compatibility with Oracle®

EDB Postgres Advanced Server provides native compatibility with Oracle® databases.

This begins with streamlined migration through native understanding and execution of the original PL/SQL and tools like the EDB Migration Portal. No emulation or translation layers are needed, and workflow, business logic, and skillsets carry over easily. Oracle-compatible features and tools enable DBAs to leverage their experience with Oracle PL/SQL while realizing significant cost savings.