This topic describes the system accounts that are provided in an ApsaraDB RDS for PostgreSQL instance. In most cases, you do not need to consider the permissions and authorized operations of these system accounts.

Account Description
  • alicloud_rds_admin
  • pg*********
 The O&M account that is used to locally manage the RDS instance. For example, Alibaba Cloud engineers can use this account to initialize the RDS instance by running the initdb command, restart the RDS instance, or query the status of the RDS instance.
aurora The account that is used to remotely manage the RDS instance. The Alibaba Cloud management and control system can use this account to log on to and manage the RDS instance. For example, the system can create databases and accounts on the RDS instance, check the status of the RDS instance, or monitor the performance of the RDS instance.
replicator The account that is used to replicate data from the primary RDS instance to its secondary RDS instance. This account is available only in RDS High-availability Edition.
Note The IP addresses of the preceding system accounts are internal IP addresses. You can execute the SELECT usename, client_addr FROM pg_stat_activity; statement to view the current logon account and its IP address. Example:
SELECT usename, client_addr FROM pg_stat_activity;

      usename         client_addr
--------------------+----------------
                    |
 alicloud_rds_admin 
 replicator          172.21.XX.XX
 aurora              100.104.XX.XX
 aurora             
 aurora              100.104.XX.XX
 aurora              100.104.XX.XX