Postgres Plus Advanced Server®

Try Postgres Plus Advanced Server for free

Request a price quote for Postgres Plus Advanced Server

Advance Server Tab

A Gartner Magic Quadrant Leader

The news is out! EnterpriseDB is recognized as a leader in Gartner's 2014 Magic Quadrant for Operational Database Management Systems report. Our recognition comes as Postgres gathers greater momentum and global brands embrace its growing technical prowess. Postgres Plus Advanced Server enables enterprises to divert investment from the high license and maintenance fees paid to traditional databases, to more strategic IT objectives instead. Read Gartner's latest Magic Quadrant report.

Proven performance in enterprises and government

A relentless focus on performance, security, and special tools over multiple releases continues to expand the range of solutions possible with Postgres Plus. Resource Manager prioritizes CPU and I/O, protecting important processes. This allows DBAs to limit resource consumption, preventing any single Postgres Plus process from monopolizing resources to the detriment of other processes. Recent partitioning improvements, linear read performance scaling up to 64 cores, optimized locking techniques, and multiple performance boosting features handle the largest OLTP loads for many commercial, U.S. government, and non-profit organizations of all sizes and missions. View a cross section of our customers. 

NoSQL for the enterprise

Advanced Server’s powerful combination of unstructured and relational database technologies in a single enterprise database management system provides the freedom, flexibility and performance of handling unstructured and semi-structured data while preserving its long-term viability as enterprise information.

The document and key-value store features in Advanced server provide the advantages of new NoSQL technologies plus the ability to integrate them into traditional corporate data infrastructures without data silos, operational complexity, loss of data integrity, and risk. Read more about NoSQL for the Enterprise.

Every data center has a sweet spot for Postgres Plus Advanced Server®

Organizations of all sizes and types are cutting database costs wherever possible by deploying a capable low cost alternative to costly proprietary databases. This strategy reduces lock-in to a single vendor and gives IT managers more leverage when negotiating for lower costs. Controlling costs with expensive proprietary vendors has been proven with Linux for operating systems, Xen and KVM for virtualization and JBoss and Apache for middleware and is now being applied to databases. Compare costs with our online TCO calculator. 

Database compatibility creates a larger sweet spot for savings!

EDB's compatibility technology helps cap, reduce, or eliminate Oracle® fees using multiple strategies, while preserving your investment in Oracle volume licensing, infrastructure, skills and practices. For over 9 years, EnterpriseDB has built a solid practice around helping customers just like you save money for their applications built around PL/SQL, OCI, and Pro*C.

Oracle migration tools convert your schema and many applications run with few changes. Customer conversions of their easy to migrate applications take days or a few weeks. EDB services like the Oracle Migration Assessment quickly identify high-payback applications and the Migration Factory can take 100% of the burden off your staff and realize savings sooner. Re-training is minimal because of the Oracle-like tools provided by Postgres Plus Advanced Server, so you staff can continue leveraging their Oracle knowledge and skills against a low cost open source based alternative. See the Ease of Migration tab to learn more.

Use EnterpriseDB's best practices to optimize your database mix for cost savings

There are many paths to finding and applying costs savings in your database portfolio including how you manage your existing volume license agreements. One method is moving existing and easy to migrate applications off their authorized volume licenses to Postgres Plus Advanced Server at a much lower cost. Then recycle the volume licenses to account for growth or hardware upgrades in your difficult to migrate or unqualified to migrate applications. A smart re-balancing of your database mix can result in you paying less in total fees with Postgres Plus Advanced Server than your current proprietary maintenance fees alone. Other strategies used by customers to deploy Postgres Plus Advanced Server include:

  • Building new OLTP and operational applications
  • Applying it to a class of applications based on specific criteria (SLAs, data size, concurrent users, etc.)
  • Addressing archival or read-only applications that don't justify expensive licenses
  • Building non-mission critical applications
  • Assigning it to particular business units or departments
  • Offloading reporting tasks from a master database as an inexpensive replication server

Read our white paper: Optimizing Open Source for Greater Database Savings and Control

We can help you create a path forward

Our free Enterprise Enablement consultation will inventory your database portfolio and help you identify likely candidates for implementing Postgres Plus Advanced Server at a cost savings in the context of your business goals and current constraints. An inexpensive followup Migration Assessment service can then identify technical issues (if any) for each candidate application, map out a technical strategy for implementation, and estimate your costs savings allowing you to make informed decisions. Contact us for a consultation now.

World Class Performance

