Advanced Server is PostgreSQL for the Enterprise
EDB Postgres Advanced Server gives you the best of both worlds—all the advantages of PostgreSQL, enhanced with mission-critical features that help you maintain greater consistency across your PostgreSQL deployments. Regardless of where you want to deploy Postgres—on premises, in the cloud, or multi-platform—EDB Postgres Advanced Server gives you greater control.
Migrate from Oracle faster
Compatibility with Oracle database schemas, data types, indexes, users, roles, partitioning, packages, views, PL/SQL triggers, stored procedures, functions, and utilities
Reduce risk and support compliance with HIPAA, GDPR, and PCI
Enhanced security features such as password policy management, session tag auditing, data redaction, and SQL injection protection
Improve developer and DBA productivity
Over 200 pre-packaged utility functions, user-defined object types, autonomous transactions, nested tables, synonyms, advanced queueing, catalog views, and more
Advanced Server Extends PostgreSQL
Security, performance, productivity, and Oracle-compatibility
Security
Password policy management, session tag auditing, data redaction, SQL injection protection, and procedural language code obfuscation
- Avoids relying entirely on developers or client application layers to enforce password policies
- Supports compliance with GDPR, PCI, and HIPAA standards
Performance
Query optimizer hints, SQL session/system wait diagnostics
- Improves the end-user experience by identifying which queries are running slow and need tuning
Developer Productivity
Over 200 pre-packaged utility functions, user-defined object types, autonomous transactions, nested tables, synonyms, advanced queueing
- Helps developers code faster with fewer errors and create more sophisticated applications
DBA Productivity
Throttle CPU and I/O at the process level, over 55 extended catalog views to profile all the objects and processing that occurs in the database
- Enables prioritizing workloads such as analytics over batch processing without endangering responsiveness
- Saves time with troubleshooting, monitoring security, and maintenance
Oracle Compatibility
Offers compatibility for schemas, data types, indexes, users, roles, partitioning, packages, views, PL/SQL triggers, stored procedures, functions, and utilities
- Helps to migrate database and client applications faster with fewer rewrite problems
- Lets you continue to use Oracle skills and more easily integrate into existing Oracle infrastructures
Quick Look: Oracle Compatiblity
Video duration: 1 minute
Related Tools
EDB Postgres Tools integrate seamlessly with Advanced Server
Postgres Enterprise Manager →
PostgreSQL GUI for enterprises
Backup and Recovery Tool →
Disaster recovery for PostgreSQL
Failover Manager →
High availability for PostgreSQL
Migration Portal →
Browser-based schema migration tool
Migration Toolkit →
Command-line data migration tool
Replication Server →
Read/write geographically distributed PostgreSQL
Related Services
Quick Deploy
Accelerate the implementation of Postgres
Migration Assessment
Determine the level of effort required to migrate to Postgres
Remote DBA Service
Support for PostgreSQL on-premises