In part3, I summarized the MySQL based options available for DB deployment on OCI. In this post I will talk about the options available for deploying PostgreSQL on OCI. While one is free to run PostgreSQL as IaaS, along with other Oracle & non-Oracle databases, OCI offers PostgreSQL also as a managed service. Both Intel & AMD based flex shapes are available and it allows you to size OCPUs and memory independent of each other. Vertical scale up/down can be done on the fly. Here are some other important features:
- The PostgreSQL supported versions range from version 14 to 16
- There are number of extensions that are supported out of the box (here is a list).
- IOPS range from 75K to 750K. Storage is decoupled from the compute and IOPS can scale independently.
- It supports up to 8 number of nodes where 1 is a primary node and others are standby/replica nodes.
- The service supports backups to Object Storage and a retention of up to 35 days. For redundancy, backup copies can be created in a different region.
Here is a link to the quick guide to create a new PostgreSQL based DB system. Enjoy your PostgreSQL journey !