On Friday 18 January 2019 15:18:45 Achilleas Mantzios wrote: > On 18/1/19 5:08 μ.μ., Gary Stainburn wrote: > > If I were to go to 10.x on Centos 7, would I be able to install it > > alongside the existing 9.6 to test it? I have noticed with the 9.6 > > install that it's now using the version number as part of the data path. > > 9.6 is not page level compatible with e.g. 9.5 whereas 10.6 is with 10.5. > So in the versioning scheme PostreSQL community just dropped one dot. > Before (<=9*) it was x.y.z with all x.y.* being compatible whereas now > (>=10*) it is x.y with all x.* being compatible. By compatible we mean that > no pg_dump/restore or pg_upgrade is needed, just recompile and install. I have installed 10.6, configured it and imported the data all without issue. So far, so good. I have done the import using the pg_dumpall done on the 8.3 system. From the comments earlier, would I be better off doing a pg_dumpall of the 8.3 system using the binarys from the 10.6 system?
