All Products
Search

This Product

    AnalyticDB for PostgreSQL:Enable or disable data sharing

    Document Center

    AnalyticDB for PostgreSQL:Enable or disable data sharing

    Last Updated:Feb 19, 2024

    After you enable data sharing for AnalyticDB for PostgreSQL instances in Serverless mode, you can query data across the instances. This ensures data timeliness and significantly reduces data redundancy.

    Limits

    • All instances must be in Serverless mode.

    • All instances must belong to the same Alibaba Cloud account.

    • All instances must reside within the same region.

    • Only tables can be shared.

    Enable data sharing for instances

    1. Log on to the AnalyticDB for PostgreSQL console.
    2. In the upper-left corner of the console, select a region.

    3. In the left-side navigation pane, click Data Sharing.

    4. On the Instances for Data Sharing tab, select the instances for which you want to enable data sharing, and then click Add.

    5. In the Add Instances for Data Sharing message, click OK.

      Note

      This process may take 5 to 10 minutes to complete. After instances are added for data sharing, shared data can be queried across the instances.

    Disable data sharing for instances

    Warning

    After data sharing is disabled, other instances cannot access the shared data.

    1. Log on to the AnalyticDB for PostgreSQL console.
    2. In the upper-left corner of the console, select a region.

    3. In the left-side navigation pane, click Data Sharing.

    4. On the Instances for Data Sharing tab, select the instances for which you want to disable data sharing, and then click Disable.

    5. In the Disable Data Sharing message, click OK.

    What to do next

    After instances are added for data sharing, you must execute SQL statements to configure data sharing. For more information, see SQL operations for data sharing.

    Related operations

    Operation

    Description

    SetDataShareInstance

    Enables or disables data sharing for an AnalyticDB for PostgreSQL instance.

    DescribeDataShareInstances

    Queries the state of data sharing for AnalyticDB for PostgreSQL instances.

    DescribeDataSharePerformance

    Queries the information about data sharing performance metrics.

    References

    For AnalyticDB for PostgreSQL instances in elastic storage mode, you can use the greenplum_fdw and gp_parallel_retrieve_cursor extensions to query data across instances. For more information, see Query data across instances.