PostgreSQL data source

Background information

RDS PostgreSQL instances support privileged accounts and standard accounts. When you use Data Transmission Service to migrate or synchronize data from an RDS PostgreSQL instance, you must use a privileged account.

The account that you create in this topic is used for the Username field of your PostgreSQL data source.

Create a privileged RDS PostgreSQL instance user

1. Go to the Account Management page.

   1. Log on to the ApsaraDB RDS console.

   2. In the upper-left corner of the Instances page, select the region where the target instance is located and click the ID of the target instance.

   3. On the product page of the target instance, click Account Management in the navigation pane on the left.

2. On the Account Management page, click Create Account.

   

3. In the Create Account dialog box, configure the parameters.

   

   Parameter	Description
   Database Account	The database account name must be no more than 63 characters in length. It can contain letters, digits, and underscores (_). It must start and end with a letter or a digit. The name cannot start with pg or be a reserved keyword.
   Account Type	Select Privileged Account. Note A privileged account has SELECT, INSERT, UPDATE, DELETE, TRUNCATE, REFERENCES, and TRIGGER permissions on all databases.
   New Password	The password must be 8 to 32 characters long. It must contain characters from at least three of the following categories: uppercase letters, lowercase letters, digits, and special characters (`!@#$%^&*()_+-=`).
   Confirm Password	Enter the password again.
   Remarks	Enter remarks for the account. The remarks must be 2 to 256 characters in length.

4. Click OK.

References

Create a PostgreSQL data source

Migrate data from an RDS PostgreSQL instance to an Oracle tenant of OceanBase Database

Synchronize data from an RDS PostgreSQL instance to an Oracle tenant of OceanBase Database