Postgres Plus Advanced Server® has a proven track record supporting large transactional systems for thousands of users world-wide and around the clock. It is built upon and integrates every release of the world's most advanced open source database, PostgreSQL. EDB engineers then work continuously with our enterprise users to add features, tools and solutions to meet our customers demanding standards.

Recent partitioning improvements, linear read performance scaling up to 64 cores, modern locking techniques, and multiple performance boosting features handle the largest OLTP loads produced by commercial, government, and non-profit organizations of all sizes and missions.

Advanced Security

No other open source based RDBMS protects your data as well as Advanced Server which provides integrated row level security, a module to guard against SQL injection attacks, enhanced auditing to meet compliance obligations, and protection of important server side code from unauthorized viewing.

Database Compatibility

EDB's compatibility technology helps cap, reduce, or eliminate Oracle® fees while preserving your investment in Oracle infrastructure, skills and practices using multiple strategies including new deployments, replication for reporting, and migrating mission and non-mission critical applications.

Enterprise Developer Features

Developers are more productive using 19 proven function packages, complex data types that map cleanly to object oriented applications, nested tables, hierarchical queries, explicit transaction control in stored procedures and all in the language of their choice (e.g. Java, Python, C/C++ and more).

Learn more about developer features

Enterprise DBA Features

DBAs get more control over their data with a CPU and I/O Resource Manager, centrally managed SQL injection guard utility, extensive catalog views, a high speed bulk loader, low level session and system wait diagnostics, and Postgres Enterprise Manager to monitor, manage and tune multiple databases efficiently across the enterprise.

Learn more about Postgres Enterprise Manager

Tools for Scalability, HA, Performance, and more

A suite of professional grade tools all developed and supported by EnterpriseDB, provides your staff with solutions to address critical issues related to data protection, tuning SQL workloads, backup and disaster recovery, read and write scalability, high availability, monitoring, data migration, and software updates.

Learn more about the EDB tool suite

Supported Platforms

Postgres Plus Advanced Server is available on a variety of platforms including multiple Linux 64 bit operating systems and Windows 64 bit systems.

Review the supported products and platforms

A savings sweet spot

For over 9 years, EnterpriseDB has built a solid practice around reducing, capping or eliminating high Oracle costs with Postgres Plus Advanced Server's database compatibility, and simultaneously preserving your investment in Oracle volume licensing, infrastructure, skills and practices. We have helped customers just like you save money for their applications built around PL/SQL, OCI, and Pro*C. In spite of attractive licensing deals during a company’s database growth phase, many organizations regret the loss of control to manage costs that inevitably occurs a few years later. EnterpriseDB’s Postgres Plus Advanced Server with database compatibility for Oracle gives you cost savings options.

Read our white paper: Optimizing Open Source for Greater Database Savings and Control

If you can't replace Oracle, you can control costs

For many customer applications Oracle simply cannot be replaced for various reasons including volume licensing, migration risk, and COTS applications certified to work with Oracle. However, you can still gain control over ever increasing expenses with various cost containment strategies.

One method is moving existing and easy to migrate applications off their authorized volume licenses to Postgres Plus Advanced Server at a much lower cost. Then recycle the volume licenses to account for growth or hardware upgrades in your difficult to migrate or unqualified to migrate applications. A smart re-balancing of your database mix can result in you paying less in total fees with Postgres Plus Advanced Server than your current proprietary maintenance fees alone.

When it comes to choosing which applications to migrate, you have many options. A sample of strategies used by our customers includes:

  • build new OLTP and operational applications
  • use Advanced Server based on criteria specific to your needs (SLAs, database size, concurrent users, etc.)
  • service archival or read-only applications that don't justify expensive licenses
  • build non-mission critical applications
  • assign Advanced Server to particular business units or departments
  • use it to offload reporting tasks from a master database as an inexpensive replication server

Database compatibility explained

Advanced Server's database compatibility focus's on five critical areas of technology. A schema migration toolkit converts Oracle objects (data types, tables, partitions, database links, users, roles, triggers, stored procedures) to Advanced Server.

The second focus is on procedure processing; in additional to processing native PostgreSQL's PL/pgSQL, it also has a native parser for Oracle's PL/SQL. This includes Oracle syntax, function packages (e.g. DBMS_UTL, DBMS_RLS, and DBMS_PROFILER), user defined exceptions, named parameter notation, private synonyms, partitioning syntax, GOTO, Bulk Collect/Fetch/Bind, VARRAY, table() expressions, and more.

The next focus is on Oracle SQL extensions that are popular with users such as: decode(), the DUAL table, ROWNUM, Object Types and sub-types.

