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.
Introduction
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:
Backups:
- Automatic backups can be scheduled to be created daily, weekly, and monthly.
- Automatic backups have a retention period of up to 35 days before they're deleted by the system.
- When you create a backup manually, you can choose whether the backup is retained indefinitely or deleted on a specific date, or after a specified number of days.
High Availability for Business Continuity:
- The OCI Database with PostgreSQL service offers a 99.99% uptime SLA, a Recovery Time Objective (RTO) of less than 2 minutes for multi-node database systems, and a Recovery Point Objective (RPO) of 0 with no data loss.
- For single-node database systems in single AD-regions, the service offers a 99.9% uptime SLA, an RTO of less than 20 minutes, and an RPO of 0.
- OCI Database with PostgreSQL leverages Block Volume to store user data. So, the same durability, security, and performance guarantees apply.
Dynamically scaling storage:
- Storage scales dynamically, without any downtime.
Security:
- Oracle secures data with VPC network isolation, encryption in transit and at rest, and routine security updates.
- Regularly apply security patches and updates to both the operating system and PostgreSQL database software. Stay informed about security vulnerabilities and update.
Deploying PostgreSQL Database on OCI
Conclusion:
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.
Write to us for all PostgreSQL database on cloud consulting services:
