psql backward compatibility - Mailing list pgsql-general

From Stephen Haddock
Subject psql backward compatibility
Date
Msg-id CAAPwSkR12Hc1g9n+jqV3k9nCtavcPpL4KDLOrNYOajL316g9_w@mail.gmail.com
Whole thread Raw
Responses Re: psql backward compatibility  (Christophe Pettus <xof@thebuild.com>)
Re: psql backward compatibility  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: psql backward compatibility  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: psql backward compatibility  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: psql backward compatibility  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
List pgsql-general
Hello,

When upgrading an older version of postgres, version 8.4 for example, to a newer version such as 9.6, does the data have to be migrated immediately?

It looks like the recommended method is to dump the data, upgrade, initialize a new cluster, and then restore the dumped data into the newer version. My question is whether the data dump and restore must be done immediately. It appears that 9.6 is able to run against the older cluster (DB service starts, queries work, etc), and the data could be migrated days or weeks later. I don't know if that is asking for issues down the line though such as 9.6 corrupting the data due to incompatibilities between the two versions.

Thanks!

pgsql-general by date:

Previous
From: Snjezana Frketic
Date:
Subject: Re: How to select values in a JSON type of column?
Next
From: Adrian Klaver
Date:
Subject: Re: create type with %type or %rowtype