Loading...

Configuring a PostgreSQL Server Instance That Is Hosted in the Alibaba RDS Cloud

To configure a PostgreSQL server instance that is hosted in the Alibaba RDS cloud, create an EC2 instance in the Alibaba cloud to function as the proxy client computer, add the proxy client computer in the CommCell Console, create a virtualization client to function as the pseudoclient, and then add the PostgreSQL server instance to the pseudoclient.

Step 1: Configure a Proxy Client Computer

  1. Create an EC2 instance in the Alibaba cloud to function as the proxy client computer.

    The instance can be a Linux client computer or a Windows client computer.

    For instructions, see Alibaba Elastic Computer Service Documentation.

  2. Add the proxy client computer in the CommCell Console.
  3. To enable the CommServe host, the MediaAgent, and the proxy client computer to communicate with each other, establish the connections.
  4. Install the PostgreSQL Agent software on the proxy client computer.
  5. Install the PostgreSQL database application on the proxy client computer.

    The database application must be of the same major version as the PostgreSQL server instance in the Alibaba RDS cloud. For instructions, see the PostgreSQL documentation.

    The database application does not need to be in a running state.

    If you plan to use the same proxy client computer to back up PostgreSQL server instances of different versions, then you must install all those versions on the proxy client computer.

Step 2: Configure the Pseudoclient

  1. Install the Virtual Server package on a Windows client computer or a Linux client computer.

    For instructions, see Client Installations.

    Note: If you configure a Linux client computer, you must install the Mono framework on the computer. For instructions, see Installing Mono.

  2. Create a virtualization client to function as the pseudoclient.

    Add the client computer that you installed the Virtual Server package on as the proxy server.

    For instructions, see Creating an Alibaba RDS Pseudo-Client.

  3. Add the PostgreSQL Agent to the pseudoclient.

    When adding the agent, select the proxy client computer in the Cloud Configuration tab.

    For instructions, see Adding the PostgreSQL Database Agent to the Pseudoclient.

    You can configure the PostgreSQL database version of the pseudoclient.

Step 3: Configure PostgreSQL Server on the Pseudoclient

  1. Add a PostgreSQL server instance to the pseudoclient.
  2. To include a subset of the databases in the backup, then create a subclient for the data.

Step 4: Run the First Backup Operation and the First Restore Operation

  1. You must exclude the rdsadmin database from the backup.

    Create a separate subclient for the database.

    For instructions, see Creating a Subclient for PostgreSQL Databases.

  2. Perform a backup operation.

    For instructions, see Performing Backup of a PostgreSQL Database.

  3. Perform a restore operation.

    For instructions, see PostgreSQL Instance Restore Operations.

Last modified: 8/29/2019 6:49:28 AM