System accounts
PolarDB for PostgreSQL creates the following system accounts by default. These accounts are reserved for platform Operations and Maintenance (O&M) — in most cases, you do not need to manage their permissions or interact with them directly.
| Account | Description |
|---|---|
polardb_admin | Superuser and local administrator. Used by Alibaba Cloud engineers for background O&M operations. |
aurora | Superuser for control and O&M. Used to create databases and users, check cluster status, and monitor cluster performance. |
replicator | Superuser for replication management. Used to synchronize data between primary, read-only, and disaster recovery nodes. |
polar_gawr_admin, polar_gawr_user | Automatic Workload Repository (AWR) report roles. Used only to generate AWR reports. These accounts cannot log in. |
Note
The IP addresses of these system accounts are internal IP addresses. To view active accounts and their IP addresses, run:
SELECT usename, client_addr FROM pg_stat_activity;Sample output:
usename | client_addr
--------------------+----------------
polardb_admin |
aurora | 100.104.XX.XX
aurora |
aurora | 100.104.XX.XX
aurora | 100.104.XX.XX