Hi Team,

Hope you guys are doing good.

We are facing below issue with read replica we did work arounds by setting 
hot_standby_feedback, max_standby_streaming_delay and 
max_standby_archive_delay, which indeed caused adverse effects on primary DB 
and storage. As our DB is nearly 6 TB which runs as AWS Postgres RDS.

Even the below error occurs on tables where vacuum is disabled and no DML 
operations are permitted. Will there be any chances to see row versions being 
changed even if vacuum is disabled.
Please advise.

2023-01-13 07:20:12 UTC:10.64.103.75(61096):ubpreplica@ubprdb01:[17707]:ERROR:  
canceling statement due to conflict with recovery
2023-01-13 07:20:12 UTC:10.64.103.75(61096):ubpreplica@ubprdb01:[17707]:DETAIL: 
 User query might have needed to see row versions that must be removed.

Thanks & Regards,
Abhishek P


Reply via email to