Upgrading from 11 to 13

Hi,

Le mar. 30 mars 2021 à 16:10, Susan Joseph <sandajoseph@verizon.net> a
écrit :

I am currently using PostgreSQL 11.2 and would like to try and upgrade it
to the latest version 13. Can I go straight from 11 to 13 or do I need to
upgrade to 12 first and then to 13?

You can go straight to 13.

Regards.

On Tue, Mar 30, 2021 at 04:34:34PM +0200, Guillaume Lelarge wrote:

Hi,

Le mar. 30 mars 2021 � 16:10, Susan Joseph <sandajoseph@verizon.net> a �crit�:

I am currently using PostgreSQL 11.2 and would like to try and upgrade it
to the latest version 13.� Can I go straight from 11 to 13 or do I need to
upgrade to 12 first and then to 13?

You can go straight to 13.

We get this question often. Why do people feel they need to upgrade to
intermediate releases? If we knew, maybe we could better clarify this.

--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com

If only the physical world exists, free will is an illusion.

On 3/30/21 7:09 AM, Susan Joseph wrote:

I am currently using PostgreSQL 11.2 and would like to try and upgrade
it to the latest version 13.  Can I go straight from 11 to 13 or do I
need to upgrade to 12 first and then to 13?

You can do this using either dump/restore or pg_upgrade. The important
part is to remember to use the new versions of the upgrade programs,
version 13 pg_dump to dump the 11 instance and version 13 of pg_restore
to restore or version 13 of pg_upgrade.

The other important thing is to read the release notes for version 12
and 13 to see if any of the changes may affect you.

Thanks,

Susan

--
Adrian Klaver
adrian.klaver@aklaver.com

On Tue, Mar 30, 2021 at 04:34:34PM +0200, Guillaume Lelarge wrote:

Hi,

Le mar. 30 mars 2021 à 16:10, Susan Joseph <sandajoseph@verizon.net> a écrit :

     I am currently using PostgreSQL 11.2 and would like to try and upgrade it
     to the latest version 13.  Can I go straight from 11 to 13 or do I need to
     upgrade to 12 first and then to 13?

You can go straight to 13.

We get this question often.  Why do people feel they need to upgrade to
intermediate releases?  If we knew, maybe we could better clarify this.

I believe this is coming from the Oracle world. You can, e.g.not directly go from 9 to18. There are supported upgrade paths and you need to stick to those, but they are documented.

Regards
Daniel

On Tue, Mar 30, 2021 at 02:53:10PM +0000, Daniel Westermann (DWE) wrote:

On Tue, Mar 30, 2021 at 04:34:34PM +0200, Guillaume Lelarge wrote:

Hi,

Le mar. 30 mars 2021 � 16:10, Susan Joseph <sandajoseph@verizon.net> a �crit�:

���� I am currently using PostgreSQL 11.2 and would like to try and upgrade it
���� to the latest version 13.� Can I go straight from 11 to 13 or do I need to
���� upgrade to 12 first and then to 13?

You can go straight to 13.

We get this question often.� Why do people feel they need to upgrade to
intermediate releases?� If we knew, maybe we could better clarify this.

I believe this is coming from the Oracle world. You can, e.g.not directly go from 9 to18. There are supported upgrade paths and you need to stick to those, but they are documented.

What other software needs to upgrade through all intermediate versions?

--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com

If only the physical world exists, free will is an illusion.

On 3/30/21 8:06 AM, Bruce Momjian wrote:

On Tue, Mar 30, 2021 at 02:53:10PM +0000, Daniel Westermann (DWE) wrote:

On Tue, Mar 30, 2021 at 04:34:34PM +0200, Guillaume Lelarge wrote:

Hi,

Le mar. 30 mars 2021 à 16:10, Susan Joseph <sandajoseph@verizon.net> a écrit :

     I am currently using PostgreSQL 11.2 and would like to try and upgrade it
     to the latest version 13.  Can I go straight from 11 to 13 or do I need to
     upgrade to 12 first and then to 13?

You can go straight to 13.

We get this question often.  Why do people feel they need to upgrade to
intermediate releases?  If we knew, maybe we could better clarify this.

I believe this is coming from the Oracle world. You can, e.g.not directly go from 9 to18. There are supported upgrade paths and you need to stick to those, but they are documented.

What other software needs to upgrade through all intermediate versions?

Many variations of OS'es, though not all. One of the benefits of Ubuntu
is that you can jump from x.LTS to y.LTS over intermediate versions.

--
Adrian Klaver
adrian.klaver@aklaver.com

On Tue, Mar 30, 2021 at 08:10:08AM -0700, Adrian Klaver wrote:

On 3/30/21 8:06 AM, Bruce Momjian wrote:

What other software needs to upgrade through all intermediate versions?

Many variations of OS'es, though not all. One of the benefits of Ubuntu is
that you can jump from x.LTS to y.LTS over intermediate versions.

Oh, yeah. Anyway, any idea of how to more clearly state users don't
need to upgrade to intermediate versions?

--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com

If only the physical world exists, free will is an illusion.

On Tue, Mar 30, 2021 at 08:10:08AM -0700, Adrian Klaver wrote:

On 3/30/21 8:06 AM, Bruce Momjian wrote:

What other software needs to upgrade through all intermediate versions?

Many variations of OS'es, though not all. One of the benefits of Ubuntu is
that you can jump from x.LTS to y.LTS over intermediate versions.

Oh, yeah.  Anyway, any idea of how to more clearly state users don't
need to upgrade to intermediate versions?

The best place would be the release notes, I guess. Right at the beginning here:

E.3.2. Migration to Version 13

A dump/restore using pg_dumpall or use of pg_upgrade or logical replication is required for those wishing to migrate data from any previous release. See Section 18.6 for general information on migrating to new major releases.

We could mention that pg_upgrade works across the supported major versions.

Regards
Daniel

On Tue, Mar 30, 2021 at 8:25 AM Daniel Westermann (DWE) <
daniel.westermann@dbi-services.com> wrote:

On Tue, Mar 30, 2021 at 08:10:08AM -0700, Adrian Klaver wrote:

On 3/30/21 8:06 AM, Bruce Momjian wrote:

What other software needs to upgrade through all intermediate

versions?

Many variations of OS'es, though not all. One of the benefits of Ubuntu

is

that you can jump from x.LTS to y.LTS over intermediate versions.

Oh, yeah. Anyway, any idea of how to more clearly state users don't
need to upgrade to intermediate versions?

The best place would be the release notes, I guess. Right at the beginning
here:

Release notes are probably a good place too but there is already a section
in the main documentation where this needs to be added.

https://www.postgresql.org/docs/current/upgrading.html

Which is linked to from the main website.

https://www.postgresql.org/support/versioning/

An explicit sentence stating that major upgrades can skip major versions is
needed. The document is written assuming the reading knows this, and just
makes a few minor notes on the topic:
e.g., "If you are upgrading across several major versions, be sure to read
the release notes for each intervening version."

David J.

On Tue, Mar 30, 2021 at 03:25:06PM +0000, Daniel Westermann (DWE) wrote:

On Tue, Mar 30, 2021 at 08:10:08AM -0700, Adrian Klaver wrote:

On 3/30/21 8:06 AM, Bruce Momjian wrote:

What other software needs to upgrade through all intermediate versions?

Many variations of OS'es, though not all. One of the benefits of Ubuntu is
that you can jump from x.LTS to y.LTS over intermediate versions.

Oh, yeah.� Anyway, any idea of how to more clearly state users don't
need to upgrade to intermediate versions?

The best place would be the release notes, I guess. Right at the beginning here:

E.3.2. Migration to Version 13

A dump/restore using pg_dumpall or use of pg_upgrade or logical replication is required for those wishing to migrate data from any previous release. See Section 18.6 for general information on migrating to new major releases.

We could mention that pg_upgrade works across the supported major versions.

Actually, I think all our upgrade methods allow skipping intermediate
releases, not just pg_upgrade.

--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com

If only the physical world exists, free will is an illusion.

On 3/30/21 9:53 AM, Daniel Westermann (DWE) wrote:

On Tue, Mar 30, 2021 at 04:34:34PM +0200, Guillaume Lelarge wrote:

Hi,

Le mar. 30 mars 2021 à 16:10, Susan Joseph <sandajoseph@verizon.net> a écrit :

     I am currently using PostgreSQL 11.2 and would like to try and upgrade it
     to the latest version 13.  Can I go straight from 11 to 13 or do I need to
     upgrade to 12 first and then to 13?

You can go straight to 13.

We get this question often.  Why do people feel they need to upgrade to
intermediate releases?  If we knew, maybe we could better clarify this.

I believe this is coming from the Oracle world. You can, e.g.not directly go from 9 to18. There are supported upgrade paths and you need to stick to those, but they are documented.

Not even Postgresql allows you to jump from ancient versions to the most
modern version.  (No competent system makes you upgrade to the very next
major version...)

--
Angular momentum makes the world go 'round.

On Tue, Mar 30, 2021 at 12:51:50PM -0500, Ron wrote:

On 3/30/21 9:53 AM, Daniel Westermann (DWE) wrote:

On Tue, Mar 30, 2021 at 04:34:34PM +0200, Guillaume Lelarge wrote:

Hi,

Le mar. 30 mars 2021 � 16:10, Susan Joseph <sandajoseph@verizon.net> a �crit�:

���� I am currently using PostgreSQL 11.2 and would like to try and upgrade it
���� to the latest version 13.� Can I go straight from 11 to 13 or do I need to
���� upgrade to 12 first and then to 13?

You can go straight to 13.

We get this question often.� Why do people feel they need to upgrade to
intermediate releases?� If we knew, maybe we could better clarify this.

I believe this is coming from the Oracle world. You can, e.g.not directly go from 9 to18. There are supported upgrade paths and you need to stick to those, but they are documented.

Not even Postgresql allows you to jump from ancient versions to the most
modern version.� (No competent system makes you upgrade to the very next
major version...)

Yes, sometimes you need to use an intermediate version, but those cases
are rare.

--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com

If only the physical world exists, free will is an illusion.

On 3/30/21 10:51 AM, Ron wrote:

On 3/30/21 9:53 AM, Daniel Westermann (DWE) wrote:

On Tue, Mar 30, 2021 at 04:34:34PM +0200, Guillaume Lelarge wrote:

Hi,

Le mar. 30 mars 2021 à 16:10, Susan Joseph <sandajoseph@verizon.net>
a écrit :

      I am currently using PostgreSQL 11.2 and would like to try and
upgrade it
      to the latest version 13.  Can I go straight from 11 to 13 or
do I need to
      upgrade to 12 first and then to 13?

You can go straight to 13.

We get this question often.  Why do people feel they need to upgrade to
intermediate releases?  If we knew, maybe we could better clarify this.

I believe this is coming from the Oracle world. You can, e.g.not
directly go from 9 to18. There are supported upgrade paths and you
need to stick to those, but they are documented.

Not even Postgresql allows you to jump from ancient versions to the most
modern version.  (No competent system makes you upgrade to the very next
major version...)

pg_dump version 10+ will dump versions back to 8.0. pg_dump 9.6 reaches
back to version 7.0. So it is possible to upgrade from old versions in
one leap, whether it is advisable is another question.

--
Adrian Klaver
adrian.klaver@aklaver.com

On Tue, Mar 30, 2021 at 08:30:00AM -0700, David G. Johnston wrote:

On Tue, Mar 30, 2021 at 8:25 AM Daniel Westermann (DWE) <
daniel.westermann@dbi-services.com> wrote:
The best place would be the release notes, I guess. Right at the beginning
here:

Release notes are probably a good place too but there is already a section in
the main documentation where this needs to be added.

https://www.postgresql.org/docs/current/upgrading.html

Which is linked to from the main website.

https://www.postgresql.org/support/versioning/

An explicit sentence stating that major upgrades can skip major versions is
needed.� The document is written assuming the reading knows this, and just
makes a few minor notes on the topic:
e.g., "If you are upgrading across several major versions, be sure to read the
release notes for each intervening version."

I have two patches --- one for our website, and another for our docs,
though not for the release notes specifically. The release notes do
reference this doc section though.

My idea was to link the ability to skip upgrading to intervening
versions with the need to read intervening version release notes.

--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com

If only the physical world exists, free will is an illusion.

