Supported Postgres distributions#
Selecting the right Postgres distribution when creating a new database cluster in Hybrid Manager (HM) is crucial for optimizing your database environment. EDB offers a range of options, each tailored to different needs, from open-source flexibility to enterprise-grade features and Oracle compatibility.
EDB Postgres Advanced Server#
EDB Postgres Advanced Server is EDB’s most comprehensive PostgreSQL distribution. It supports features such as advanced security , advanced SQL , high-availability and multi-master replication in combination with EDB Postgres Distributed and, optionally, Oracle compatibility . It’s ideal for demanding enterprise workloads and seamless migration from cost-intensive Oracle databases.
This option is suited for:
Enterprises migrating from Oracle databases seeking high compatibility to reduce migration costs and complexity.
Organizations with mission-critical applications requiring advanced security, performance, and management tools.
Businesses that need comprehensive enterprise-grade features, including enhanced auditing, SQL injection protection, and robust high availability.
EDB Postgres Extended Server#
EDB Postgres Extended Server provides specific enhancements designed for enterprise requirements, particularly in data security, for example, through transparent data encryption . It also supports advanced replication with EDB’s powerful high-availability and multi-master replication solution, EDB Postgres Distributed .
This option is suited for:
Enterprises requiring enhanced data-security features.
Organizations looking to leverage EDB’s high-availability and multi-master replication solutions.
Users who want a PostgreSQL experience with additional enterprise capabilities while maintaining strong compatibility with community PostgreSQL.
PostgreSQL#
Open-source PostgreSQL is a powerful, reliable, and feature-rich relational database system. It’s known for its strong adherence to SQL standards, robust architecture, data integrity, and a global community.
This option is suited for:
Organizations prioritizing cost effectiveness and open-source freedom.
Projects that don’t require advanced security features, multi-master replication solutions, or Oracle compatibility.
Teams with in-house PostgreSQL expertise and the resources to manage their database environment.
Distribution comparison#
For a comparison of the available distributions by functionality and feature, see:
Documentation by distribution#
To get the most out of any of the Postgres distributions, refer to its documentation: