Locked out of RDS Postgresql 17 . How to recover
0
am locked out of postgresql 17 because of a bug in login trigggerfunction code. How to recover from it. Even superuser cannot log in.
- Topics
- Database
- Language
- English
asked a year ago221 views
3 Answers
- Newest
- Most votes
- Most comments
2
Hi, can you try to reset the superuser password from the RDS console and see if you can log in to the database? https://repost.aws/knowledge-center/reset-master-user-password-rds
1
I would recommend opening a support case for assistance. You can do this via the Resources > AWS Support Center link at the top of re:Post.
1
You can try a couple of things
- If you have backups enabled, you can rollback to a previous version of the backup. However, this also means you might lose data.
- Alternatively, you can try updating the login method to IAM user/role and then login with the IAM user. I'm not sure, if the login trigger will get bypassed when login with IAM.
