Yes, I suppose there is no easy solution but it might help to upgrade old versions (but it depends of every customer).
Ideally, I think the best approach would be abort the upgrade based in:
1. Some error (catching error from psql)
2. Some checking (versions or some audits as table approach you've mentioned)
I don't, only some ideas. Any way, perhaps I'm the only one with this problem and it doesn't worth 😊
