EDB Postgres Advanced Server
Build Your Next Application on the EDB Postgres Platform
The EDB Postgres Platform is an enterprise-class data management platform based on the open source database PostgreSQL, complemented by tool kits for management, integration, and migration; flexible deployment options, and services and support to enable enterprises to deploy Postgres responsibly at scale.
EDB Postgres Advanced Server is EDB’s enhanced Postgres database designed to meet the needs of the digital enterprise. EDB Advanced Server incorporates all of PostgreSQL’s features with additional enterprise-class functionality for enhanced performance and security requirements for enterprise workloads. EDB Advanced Server features improve DBA and developer productivity. Oracle users benefit from EDB Advanced Server’s native database compatibility with Oracle, including PL/SQL, built-in packages, and many DBA tools to accelerate and simplify migrations.
Special features for DBAs you won't find in PostgreSQL include the Resource Manager which prioritizes CPU and I/O resources protecting business critical process from low priority loads. The pg_prewarm cache restart manager provides consistent and seamless performance across database offline maintenance cycles while 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. When these DBA centric database features are combined with EDB's mission critical tools, Postgres Advanced Server DBAs are able to manage more databases more effectively across the enterprise.
One of the World's Leading Open Source Database
PostgreSQL is an open-source, full-featured relational database. It has been under open source license (the PostgreSQL License) since 1996. It has a similar technical heritage as Oracle, Microsoft SQL Server and IBM DB2, however, it strongly adheres to the ANSI SQL standard.
PostgreSQL supports several procedural languages. This allows a developer to write procedures and functions in PL/pgSQL, PL/Tcl, PL/Perl and PL/Python. A multitude of other language implementations are also available, such as PL/PHP, PL/V8, PL/Ruby, PL/Java, etc.
PostgreSQL’s design is highly extensible and provides for the addition of new programing languages, new data types, and new indexes. This allows for rapid innovation illustrated with the JSONB document model, the PostGIS geographic information system and EDB’s implementations of SPL, a native implementation of a new programming language that supports key capabilities of Oracle’s PL/SQL procedural language.
EDB Postgres Replication Server
Multi Master Replication with EPRS
EDB Replication Server (EPRS) provides a robust data replication platform that replicates between Postgres databases in a single-master or multi-master mode, or from non-Postgres databases to Postgres in a single master mode. EPRS provides geographic load balancing, simplifies real-time migration, and enables heterogeneous data integration.
EDB Postgres Replication Server is a replication technology that enables geographically distributed Postgres data management with fast read/write access in every geography. EDB Postgres Replication Server supports PostgreSQL and EDB Advanced Server. Based on logical decoding, introduced in PostgreSQL 9.4, EDB Replication Server uses the Write-Ahead Logs (WAL) to extract relevant changes for replication. This replaces the use of triggers, which created overhead on the publication databases, and reduces latency significantly.
Even though applications and architecture designs aim to avoid data update conflicts, not every conflict can be avoided. This is why EDB Replication Server also offers proper conflict resolution methods to ultimately prevent data inconsistencies. For replication management, EDB Replication Server provides a comprehensive graphical user interface (GUI).