The Databases guided setup guides you through creating a backup plan and adding a Amazon RDS for PostgreSQL database server.
To complete the guided setup, you need the following information:
-
The server name
-
The host name
-
The credentials that you use to access the server
-
The packages that you want to install, such as Oracle
Note
If you are configuring a database that uses a pseudoclient, you must manually install the packages on the physical servers before you use the guided setup. For more information, see Adding a New Server.
Procedure
-
From the left navigation pane, go to Guided setup.
The Welcome page appears.
-
In the Databases tile, click Configure.
The Configure Database Server page appears.
-
Select Database running in the cloud (PaaS).
-
Select Amazon Web Services, and then click Next.
-
Select RDS (Export) as a database service, and then click Next.
-
Select PostgreSQL, and then click Next.
The Configure Amazon database - RDS (Export) - 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:
-
Beside the Cloud account list, click +.
The Add cloud account dialog box appears.
-
In the Name box, type the name for the account.
-
In the Regional endpoints box, type the region where the Amazon RDS instance is located.
-
Select the one of the following as per the requirement:
-
IAM role for Amazon EC2
-
AWS STS AssumeRole
-
Access keys for IAM users
-
-
Select an existing credential or add a new credential.
Steps to add a new credential
-
Click the + icon beside the Credentials list.
The Add Credential dialog box appears.
-
Credential Vault: Select the credential vault from the list.
-
Credential name: Enter a name for the credential.
-
Tenant ID: Enter the tenant ID associated with the Azure account.
-
Application ID: Enter the application ID associated with the tenant.
-
Application secret: Enter the application password.
-
Environment: Select the Azure environment type.
-
Description: Enter a description of the credential.
-
Click Save.
-
-
From the Access node list, select an access node.
-
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:
-
From the Credential list, select a saved credential or add a new credential.
Steps to add a new credential
-
Click the + icon beside the Credentials list.
The Add Credential dialog box appears.
-
From Account type list, select a database account.
-
From the Database credential type, select a database.
-
From the Credential Vault list, select a credential vault to store credentials for different types of accounts.
-
In the Credential name box, enter a name for the credential.
-
In the Username box, enter the user name to access the Database application.
-
In the Password box, enter the password to access the Database application.
-
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.
-
-
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.
-
-
In the Description box, enter the details of the credential.
-
Click Save.
-
-
In the Maintenance DB box, enter a PostgreSQL maintenance database.
-
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.