sqlpostgresqlamazon-web-servicesamazon-rdsmajor-upgrade

RDS PostgreSQL major version upgrade issue

I have an RDS instance with PostgreSQL version 13.13. The goal is to upgrade it to version 15.5. During upgrade, I am getting an error

5342: GRANT "" TO "my_user_1" GRANTED BY "my_user_1";
5343: psql:/rdsdbdata/db/pg_upgrade_output.d/20240315T142926.905/dump/pg_upgrade_dump_globals.sql:186: ERROR:  zero-length delimited identifier at or near """"
5344: LINE 1: GRANT "" TO "my_user_1" GRANTED BY "my_user_1";

So anyone have an idea how to fix this?

Thank you

Solution

  • I am not sure how and why this happened, but somehow role with the empty name was created on my DB. Other copies of that DB didn't have that empty role. I was unable to delete that empty role because it was empty. I also was unable to modify it. In general update from 13.13 to 15.5 is happening very with no problems.