AWS AmazonRDS documentation change
Summary
Updated PostgreSQL replication limitations for blue/green deployments, including guidance on primary keys and REPLICA IDENTITY FULL.
Security assessment
Changes address replication configuration best practices without mentioning security vulnerabilities or features.
Diff
diff --git a/AmazonRDS/latest/UserGuide/blue-green-deployments-considerations.md b/AmazonRDS/latest/UserGuide/blue-green-deployments-considerations.md index 16348ab35..b547ab520 100644 --- a//AmazonRDS/latest/UserGuide/blue-green-deployments-considerations.md +++ b//AmazonRDS/latest/UserGuide/blue-green-deployments-considerations.md @@ -131 +131 @@ PostgreSQL has certain restrictions related to logical replication, which transl -The following table describes logical replication limitations that apply to blue/green deployments for RDS for PostgreSQL. +The following table describes logical replication limitations that apply to blue/green deployments for RDS for PostgreSQL. For more information, see [Restrictions](https://www.postgresql.org/docs/current/logical-replication-restrictions.html) in the PostgreSQL logical replication documentation. @@ -139,3 +139 @@ Materialized views aren’t automatically refreshed in the green environment. | -UPDATE and DELETE operations aren't permitted on tables that don't have a primary key. | Before you create a blue/green deployment, make sure that all tables in the DB instance have a primary key. - -For more information, see [Restrictions](https://www.postgresql.org/docs/current/logical-replication-restrictions.html) in the PostgreSQL logical replication documentation. +UPDATE and DELETE operations aren't permitted on tables that don't have a primary key. | Before you create a blue/green deployment, make sure that all tables have a primary key or use `REPLICA IDENTITY FULL`. However, only use `REPLICA IDENTITY FULL` if no primary or unique key exists, as it affects replication performance. For more information, see the [PostgreSQL documentation](https://www.postgresql.org/docs/current/logical-replication-restrictions.html).