Thank you all for the inputs, any one tried upgrading from 8.2 to 8.4 and then used pg_upgrade to upgrade it to any higher version.
On Wed, 6 Jul, 2022, 12:01 am Michael Nolan, <htfoot@gmail.com> wrote:
I had a client that was stuck on 8.2 for a long time, when they finally upgraded to 10, it took several weeks of testing to find things that needed to be changed in scripts, functions and PHP programs. And even then we were still finding type cast issues for another year in seldom-used SQL code.
You need to do your advance work on this conversion.