PostgreSQL, also known as Postgres, is a free, open-source relational database management system (RDBMS) and is used as the primary data store or data warehouse for many web, mobile, geospatial, and analytics applications.
OCI Database with PostgreSQL is a fully managed PostgreSQL-compatible service with intelligent sizing, tuning, and high durability.
The service automatically scales storage as database tables are created and dropped, making management easier on you, and optimizing storage spend. Data is encrypted both in-transit and at rest. OCI Database with PostgreSQL is designed for high availability by offering durability even in the event of an availability domain (AD) failure.
Currently, the supported version of PostgreSQL is 14. 9.
Why PostgreSQL on Oracle Cloud Infrastructure.
Flexible Deployment Options: OCI offers various deployment options, including Virtual Machines (VMs), Bare Metal instances, and containerized environments using Kubernetes.
Security: OCI has robust security features, including network security, encryption, and identity management.
Managed Services: OCI offers managed database services, including the Oracle Cloud Database service for PostgreSQL. This service automates routine database tasks such as backups, patching, and scaling.
Integration with Other Oracle Services: If your application leverages other Oracle Cloud services, such as Oracle Cloud Infrastructure Object Storage, Identity and Access Management (IAM), or monitoring services, using PostgreSQL on OCI can facilitate seamless integration with these services.
Up to 3x higher performance: OCI provides high-performance compute and storage options. You can leverage high-performance block storage and fast networking to ensure that your PostgreSQL database performs optimally.
Less than half the cost of AWS: OCI provides various pricing models, including pay-as-you-go and subscription options, Less than half the cost of AWS When you run PostgreSQL on OCI, whether in Phoenix, Sao Paulo, or Tokyo.
Open-Source Compatibility: PostgreSQL is an open-source relational database, and OCI supports open standards. This combination allows you to leverage the benefits of open-source software while benefiting from the features and infrastructure of Oracle Cloud.
Features of PostgreSQL Database on OCI:
High Availability for Business Continuity:
Dynamically scaling storage:
Deploying PostgreSQL Database on OCI
OCI Database with PostgreSQL is distinguished by its database optimized storage technology. Oracle’s unique approach of decoupling compute from storage not only delivers superior performance compared to competitors with OCI Database Optimized Storage, but also ensures faster recovery. It promises unparalleled reliability and durability, ensuring immediate data protection and swift recovery with a low RTO.