Feature

PostgreSQL

Postgres Plus Standard Server

Postgres Plus Advanced Server

Primary Differentiators(s)
 

One-click Installer
 

Adds:
Enterprise modules
Installation Tuning
 

Adds:
Oracle Compatibility,
Performance,
Scalability, & DBA
and Developer Tools
 

Supported Platforms

Linux x86/32
Linux x86/64
Windows^®
 
 

Linux x86/32
Linux x86/64
Windows
 
 

Linux x86/32
Linux x86/64
Windows
Solaris^® x86/64
Solaris SPARC^®
 

Full ACID compliance

Views

User Defined Data Types

ANSI Constraints

Function based Indexes

Partial Indexes

Data and Index Partitioning

Bitmap Indexes

Primary and Foreign keys

Column Level Permissions

Rules Engine

Inheritance

Triggers & Stored Functions

Windowing Functions

Recursive Queries

Nested Transactions

Procedural Language support

SQL/XML Support

Multi-version Concurrency Control (MVCC)

Full Text Search

PostgreSQL Database Links

Pluggable Authentication

Heap-Only Tuples (HOT)

GUI Administration Console (pgAdmin)

Point-in-Time Recovery (PITR)

Online Index Reorganization

Online Backup

Parallel Restore

Interactive SQL Terminal

Client Connectors

 libpq
 ECPG
 
 
 
 
 

 libpq
 ECPG
 pgJDBC
 psqlODBC
 Npgsql(.NET)
 
 

 libpq
 ECPG
 pgJDBC
 psqlODBC
 Npgsql(.NET)
 OCL(OCI)
 

Authentication support

 Trust
 Password
 GSSAPI
 SSPI
 Kerberos
 Ident
 LDAP
 SSL br> PAM
 

 Trust
 Password
 GSSAPI
 SSPI
 Kerberos
 Ident
 LDAP
 SSL
 PAM
 

 Trust
 Password
 GSSAPI
 SSPI
 Kerberos
 Ident
 LDAP
 SSL
 PAM
 

Distributed Memory Caching (pgmemcache)

Integrated Connection Pooling (pgBouncer)

Job Scheduler (pgAgent)

Postgres Replication (Slony)

GeoSpatial Support (PostGIS)

PL/pgSQL Debugger

Integrated Add-On Components

Installation Tuning

Automatic Update Notification

Open Source Database Migration

Standby Database for Disaster Recovery

Certified Binaries

DynaTune^®

SQL/Protect

User Defined Object Types

Oracle Dictionary Views

49
 

EDB*Loader

Oracle SQL Extensions

Object Types support

Oracle Database Links

Infinite Cache (includes DB-in-Cache)

Asynchronous Pre-Fetch for RAID

Bitmap Indices
 

Bitmap Indices
 

Bitmap Indices
Regular Indices
 

GridSQL^® with Parallel Query

Bulk Collect / Bulk Bind

Query Optimization Hints

DRITA (Dynamic Runtime Instrumentation)

EDB*Plus

PL/SQL Support

PL/SQL Debugger

EDB*Wrap (source code protection)

EDB*Package (built-in code packages)

DBMS_ALERT
DBMS_JOB
DBMS_LOB
DBMS_OUTPUT
DMBS_PIPE
DBMS_SQL
DBMS_UTLTITY
UTL_FILE
UTL_MAIL
UTL_SMTP
 

User Defined Packages

Explicit Transaction Control

EDB*OCI

GridSQL Monitoring Console

Multi-threaded Oracle Replication

Oracle Replication Server

Oracle Replication Console/CLI

Migration Studio

MySQL
Oracle
SQL Server
Sybase
 

DBA Management Server

DBA Monitoring Console

Indemnification and Warranties

Audit Logging

Programming Language Support

PL/pgSQL
PL/Java^®
PL/Ruby
PL/Python
PL/PHP
PL/Perl
C/C++
PL/Tcl
PL/Scheme
 

PL/pgSQL
PL/Java^®
PL/Ruby
PL/Python
PL/PHP
PL/Perl
C/C++
PL/Tcl
PL/Scheme
 

PL/SQL
PL/pgSQL
PL/Java^®
PL/Ruby
PL/Python
PL/PHP
PL/Perl
C/C++
PL/Tcl
PL/Scheme
 

Library Interface Support

libpq
JDBC
ODBC
.NET™
Perl
Python
Ruby
C/C++
PHP
Lisp
Scheme
Qt
 

libpq
JDBC
ODBC
.NET
Perl
Python
Ruby
C/C++
PHP
Lisp
Scheme
Qt
 

OCL(OCI)
libpq
JDBC
ODBC
.NET
Perl
Python
Ruby
C/C++
PHP
Lisp
Scheme
Qt
 

StackBuilder (Plus) Modules

MySQL Migration
.NET Connector
pgJDBC Connector
psqlODBC Conn.
Tuning Wizard
Slony-I Replication
PostGIS GeoSpatial
pgPhoneHome
Drupal
mediaWiki
phpBB
phpWiki
ApachePHP
phpPgAdmin
 

Postgres Plus HQ
xDB Replica. Server
PL/Secure
Migration Toolkit
pgAgent Jobs
PgBouncer
pgmemcache library
MySQL Migration
.NET Connector
pgJDBC Connector
psqlODBC Conn.
Tuning Wizard
Slony-I Replication
PostGIS GeoSpatial
pgPhoneHome
Drupal
mediaWiki
phpBB
phpWiki
ApachePHP
phpPgAdmin
 

Postgres Plus HQ
xDB Replica. Server
PL/Secure
Migration Toolkit
pgAgent Jobs
PgBouncer
pgmemcache library
MySQL Migration
.NET Connector
pgJDBC Connector
psqlODBC Conn.
Tuning Wizard
Slony-I Replication
PostGIS GeoSpatial
pgPhoneHome
Drupal
mediaWiki
phpBB
phpWiki
ApachePHP
phpPgAdmin