AWS AmazonRDS documentation change

Service: AmazonRDS · 2025-08-28 · Documentation low

File: AmazonRDS/latest/AuroraUserGuide/aurora-postgresql-unlogged-tables.md

Summary

Added section about handling unlogged tables during migration, including detection methods and conversion process

Security assessment

The change addresses data durability and replication considerations rather than security vulnerabilities. It focuses on ensuring data consistency during migrations but doesn't mention security risks or vulnerabilities.

Diff

diff --git a/AmazonRDS/latest/AuroraUserGuide/aurora-postgresql-unlogged-tables.md b/AmazonRDS/latest/AuroraUserGuide/aurora-postgresql-unlogged-tables.md
index 1942bb1f7..bcf98a61d 100644
--- a//AmazonRDS/latest/AuroraUserGuide/aurora-postgresql-unlogged-tables.md
+++ b//AmazonRDS/latest/AuroraUserGuide/aurora-postgresql-unlogged-tables.md
@@ -5 +5 @@
-Creating unlogged tablesConverting unlogged tables to logged tablesUnlogged tables and logical replication
+Creating unlogged tablesHandling unlogged tables during migrationConverting unlogged tables to logged tablesUnlogged tables and logical replication
@@ -39,0 +40,22 @@ To create an unlogged table in Aurora PostgreSQL, add the UNLOGGED keyword in yo
+## Handling unlogged tables during migration
+
+When preparing to migrate data to Aurora PostgreSQL, it's important to identify and handle unlogged tables appropriately. Unlogged tables are not WAL-logged and are excluded from the replication stream, meaning they will not be replicated to an Aurora read replica.
+
+Convert unlogged tables to logged tables or drop them if they are not being used before creating an Aurora read replica.
+
+To verify the presence of unlogged tables in each database within the instance, use the following command:
+    
+    
+    SELECT oid, relfilenode, relname, relpersistence, relkind 
+    FROM pg_class 
+    WHERE relpersistence ='u';
+        
+
+To convert an unlogged table back to a logged table, use the following command:
+    
+    
+    ALTER TABLE table_name SET LOGGED;
+        
+
+This operation rewrites the entire table and places an exclusive lock on it until completion. For large tables, this may result in significant downtime.
+