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.
||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.|
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