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