PostgreSQL Team Data Sheet

Database Versions and Editions: Versions - 15.x 14.x 13.x 12.x 11.x (supported), Versions - 10.x 9.x 8.x (unsupported)

‍

Advanced Features: Materialized Views, Foreign data wrappers, Module Library, PostgreSQL two-phase commit, Data Definition Language, Advanced Performance Features, XML, JSON and YAML

‍

High Availability and Recovery: , Shared Disk Failover, File System (Block Device) Replication, Write-Ahead Log Shipping, Logical Replication, Trigger-Based Primary-Standby Replication, SQL-Based Replication Middleware, Asynch & Synch Multimaster Replication

‍

Related Products: Administration/development tools, Clustering/replication, Drivers and interfaces, PostgreSQL- derived servers, PostgreSQL extensions, Procedural languages, Reporting tools

Monitoring and Alerting Tools: Logic Monitor, DataStrike custom scripts, Client alerting system, DataDog, Percona

‍

Performance Tuning: Multi-core Scalability, VACUUM and Maintenance, Instance Tuning (Configuration), Performance Tuning (Code), Data Cleansing and Archiving, Reindexing, Defragmentation, Integrity Checks

‍

Management: 24x7 Incident Management, User and Security Admin, Upgrades/Migrations, Patching, ETL Solutions, Problem Management, Root Cause Analysis, Backup/Restore, Disaster Recovery, Regulatory Compliance Support

Infrastructure as a Service (IaaS): PostgreSQL on AWS, PostgreSQL on Azure, PostgreSQL on OCI

‍

Managed Database as a Service (DBaaS): Azure Database for PostgreSQL, Amazon RDS for PostgreSQL, PostgreSQL on Private Cloud

High Availability Deployments

Cloud Migrations

Oracle to PostgeSQL

Application Migrations

PostgreSQL NoSQL Integration