Adding a PostgreSQL Instance for AlloyDB Omni Cluster

You can add master or standby instances for AlloyDB Omni cluster.

Procedure

1. From the Command Center navigation pane, go to Protect > Databases.

   The database Overview page appears.

2. From the Add instance list, select Database server.

   The Configure Database Instance page appears.

3. Select PostgreSQL Cluster, and then click Next.

   The Add Instance page appears.

4. Select an existing backup plan or add a new backup plan.

5. Click Next.

   The Configure PostgreSQL Cluster Instance Name page appears.

6. In the Instance name box, enter the name of the database instance.

7. From the Cluster type list, select AlloyDB Omni, and then click Next.

   The Configure PostgreSQL Cluster Instance Nodes page appears.

8. Select an existing Kubernetes Credential or add a new one to connect to the Kubernetes cluster. To add a new credential, do the following:

   Steps to add a Kubernetes credential

   1. Click +.

      The Add credential dialog box appears.

   2. In the Credential name box, enter a credential name.

   3. In the Kubernetes API server, enter a suitable Kubernetes cluster API server. To find the API server, run the Kubectl cluster-info command.

   4. In the CA Certification box, enter the encoded root certification.

   5. In the Service account box, enter the service account used to connect to the Kubernetes cluster.

   6. In the Service token, enter the service account token for your Kubernetes service account. To find the service token, run the Kubectl describe command.

   7. From the Key Rotation Reminder Interval list, select a suitable interval.

   8. Click Save.

9. From the Access node list, select one or more access nodes.

10. In the Label selected field, enter the label to filter the instances.

11. From the DB Cluster list, select a database cluster. You can use the Discover button to discover the database cluster.

12. Select an existing PostgreSQL credential or add a new credential. To add a new credential, do the following:

    Steps to add a database credential

    1. Click + icon.

       The Add Credential dialog box appears.

    2. From the Account type list, select a database account.

    3. From the Database credential type list, select a credential type.

    4. From the Credential Vault list, select a credential vault to store credentials for different types of accounts.

    5. In the Credential name box, enter a name for the credential.

    6. Under the Azure AD/AWS IAM Authentication section, enter the following details:

       1. In the Username box, enter the user name to access the Azure Database for PostgreSQL application.

       2. In the Password box, enter the password to access the Azure Database for PostgreSQL application.

       Note

       If you move the Azure AD/AWS IAM Authentication toggle to the right, you only need to enter the user name detail.

    7. The Use SSL options toggle key is unselected by default. By moving the toggle key to the right, you can perform the following actions:

       1. In the SSL CA file field, provide the SSL CA file path on the proxy computer.

       2. In the SSL Cert file field, provide the SSL certificate file path on the proxy computer.

          1. In the SSL Key file field, provide the SSL key file path on the access node.

    8. In the Description box, enter the details of the credential.

    9. From the Key Rotation Reminder Interval list, select a suitable interval.

    10. Click Save.

13. Click Next.

14. On the Summary page, verify the information, and then click Finish.

What to Do Next

Perform restore operations.