On 18/1/19 5:30 μ.μ., Gary Stainburn wrote:
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?
That should work as well. The other way around is impossible.
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
