DocsICP FilingConsole
官方文档
首页

Add an RDS for PostgreSQL data source

更新时间：
复制 MD 格式
产品详情
我的收藏

This topic describes how to add an RDS for PostgreSQL data source in DataV.

Prerequisites

Ensure that an RDS for PostgreSQL data source is available.

Add a data source over an internal network

  1. Log on to the DataV console.

  2. On the My Data tab, select Data Source Management and click Add Data.

  3. From the Type list, select RDS for PostgreSQL.
  4. Select Internal Network and the region where the RDS instance is located.
  5. Select the network type for the internal database. The options are virtual private cloud (VPC) and classic network.
    • Virtual Private Cloud
      1. You can turn on the VPC switch to enter VPC mode.Add an RDS for PostgreSQL data source in a VPC (private network)
      2. Enter the database information.
        Note To create a database, see Manage databases.
        ParameterDescription
        NameThe display name of the data source. You can enter any name.
        VPC IDThe ID of the VPC instance. This is the VPC where your RDS for PostgreSQL instance is located. To obtain the ID, go to the RDS console. On the Instance List > Basic Information > Network Type.获取VPC ID
        Instance IDThe ID of the database instance in the VPC. You can find this ID on the instance's basic information page in the RDS console.
        Note You can typically find the VPC instance ID on the database instance's console page. However, the ID shown in the console may not be the one that DataV requires for VPC configuration. You must get the correct VPC instance ID using the database product's API. The ID is usually the `VpcCloudInstanceId` or `VpcInstanceId` in the instance details. For more information about the API operation to query instance details, see DescribeDBInstanceAttribute - Query instance details.
        Domain NameThe endpoint used to connect to the database.
        Important This endpoint must be a domain name or IP address that the DataV server can access over the public network or an Alibaba Cloud internal network in certain regions.

        For example, for an Alibaba Cloud RDS for PostgreSQL instance on an internal network, the domain name might be pgm-bpxxxxxxxxxxxxxx15970.pg.rds.aliyuncs.com. You can find the domain name on the instance's basic information page in the RDS console.

        PortThe port used by the database.
        UsernameThe username for logging on to the database.
        PasswordThe password used to log on to the database.
        DatabaseThe name of the database.
      3. After you enter the database information, the system automatically performs a connection test to verify that the database is accessible.
    • Classic Network
      1. Turn off the VPC switch to enter classic network mode.
      2. Enter the database information.添加RDS for PostgreSQL数据源（内网）经典网络
        Note To create a database, see Manage databases.
        ParameterDescription
        NameThe display name of the data source. You can enter any name.
        Domain NameThe endpoint used to connect to the database.
        Important This endpoint must be a domain name or IP address that the DataV server can access over the public network or an Alibaba Cloud internal network in certain regions.

        For example, for an Alibaba Cloud RDS for PostgreSQL instance on an internal network, the domain name might be pgm-bpxxxxxxxxxxxxxx15970.pg.rds.aliyuncs.com. You can find the domain name on the instance's basic information page in the RDS console.

        PortThe port used by the database.
        UsernameThe username for logging on to the database.
        PasswordThe password to log on to the database.
        DatabaseThe name of the database.
      3. After you enter the database information, the system automatically performs a connection test to verify that the database is accessible.
  6. After the connection test is successful, click OK to add the data source.

    The new data source appears in the data source list.

Add a data source over the public network

  1. Log on to the DataV console.

  2. On the My Data tab, select Data Source Management and click Add Data.

  3. From the Type list, select RDS for PostgreSQL.
  4. Select Public Network as the network type.

    For more information about how to set a public endpoint, see Set connection endpoints.

  5. Enter the database information.
    添加RDS for PostgreSQL数据源（外网）
    ParameterDescription
    NameThe display name of the data source. You can enter any name.
    Domain NameThe endpoint used to connect to the database.
    Important This endpoint must be a domain name or IP address that the DataV server can access over the public network or an Alibaba Cloud internal network in certain regions.

    For example, for an Alibaba Cloud RDS for PostgreSQL instance on the public network, the domain name might be pgm-bpxxxxxxxxxxxxxxqo.pg.rds.aliyuncs.com. You can find the domain name on the instance's basic information page in the RDS console.

    PortThe port used by the database.
    UsernameThe username for logging on to the database.
    PasswordThe password to log on to the database.
    DatabaseThe name of the database.

    After you enter the database information, the system automatically performs a connection test to verify that the database is accessible.

  6. After the connection test is successful, click OK to add the data source.

    The new data source appears in the data source list.

Previous：Add an RDS for MySQL data sourceNext：Add an ApsaraDB RDS for SQL Server data source