This topic describes the limits of RDS for PostgreSQL. To guarantee stability and security, you must note the limits when using RDS for PostgreSQL instances.
The following table describes the limits of RDS for PostgreSQL.
|Modify database parameter settings||Currently it is not supported.|
|Database root permission||RDS does not offer the superuser permission.|
|Database backup||Data backup can only be performed through pg_dump.|
|Data migration||Data backed up through pg_dump can only be restored through psql.|
|Build database replication||
The system automatically builds the HA mode based on PostgreSQL stream replication.
The PostgreSQL standby node is invisible and cannot be accessed directly.
|Restart the RDS instance||The instance must be restarted through the RDS console or OpenAPI.|
|Network setting||If the access mode of the instance is safe connection mode, enabling net.ipv4.tcp_timestamps in SNAT mode is not allowed.|