Hello Experts, It's postgres aurora version 16. While running the ALTER command on any object we see an error "*Only RowExclusiveLock or less can be acquired on database objects during recovery*". If I run any DML it gives an error stating '*cannot execute UPDATE in a read-only transaction*' , then I tried setting "*set transaction read-write*" and it erroring out with "*cannot set transaction read-write mode during recovery*".
Want to understand , what is the cause of this error and how to fix this? Regards Yudhi
