On Thu, Jan 9, 2025 at 11:42 AM yudhi s <learnerdatabas...@gmail.com> wrote:
> 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? > The cause of the error is that the instance is in recovery mode, just like the error message says. Is your system a cluster? -- Death to <Redacted>, and butter sauce. Don't boil me, I'm still alive. <Redacted> lobster!
