Adding an Instance for Amazon Aurora PostgreSQL

To manage a database, you can either use an existing instance or add a new instance.

Before You Begin

Configure the permissions to access AWS resources. Download the amazon_rds_dumpbased_backup_restore_permissions.json file and use it on the AWS command line to apply all the permissions.

Procedure

From the navigation pane, go to Protect > Databases.

The Overview page appears.
Click Add instance, and then select Cloud database service.

The Add Cloud DB instance dialog box appears.
Select Amazon Web Services and then click NEXT.

The Configure Amazon Database dialog box appears.
Select RDS (Export) and click NEXT.

The Configure Amazon Database - RDS (Export) page appears.
Select Aurora PostgreSQL and click NEXT.

The Configure Amazon database - RDS (Export) - Aurora PostgreSQL page appears.
In the Plan section, select a backup plan to use for the instance, and then click Next.

The Cloud Account page appears.
From the Cloud account list, select an existing cloud account or add a new cloud account. To add a new cloud account, do the following:
Steps to add new cloud account:
1. Beside the Cloud account list, click +.
  
  The Add cloud account dialog box appears.
2. In the Name box, type the name for the account.
3. In the Regional endpoints box, type the region where the Amazon RDS instance is located.
4. Select the one of the following as per the requirement:
  - IAM role for Amazon EC2
  - AWS STS AssumeRole
  - Access keys for IAM users
5. Select an existing credential or add a new credential.
  Steps to add a new credential
  1. Click the + icon beside the Credentials list.
    
    The Add Credential dialog box appears.
  2. Credential Vault: Select the credential vault from the list.
  3. Credential name: Enter a name for the credential.
  4. Role ARN: Enter to configuring Amazon S3 cloud storage with STS Assume Role or IAM Role Policy authentication.
  5. External ID: Enter an external PostgreSQL ID.
  6. Description: Enter a description of the credential.
  7. Click Save.
6. From the Access node list, select an access node.
7. Click Save.
Click Next.

The Backup Content page appears.
Instance name: Select instances based on their names.
Under the Connection details section, enter the following details:
1. From the Credential list, select a saved credential or add a new credential.
  Steps to add a new credential
  1. Click the + icon beside the Credentials list.
    
    The Add Credential dialog box appears.
  2. From Account type list, select a database account.
  3. From the Database credential type, select a database.
  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. In the Username box, enter the user name to access the Database application.
  7. In the Password box, enter the password to access the Database application.
  8. Under the Azure AD/AWS IAM/GCP IAM Authentication section, enter the following details:
    - In the Username box, enter the user name to access the Azure Database for PostgreSQL application.
    - 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 right, you only need to enter the user name detail.
  9. The SSL certificate toggle key is unselected by default. By moving the toggle key to right, you can perform the following actions:
    - In the SSL CA file field, provide the SSL CA file path on the proxy computer.
    - In the SSL Cert file field, provide the SSL certificate file path on the proxy computer.
    - In the SSL Key file field, provide the SSL key file path on the proxy computer.
  10. In the Description box, enter the details of the credential.
  11. Click Save.
2. In the Maintenance DB box, enter a PostgreSQL maintenance database.
3. In the Endpoint box, type the name of the endpoint to connect to the database instance.
Click Next.
To filter the content that is backed up, click Edit, select or clear the tables, and then click Save.

The Summary page appears.
Review the summary, and then click Finish.

Results

The new instance contains a dump-based backup set and a default subclient.
When you add an instance, a default database group is automatically created. The default database group includes all the data in the PostgreSQL database. You cannot delete the default database group.

Adding an Instance for Amazon Aurora PostgreSQL

Before You Begin

Procedure

Results

Page contents