Thanks very much @danbjoseph , the post is rich and helped. I found out my major limitation was because I had not read upgrade notes on all versions between 1.5 and the latest which I am fetching; the notes are completely elaborate.
I however have another error on PostgreSQL 14 database; I've checked another forum post more related to it where am reporting it for additional support.