Getting Started with OCI Database with PostgreSQL

Ensure that you have installed, obtained, or created the prerequisites:

• An Oracle Cloud Infrastructure tenancy.
• An account with the privileges to create users, add users to user groups, create security policies, and create compartments. For more information, see Overview of IAM.

To get started quickly with OCI Database with PostgreSQL, IAM resources and policies are required. See the following steps for more information:

1. Create or choose a compartment to contain PostgreSQL-related network infrastructure and resources. For more information, see Managing Compartments.
2. Create or choose a group of PostgreSQL administrators. For more information, see Managing Groups and Creating a User.
3. Create the IAM policies required for PostgreSQL administrators to manage OCI Database with PostgreSQL resources.

To get started quickly with OCI Database with PostgreSQL, networking resources are required. See the following steps for more information:

1. Create a Virtual Cloud Network (VCN) and subnets. You can use a quickstart to quickly create a VCN and related resources. For more information, see VCN and Subnet Management.
2. Create a Compute instance that's accessible from the internet.
3. Create a private Compute instance to access the database.

After the necessary OCI prerequisites and network are in place, you can create the database.

1. Create or choose a vault for the database administrator password. For more information, see Managing Vaults.
2. Create a key for the database password. For more information, see Managing Keys.
3. Create a secret for the database password. For more information, see Managing Vault Secrets.
4. Create an OCI Database with PostgreSQL.

After you create the database, you can connect to the database system. See Connecting to a Database.