This respositry is to help deploy Oracle Postgres SQL services on Oracle cloud Infrastructre (OCI) .
This code would deploy following components :
- Oracle Virtual Cloud Network (VCN) wth a Private Subnet
- OCI Postgres SQL service using the Private subnet
- OCI KMS Vault,Key,Secret ( for psql admin password )
You can control the creation of VCN/Subnets and pass a existing private subnet ID as well. As of now the Code creates OCI KMS Secrets to store the psql admin password and it can be retrived from secret post creation . Postgres SQL instance gets created with replicas if the inst-count > 1 . Currently the Instance shapes are limited to AMD with OCPUs 2,4,8,16,32,64 and Memory = > #OCPU * 16
Known Issues:
Known Issues:
1. The OCI KMS Vault/Key creation can fail with below error :
Error: Post "https://xyzxyzxzyxy-management.kms.us-ashburn-1.oraclecloud.com/20180608/keys": dial tcp: lookup xyzxyzxzyxy-management.kms.us-ashburn-1.oraclecloud.com on 169.254.169.254:53: no such host
Workaround : Upon retry couple of times , the operation succeeds .