Re: Upgrading from 11 to 13

On 3/30/21 10:51 AM, Ron wrote:
> On 3/30/21 9:53 AM, Daniel Westermann (DWE) wrote:
>>> On Tue, Mar 30, 2021 at 04:34:34PM +0200, Guillaume Lelarge wrote:
>>>> Hi,
>>>>
>>>> Le mar. 30 mars 2021 à 16:10, Susan Joseph <sandajoseph(at)verizon(dot)net>
>>>> a écrit :
>>>>
>>>>       I am currently using PostgreSQL 11.2 and would like to try and
>>>> upgrade it
>>>>       to the latest version 13.  Can I go straight from 11 to 13 or
>>>> do I need to
>>>>       upgrade to 12 first and then to 13?
>>>>
>>>>
>>>> You can go straight to 13.
>>> We get this question often.  Why do people feel they need to upgrade to
>>> intermediate releases?  If we knew, maybe we could better clarify this.
>> I believe this is coming from the Oracle world. You can, e.g.not
>> directly go from 9 to18. There are supported upgrade paths and you
>> need to stick to those, but they are documented.
>
> Not even Postgresql allows you to jump from ancient versions to the most
> modern version.  (No competent system makes you upgrade to the very next
> major version...)
>

pg_dump version 10+ will dump versions back to 8.0. pg_dump 9.6 reaches
back to version 7.0. So it is possible to upgrade from old versions in
one leap, whether it is advisable is another question.

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com