A managed PostgreSQL service offers a hands-off approach to database deployment, maintenance, and management. Users benefit from automated backups, updates, and scaling without manual intervention, ensuring they can focus on application development rather than database administration.
With a managed service, security and all the administrative tasks such as backups, patching, scaling are handled by the service provider. In a traditional installation, these responsibilities fall on the user or the internal IT team.
OCI Database with PostgreSQL is distinguished by its database optimized storage technology. Our 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.
Oracle’s managed PostgreSQL service is designed to minimize downtime. Most maintenance tasks, including scaling, are performed seamlessly. However, certain critical updates may require a short downtime, which we schedule during off-peak hours and notify users in advance. You can also customize the maintenance window to better adapt to the requirements of your application.
We currently support PostgreSQL version 14.9.
The current list of PostgreSQL extensions supported by the service can be found here.
Oracle secures data with VPC network isolation, encryption in transit and at rest, and routine security updates. OCI Identity and Access Management integration manages administrative functions and creates an initial database admin role, which enables further permission management within the database system.
Yes, data replication is a standard feature. During the database creation process, you can select two nodes: one primary and one replica. We utilize multiple fault domain and availability domain deployments (where available) to ensure high availability. In the rare event of a primary node failure, traffic is automatically routed to a standby replica to ensure minimal service disruption.
Absolutely. We provide automated backups on a daily, weekly, or monthly cadence with your chosen retention time based on your needs. If you created a backup, just click on the backup details to initiate a restore.
Integration is straightforward. Once your database is set up, you'll receive connection details that can be plugged into your application's configuration. We offer SDK/APIs for management of database systems, configurations, and backups.
We provide a generous connection limit suitable for most applications. Default connection limits are provided via default configuration of a shape (OCPU and memory). You can also create custom configurations with different connection limit and apply those configurations either during creation of database system or you can modify an existing database system.
Pricing is based on the storage, compute resources, and additional features you choose. Our transparent pricing model ensures you only pay for what you use, with no hidden fees.
Data transfer in and out of the database within the same region is included in the base price. However, cross-region or external data transfers may incur additional charges. Backups will incur a standard OCI Object Storage charge based on the size and retention time. After backup retention time, the backup would be deleted, and there will be no further charge for that backup.
We accept all major credit cards and bank transfers. Billing occurs monthly, with detailed breakdowns of resource usage and any additional charges provided in the invoice.