Application compatibility is the next focus with support for OCI and Pro*C as well as multiple library interfaces.

Finally, Advanced Server comes with tools critical to Oracle users with similar look and feel to minimize re-training. Examples of these tools include: EDB*Plus, EDB*Loader, EDB*Wrap and a stats pack like toolset for DBAs.

View a video explaining how Advanced Server provides database compatibility for Oracle.

We make managing change easy

EDB understands that a technology change in your databases is far from trivial. That’s why we provide a comprehensive set of strategies, features, tools, and services to make a change as smooth as possible. EDB’s database compatibility addresses the software for schema, data, and code compatibility, as well as the people who use it by providing the same objects, syntax, extensions and tools they use today for an environment that feels very familiar. You can even replicate data bi-directionally from Postgres Plus Advanced Server making it extremely easy to integrate our low cost platform into your existing environment.

Customer conversions of their easy to migrate applications take only days or a few weeks. EDB services like the Migration Assessment for Oracle quickly identify high-payback applications to help you realize savings sooner.

Learn more about a Migration Assessment

Additional database compatibility resources

 

PostgreSQL vs Postgres Plus Advanced Server

Feature Differences (Hold pointer over features for details)

Go to: Common Features 

Feature Differences PostgreSQL Postgres Plus
Advanced Server

General Differences

Features marked: , are also compatible with Oracle®.

Features marked: Yes, are Security related.

  Includes all PostgreSQL features and updates, plus additional:
    - Security features
    - Performance features
    - Developer features
    - DBA features
    - Compatibility with Oracle
    - Enterprise Tools
Enterprise Security Features
Row Level Security (VPD) ⊕ Yes   Yes
Enhanced Audit/Compliance Yes   Yes
Server Procedural Language Protection (EDB*Wrap) ⊕ Yes   Yes
Enterprise Performance Features
Scalable Partitioning   Yes
Partition By... Range
List
Range
List
Hash
Query Optimizer Hints ⊕   Yes
Enterprise Developer Features
SQL Aggregates with CUBE, ROLLUP and GROUPING SETS   Yes
Hierarchical Queries ⊕   Yes
19 pre-defined re-usable Function Packages Yes
Synonyms (public and private) ⊕   Yes
Extended Functions and Operators ⊕   Yes
Explicit Commit/Rollback in Stored Proc. ⊕   Yes
Bulk Collect and Binds ⊕   Yes
User defined object types ⊕   Yes
Nested Tables ⊕   Yes
User Defined Exceptions ⊕   Yes
User defined packages and functions ⊕   Yes
Associative Arrays ⊕   Yes
VARRAYs ⊕   Yes
edb_stmt_level_txn ⊕   Yes
EDB*Wrap ⊕ Yes   Yes
EDB*Plus ⊕   Yes
ECPGPlus   Yes
Enterprise DBA Features
Resource Management   Yes
Declarative Partitioning Syntax ⊕   Yes
EDB*Loader ⊕   Yes
SQL Session/System wait tuning diagnostics ⊕   Yes
Extended Catalog Views ⊕   Yes
Database Compatibility for Oracle (also includes all features in table with the ⊕ symbol)
PL/SQL Support in Stored Procedures and Triggers ⊕   Yes
PL/SQL Debugger ⊕   Yes
EDB*OCI ⊕   Yes
Enterprise Tools for Performance, Scalability, High Availability, and Management included in a subscription for: Standard Edition Enterprise Edition
EDB Backup and Recovery Tool Yes Yes
EDB Update Monitor Yes Yes
EDB Postgres Enterprise Manager Yes Yes
EDB SQL/Protect Yes Yes Yes
EDB xDB Replication Server (single-master) Yes Yes
EDB Migration Toolkit ⊕ Yes Yes
EDB Failover Manager Extra Option Yes
EDB Replication Server (multi-master) Extra Option Yes

  

Common Features

Go to: Different Features

