All Products
Search

This Product

    ApsaraDB for OceanBase:Create a PostgreSQL data source

    Document Center

    ApsaraDB for OceanBase:Create a PostgreSQL data source

    Last Updated:Jun 03, 2024

    Before you create a data migration or synchronization project, you must create the data sources. This topic describes how to create a PostgreSQL data source in the data transmission service.

    Prerequisites

    You have created an ApsaraDB RDS for PostgreSQL instance. For more information, see Create an ApsaraDB RDS for PostgreSQL instance.

    Important

    The data transmission service does not support serverless or read-only PostgreSQL instances.

    Procedure

    1. Log on to the ApsaraDB for OceanBase console.

    2. In the left-side navigation pane, choose Data Transmission > Data Source Management.

    3. On the Data Sources page, click New Data Source in the upper-right corner.

    4. In the New Data Source dialog box, set Data Source Type to PostgreSQL and set the parameters.

      Parameter

      Description

      Instance Type

      Currently, only RDS Instance is supported.

      Data Source Identifier

      We recommend that you set it to a combination of digits and letters. It must not contain any spaces and cannot exceed 32 characters in length.

      Across Alibaba Cloud Accounts

      The data transmission service allows you to configure a data migration or synchronization project between instances under different Alibaba Cloud accounts to migrate or synchronize data across Alibaba Cloud accounts.

      You can choose whether to select this option based on business needs. If you select this option, enter the Alibaba Cloud account of the destination instance. If you do not have permissions on this Alibaba Cloud account, request for authorization first. For more information, see Apply for cross-account authorization.

      RDS Instance ID

      The ID of the destination ApsaraDB RDS instance. Select the ID from the drop-down list.

      Username

      The username used for migrating or synchronizing the data of the ApsaraDB RDS for PostgreSQL instance.

      Password

      The password of the database user.

      Database Name

      The name of the ApsaraDB RDS for PostgreSQL database.

      Note

      When the data source is used as the source of a data migration or data synchronization project, you can specify the objects to migrate or synchronize only in this database.

      Remarks (Optional)

      Additional information about the data source.

    5. Click Test Connection to verify the network connection between the data transmission system and the data source, as well as the validity of the username and password.

    6. After the test is passed, click OK.