Aurora postgres grant permission to pg_attribute
Only a superuser can do that, and you probably won't get a superuser in a hosted database.

You will have to drop the history tables and re-create them new as inheritance children (without specifying the duplicate columns!).