Common Features PostgreSQL Postgres Plus Advanced Server
Full ACID Compliance Yes Yes
Multi-Version Concurrency Control (MVCC) Yes Yes
Strong conformance to ANSI-SQL:2008 standard Yes Yes
ANSI Constraints Yes Yes
Per-Column Collations Yes Yes
Column Trigger Yes Yes
Primary/Foreign keys support Yes Yes
GIN & GiST Indexes Yes Yes
Function based Indexes Yes Yes
Composite Indexes Yes Yes
K-Nearest-Neighbor Indexes Yes Yes
Index-only Scans Yes Yes
Full Text Search Yes Yes
Triggers and Stored Procedures Yes Yes
Views Yes Yes Yes
Materialized Views (with concurrent refresh) Yes Yes Yes
View Security Barriers Yes Yes Yes
SQL USAGE privilege on types Yes Yes Yes
ANSI Standard SQL GRANT/REVOKE Yes Yes Yes
Column Level Permissions Yes Yes Yes
Group/Role Support Yes Yes Yes
SQL/MED Support Yes Yes
Library interface support for libpq, JDBC, ODBC, .NET, Python, C/C++, Perl, Ruby PHP and more. Yes Yes
Foreign Data Wrappers HDFS (Hadoop)
MongoDB
MySQL
PostgreSQL
HDFS (Hadoop)
MongoDB
MySQL
PostgreSQL
Unstructured Data Types XML
JSON
JSONB
Key-Value
XML
JSON
JSONB
Key-Value
Unlogged Tables Yes Yes
Range Data Types Yes Yes
Writeable Common Table Expressions Yes Yes
Window Functions Yes Yes
Rules Engine Yes Yes
In-place version upgrades Yes Yes
Streaming Replication & Hot Standby Yes Yes
Logical Decoding Yes Yes
Online Backup and Point In Time Recovery Yes Yes
Online Index Reorganization Yes Yes
Hot restart with pg_prewarm Yes Yes
PostGIS spatial extensions support Yes Yes
Partitioning of Table and Indexes Yes Yes
Authentication support Yes LDAP
SSL
RADIUS
PAM
Kerberos
GSSAPI
SSPI
Trust
Password
Ident
LDAP
SSL
RADIUS
PAM
Kerberos
GSSAPI
SSPI
Trust
Password
Ident
DB Connection Encryption Yes SSL SSL
DB Connection White Lists Yes Yes Yes
DB Connection Black Lists Yes Yes Yes

 

Function Package Descriptions for Postgres Plus Advanced Server

Return to Feature Differences - Packages

Package Name Package Description
DBMS_ALERT Allows asynchronous notification of database events via an Alert. Using this package and triggers, an application can notify itself whenever values of interest in the database are changed.
DBMS_CRYPTO Yes Provides functions to encrypt and decrypt stored data.
DBMS_JOB Has been replaced by DBMS_SCHEDULER but included for compatibility with older Oracle applications.
DBMS_LOB Allows access to and manipulation of Large OBject values.
DBMS_LOCK Provides an interface to Lock Management services.
DBMS_OUTPUT Allows the sending of messages from stored procedures, packages, and triggers for application or debugging use.
DBMS_PIPE Functions that allow two or more sessions in the same database instance to communicate with one another.
DBMS_PROFILER Provides functions to profile SQL workloads and identify performance bottlenecks.
DBMS_SCHEDULER A job scheduler for creating and executing unattended repetitive tasks inside the database.
DBMS_SQL Permits the use of dynamic SQL in procedures to allow applications to run SQL statements with unknown parameters (such as table name) until runtime.
DBMS_RANDOM Useful functions to generate random text, numeric and date values.
DBMS_RLS Yes Implements row level security in the database blocking users from seeing each other's data in the same application.
DBMS_UTLTITY A collection of functions for getting information about various runtime operations and meta data from the database.
UTL_ENCODE Functions to perform Base64 encoding and decoding of data intended for transport between hosts.
UTL_FILE Allows database procedures to read and write operating system text files in an I/O stream fashion.
UTL_HTTP Provides the ability to make HTTP calls to access information on web servers.
UTL_MAIL Provides functions to create,manage, and send email from the database including attachments, CC, and BCC.
UTL_SMTP Provides functions for sending mail via SMTP according to the RFC821 specification.
UTL_URL Provides functions for escaping and un-escaping URL strings.

 

What's New in 9.4

• Resource Manager prioritizes CPU and I/O to protect important processes.
• Partitioning enhancements including Hash syntax
• Developer function packages including UTL_HTTP for communications with web servers
Read more about what's new...

Datasheet
Postgres Plus Advanced Server Datasheet

How to Buy

img

Postgres Plus Advanced Server is in included with the purchase of an Enterprise Edition subscription. Please Contact Us to have an EDB representative process your order.

Contact Us to Purchase

Video: Ensure Success

Learn about the EnterpriseDB software, tools and services that can ensure your successful Postgres deployment in this 3-minute video.

Upcoming Events

NoSQL Now!

2015-08-18 (All day) - 2015-08-20 (All day) San Jose, CA