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