This topic describes how to create a database link from PolarDB for Oracle to a user-created PostgreSQL database hosted on an Elastic Compute Service (ECS) instance.
For more information about how to create a database link from a PolarDB for Oracle cluster to a PolarDB for Oracle cluster, see Create a database link from PolarDB for Oracle to PolarDB for Oracle.
Prerequisites
- The PolarDB for Oracle cluster and the user-created PostgreSQL database hosted on ECS belong to the same Alibaba Cloud account.
- The ECS instance is deployed in a virtual private cloud (VPC).
- The kernel version of the PolarDB for Oracle cluster is the latest kernel version. For information about how to upgrade the kernel version, see Upgrade the minor version.
- Submit a ticket to apply for creating database links from PolarDB for Oracle clusters to user-created PostgreSQL databases hosted on ECS in the console.
Note You can call the CreateDBLink operation to create a database link from a PolarDB for Oracle cluster to a user-created PostgreSQL database. This way, you do not need to submit a ticket.
Notes
You can create a maximum of 10 database links for each PolarDB for Oracle cluster. Each database link consumes one database link quota of both the source cluster and the destination cluster.
Procedure
Related operations
API | Description |
---|---|
CreateDBLink | Creates a database link for a PolarDB for Oracle cluster. |
DescribeDBLinks | Queries the database link information of a PolarDB for Oracle cluster. |