By default, the following system accounts are created in your PolarDB for PostgreSQL databases. In most cases, you do not need to manage the permissions and operations of the system accounts.
Account | Description |
polardb_admin | A superuser and the local administrator. The account is used by Alibaba Cloud engineers to perform O&M operations in the background. |
aurora | A superuser for control and O&M. The account is used to create databases and users, check the status of clusters, and monitor the performance of clusters. |
replicator | A superuser that manages the primary/secondary replication. The account is used to synchronize data between primary, read-only, and disaster recovery nodes. |
polar_gawr_admin, polar_gawr_user | The Automatic Workload Repository (AWR) report role that is used to only generate AWR reports. You cannot log on to the account. |
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 accounts and the IP addresses of the accounts. Sample statement:
SELECT usename, client_addr FROM pg_stat_activity;
usename | client_addr
--------------------+----------------
polardb_admin |
aurora | 100.104.XX.XX
aurora |
aurora | 100.104.XX.XX
aurora | 100.104.XX.XX