EDB Postgres Platform

Build your next application on the Postgres-based database platform at the heart of enterprise digital transformation

EDB Postgres Platform

EDB Postgres Platform

An enterprise-class data management platform integrated data management solution 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.

Overview

Architecture

EDB Postgres Platform Architecture

Multi-Model Data Management

Multi-Model Data Management

The EDB Postgres Platform supports relational, document-oriented and key-value-pair data modeling. The relational model is supported through a very high degree of SQL 2011 conformance (see https://www.postgresql.org/docs/current/static/features.html); the document-oriented model is supported with JSON and JSONB (see https://www.postgresql.org/docs/9.5/static/datatype-json.html ); key-value pair capabilities are provided by the HSTORE extension (see https://www.postgresql.org/docs/9.5/static/hstore.html ).

All data models are supported through a unified, ACID compliant transactional model that includes data definition language (DDL) constructs and data manipulation language (DML) constructs. Relational, document-oriented and key-value pair DDL and DML can be used in the same queries or stored procedures.

 

This creates an ideal foundation for the development of modern solutions that support digital business.

Application Development and DevOps

Application Development and DevOps

The EDB Product Platform is designed to support applications developed in a wide range of paradigms: Java, .Net, ODBC, Python, nodejs, PhP, etc., each of them supported using their major frameworks, such as Hibernate, Spring or Adonis. EDB Postgres is delivered with language packs for PhP, TCL and Python to support the development of stored procedures above and beyond the standard plpgsql (Postgres’ stored procedure language), edbspl (EDB’s native implementation of Oracle’s pl/SQL stored procedure language) and C programming languages.

The DevOps motion, supported through EDB Ark, makes it easy to deploy solutions rapidly in the cloud or on premises.

Cloud Re-Platforming - Control, visibility, and choice with the speed and agility for competitive digital innovation

Cloud Re-Platforming - Control, visibility, and choice with the speed and agility for competitive digital innovation

1. Ark Cloud Manager - enterprise database provisioning at click speed

EnterpriseDB enables your enterprise to re-platform database workloads to public, private, and hybrid cloud.  Ark Cloud Manager infrastructure and console enable you to offer Database-as-a-Service under your control. Ark provides visibilty across your deployed databases with its monitoring facility and supports high availability through its failover management. You can provision and de-provision scalable, highly available, clusters with a few clicks from our console or with a few RESTful API calls  from your scripts or applications.

2. Support for manual deployment or scripted options such as Puppet or Chef.

The EDB Postgres Platform is also supported on Amazon, Azure, Google Compute, and OpenStack when you deploy using other solutions like Puppet, Chef, or just handle it manually.

3. Freedom of choice in cloud targets

You have a rich fabric of cloud targets – with multiple public clouds as well as multiple private cloud solutions. We build our solutions for the cloud to preserve and support your choices avoiding lock-in with a single provider. We believe that you should be able to deploy with the same ease on multiple public cloud targets as well as your on premise OpenStack based private clouds.

4. Compatibility with your existing systems, data types and stored procedure languages

Our EDB Postgres Platform with our Postgres Advanced Server provides compatibility with Oracle’s data types, the PL/SQL language, and a broad set of packages in common use. When organizations move workloads to the cloud, they often take the opportunity to further optimize spend by re-platforming to an open source based solution as well. With EnterpriseDB’s built in Oracle compatibility you can preserve business logic and minimize the impact on applications as you move them to either public or private cloud options.

Our compatibility with existing proprietary databases also extends to our Replication Manager’s support for ongoing change data capture – allowing replication from an existing enterprise system on Oracle to EnterpriseDB Postgres Advanced Server. Often new applications developed in support of a digital business process require reference data such as Bill-of-Materials or price lists. These can be automatically kept up to date allowing new workloads to be in synch with core internal systems and information.

Management Toolkit

Management Toolkit

The EDB Postgres Platform provides a complete set of management tools that allow DBAs and Enterprise Architects to create highly available and extremely reliable solutions with 99.99% availability (and even higher).

  • EDB Postgres Enterprise Manager provides dashboards, reports and alerts to help DBAs meet stringent service level requirements
  • EDB Failover Manager (link) monitors the members of a Postgres cluster, identifies and verifies database server failures quickly and reliably, and if needed promotes a standby node to become the new cluster master and issues alerts.
  • EDB Backup and Recovery Tool (BART) is a key component of an enterprise-level Postgres-based data management strategy.  BART implements retention policies and point-in-time recovery requirements for large-scale Postgres deployments.

Integration Toolkit

Integration Toolkit

Data management solutions need to integrate with the rest of the enterprise. EDB’s integration tools include change-data capture based replication and data adapters, based on SQL/MED (Management of External Data).

  • EDB Replication Server provides a robust data replication platform for multi-master and single master replication between Postgres and key proprietary databases.
  • EDB Data Adapters leverage SQL/MED for transparent data integration to support data federation in digital business solutions

Migration Toolkit

Migration Toolkit

EDB’s Migration Toolkit migrates tables, data, stored procedures (Oracle only) and custom developed packages (Oracle only) from SQL Server, Sybase and Oracle to EDB Advanced Server.

A series of specialized database connectors for JDBC, ODBC, .NET, OCL (supports the key functions of the Oracle Client Interface) and ECPGPlus (supports the key functions of Oracle’s ProC interface) simplify the migration of applications from Oracle databases to EDB Advanced Server.

Connection Management

Connection Management

EDB recommends the use of pgPool II (link) for architectures that require query routing and connection pooling. pgPool’s query routing capability  can be used to create read-scalable Postgres clusters. pgBouncer is a lightweight alternative connection pooler, but it does not offer query routing capabilities.

Alternatively, customers can also use the multi-connection string capabilities of JDBC, in combination with an application server, to manage connection pools and route connections to Postgres databases.

Deployment Platforms

Deployment Platforms

The EDB Postgres Platform is supported on the major Linux distributions (RHEL, SLES, CentOS, OEL, Ubuntu, Debian), on IBM Linux on Power, and on Windows server operating systems. It can be deployed on bare metal, in virtualized environments on private cloud environments, such as OpenStack, or public clouds, such as AWS, or GCP.

EDB Ark is a DBaaS for hybrid cloud deployments of EDB Postgres on Amazon, OpenStack, and other platforms. Ark deployments are highly available, have integrated disaster recovery, and self healing capabilities. Ark provides a unified UI (graphical and API) to control and manage these deployments across multiple platforms.

The EDB Postgres Platform can be deployed in the OpenShift V3 PaaS framework as a series of containers, orchestrated by Kubernetes scripts and configured through YAML scripts, which provide a clustered solution for high availability and read scaling.