Delay of hours between blue and green on PostgreSQL RDS Blue/Green Deployment

0

We set up a blue/green deployment for our production PostgreSQL RDS during off-peak hours. However, shortly after the creation was completed, I noticed that the data in the Green environment was significantly behind the data in the Blue environment for a specific database, almost 2 hours behind when checking the record dates. This delay was increasing over time. We observed the WALDiskUsage metric gradually increasing, indicating that it was indeed accumulating WAL logs, but it wasn't anywhere near the limit we set (max_slot_wal_keep_size=100GB). The column "wal_status" in the "pg_replication_slots" table of this database indicated the value "extended," and the "wait_event" column in the "pg_stat_activity" table of the replication connection for this database indicated the value "WalSenderWriteData."

Does anyone know why this hours-long delay is happening? I found it very strange that the data is so many hours behind. I wanted to know if this is normal or if I need to adjust some logical replication parameter in PostgreSQL.

I appreciate any comments or suggestions on how to fix this.

Glaucia
已提问 1 个月前94 查看次数
没有答案

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则