Search Postgresql Archives

Re: psql backward compatibility

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 11/18/20 8:05 AM, Stephen Haddock wrote:
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

Hmm, missed that. As David said that should not happen and if you are running a new binary against an old cluster then you will get corruption.

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!


--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux