On Fri, Jan 26, 2018 at 11:35:09AM -0700, David G. Johnston wrote: > On Friday, January 26, 2018, Jim Ryan <j...@room118solutions.com> wrote: > > Hey Bruce, > > Thanks for working on this, but wouldn't pg_upgrade be needed from 10.1 to > 10.2? Aren't those considered major versions, or am I misunderstanding? > > The source of my (and potentially others) confusion is if from 9.1 to 9.2 > is considered a major version change or not. I think most users would > assume from 9.x to 10.x is a major version change. The ambiguity is in > 9.x > to 9.y. > > > > Which is why we changed ;) > > Starting with 10 the one and only value after the decimal is a minor version > bug fix release. The next major version will be 11. > > Of versions beginning with 9 there were 7 major versions - 9.0 to 9.6; the > third position value denoted the minor bug fix release. > > pg-upgrade is only required for upgrading between major versions. > > On our homeoage we list every major release that is currently supported.
I decided I needed to be more explicit about the major version numbers so I have added major and minor examples for the 9.6.x series and 10.x series releases. Patch attached. -- Bruce Momjian <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + As you are, so once was I. As I am, so you will be. + + Ancient Roman grave inscription +
diff --git a/doc/src/sgml/ref/pgupgrade.sgml b/doc/src/sgml/ref/pgupgrade.sgml new file mode 100644 index 055eac3..cf4550b *** a/doc/src/sgml/ref/pgupgrade.sgml --- b/doc/src/sgml/ref/pgupgrade.sgml *************** *** 38,46 **** <application>pg_upgrade</application> (formerly called <application>pg_migrator</application>) allows data stored in <productname>PostgreSQL</productname> data files to be upgraded to a later <productname>PostgreSQL</productname> major version without the data dump/reload typically required for ! major version upgrades, e.g. from 9.6.3 to the current major release ! of <productname>PostgreSQL</productname>. It is not required for minor version upgrades, e.g. from ! 9.6.2 to 9.6.3. </para> <para> --- 38,46 ---- <application>pg_upgrade</application> (formerly called <application>pg_migrator</application>) allows data stored in <productname>PostgreSQL</productname> data files to be upgraded to a later <productname>PostgreSQL</productname> major version without the data dump/reload typically required for ! major version upgrades, e.g. from 9.5.8 to 9.6.4 or from 10.7 to 11.2. ! It is not required for minor version upgrades, e.g. from 9.6.2 to 9.6.3 ! or from 10.1 to 10.2. </para> <para>