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 database compatibility
Security
Avoids relying entirely on developers or client application layers to enforce password policies, and supports compliance with GDPR, PCI, and HIPAA standards.
- Password policy management
- Session tag auditing
- Data redaction
- SQL injection protection
- Procedural language code obfuscation
Performance
Improves the end-user experience by identifying which queries are running slow and need tuning
- Query optimizer hints
- SQL session/system wait diagnostics
Developer Productivity
Helps developers code faster with fewer errors and create more sophisticated applications
- Over 200 pre-packaged utility functions
- User-defined object types
- Autonomous transactions
- Nested tables
- Synonyms
- Advanced queueing
DBA Productivity
Enables prioritizing workloads such as analytics over batch processing without endangering responsiveness, which saves time with troubleshooting, monitoring security, and maintenance.
- 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
Oracle Database Compatibility
Migrate database and client applications faster with fewer rewrite problems. Continue to use Oracle skills and more easily integrate into existing Oracle database infrastructures.
Compatibility for:
- schemas
- data types
- indexes
- users
- roles
- partitioning
- packages
- views
- PL/SQL triggers
- stored procedures
- functions
- utilities
Quick Look: Oracle Database 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