On 4/1/21 6:06 PM, Bruce Momjian wrote:
An explicit sentence stating that major upgrades can skip major versions is

needed.  The document is written assuming the reading knows this, and just
makes a few minor notes on the topic:
e.g., "If you are upgrading across several major versions, be sure to read the
release notes for each intervening version."

I have two patches --- one for our website

Reviewed, made a couple of edits, and pushed to the website[1]https://www.postgresql.org/support/versioning/.

Jonathan

[1]: https://www.postgresql.org/support/versioning/

I seem to recall that going from 11 to 12, a certain configuration file was
removed and the keys are now expected to be set in the regular
configuration file? The logic being there should only ever be 1
configuration file.

I can't find it, but at the same time I don't recall what it's called. I
believe it has to do with streaming replication?

Is this a thing or am I imagining stuff?

On Fri, Apr 2, 2021 at 12:34 AM Bruce Momjian <bruce@momjian.us> wrote:

On 2021-Apr-02, Koen De Groote wrote:

I seem to recall that going from 11 to 12, a certain configuration file was
removed and the keys are now expected to be set in the regular
configuration file? The logic being there should only ever be 1
configuration file.

I can't find it, but at the same time I don't recall what it's called. I
believe it has to do with streaming replication?

Is this a thing or am I imagining stuff?

recovery.conf to postgresql.conf? Yes, you're right. (There are more
reasons beyond "just one config file", though.)

--
�lvaro Herrera 39�49'30"S 73�17'W
"Someone said that it is at least an order of magnitude more work to do
production software than a prototype. I think he is wrong by at least
an order of magnitude." (Brian Kernighan)

On Thu, Apr 1, 2021 at 07:26:14PM -0400, Jonathan Katz wrote:

On 4/1/21 6:06 PM, Bruce Momjian wrote:
An explicit sentence stating that major upgrades can skip major versions is

needed.� The document is written assuming the reading knows this, and just
makes a few minor notes on the topic:
e.g., "If you are upgrading across several major versions, be sure to read the
release notes for each intervening version."

I have two patches --- one for our website

Reviewed, made a couple of edits, and pushed to the website[1].

Jonathan

[1] https://www.postgresql.org/support/versioning/

Patch applied to the docs.

--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com

If only the physical world exists, free will is an illusion.

Here it is with descriptions:

Hepatitis A
Dates on file: 09/01/2005, 01/27/2005

IPV (Polio)
Dates on file: 09/01/2005

Influenza Vaccine Quadrivalent 3 Yr And Older
Dates on file: 08/25/2020, 10/19/2015

Influenza Vaccine Quadrivalent Preservative Free 6 Mons and Up
Dates on file: 08/25/2020, 11/26/2018

Influenza Vaccine Quadrivalent Preservative Free 6-35 Months
Dates on file: 10/30/2017, 10/26/2016, 10/07/2013

MMR (Measles, Mumps, and Rubella)
Dates on file: 06/27/2006

Td (Tetanus)
Dates on file: 01/27/2005

Tdap (diphtheria, pertussis, and tetanus)
Dates on file: 10/07/2013

Typhoid Live
Dates on file: 01/24/2017, 03/03/2011

Yellow Fever
Dates on file: 03/03/2011

Zoster Vaccine Recombinant Adjuvanted (Shingrix)
Dates on file: 10/31/2020, 08/25/2020

---------------------------------------------------------------------------

On Thu, Apr 1, 2021 at 09:18:07PM -0400, Bruce Momjian wrote:

On Thu, Apr 1, 2021 at 07:26:14PM -0400, Jonathan Katz wrote:

On 4/1/21 6:06 PM, Bruce Momjian wrote:
An explicit sentence stating that major upgrades can skip major versions is

needed.� The document is written assuming the reading knows this, and just
makes a few minor notes on the topic:
e.g., "If you are upgrading across several major versions, be sure to read the
release notes for each intervening version."

I have two patches --- one for our website

Reviewed, made a couple of edits, and pushed to the website[1].

Jonathan

[1] https://www.postgresql.org/support/versioning/

Patch applied to the docs.

--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com

If only the physical world exists, free will is an illusion.

--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com

If only the physical world exists, free will is an illusion.