max_wal_senders invalid setting

Question

Hi guys,   
  
We have a single Postgresql 10 rds instance replicating to another instance and haven't changed any default parameters  
We had a brief outage on Sunday, looking at the event logs on the main server we see the following:  
  
Sun, 10 Mar 2019 13:11:11 GMT   Recovery of the DB instance has started. Recovery time will vary with the amount of data to be recovered.  
Sun, 10 Mar 2019 13:15:27 GMT   The parameter max_wal_senders was set to a value incompatible with replication. It has been adjusted from 10 to 15.  
Sun, 10 Mar 2019 13:16:01 GMT   Recovery of the DB instance is complete.  
Sun, 10 Mar 2019 13:16:28 GMT   The parameter max_wal_senders was set to a value incompatible with replication. It has been adjusted from 10 to 15.  
Sun, 10 Mar 2019 13:16:31 GMT   DB instance restarted  
  
I'm not entirely sure from this what the cause of the outage was... looking at the default parameters our max_wal_senders is set to 10 still  
  
Does anyone have any ideas how a) i can work out what happened? and b) if 10 is actually a valid value for that setting?  
  
thanks!  
  
Dan

Answer

ok, thanks for that

Answer

Message: "The parameter max_wal_senders was set to a value incompatible with replication. It has been adjusted from 10 to 15.","  
  
Please be assured the above message is a known message when an RDS instance is restarted, this event is harmless and has no performance impact on the instance. Kindly note that the internal team is aware of this event occurrence and is working on rolling out a fix.   
Hence, currently, there is no requirement of setting up the above parameter and you can safely ignore this Warning message until the internal team rolls out a fix at the backend.   
  
Unfortunately, I do not have a valid ETA for when the fix will be rolled out by internal team, however please be assured that this message is harmless and it's level is "Warning" and no action is required from your end.

max_wal_senders invalid setting

相關內容