Re: How to upgrade postgres version 8 to 13 - Mailing list pgsql-general

From shashidhar Reddy
Subject Re: How to upgrade postgres version 8 to 13
Date
Msg-id CAH=zU4vZTWG_O3ivhqTDFcfz-FObsfYQTxRNDi2qKVUGmiGVdg@mail.gmail.com
Whole thread Raw
In response to Re: How to upgrade postgres version 8 to 13  (Michael Nolan <htfoot@gmail.com>)
List pgsql-general
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.
--
Mike Nolan

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Seems to be impossible to set a NULL search_path
Next
From: Bryn Llewellyn
Date:
Subject: Re: Seems to be impossible to set a NULL search_path