Re: Upgrading from 11 to 13

2021-04-03 Thread Adrian Klaver
On 4/3/21 12:47 PM, Koen De Groote wrote: If an upgrade process has a part where old functionality doesn't work anymore, or anything at all breaks, then it's not "you can just upgrade no problems". Major versions are allowed to break compatibility, so there is always a chance for issues. Th

Re: Upgrading from 11 to 13

2021-04-03 Thread Bruce Momjian
On Sat, Apr 3, 2021 at 09:47:10PM +0200, Koen De Groote wrote: > If an upgrade process has a part where old functionality doesn't work anymore, > or anything at all breaks, then it's not "you can just upgrade no problems". Well, stopping at every major release between major releases dosen't help

Re: Upgrading from 11 to 13

2021-04-03 Thread Koen De Groote
If an upgrade process has a part where old functionality doesn't work anymore, or anything at all breaks, then it's not "you can just upgrade no problems". On Sat, Apr 3, 2021 at 8:50 PM Adrian Klaver wrote: > On 4/3/21 10:37 AM, Koen De Groote wrote: > > Yes that's it. Probably something to ale

Re: Upgrading from 11 to 13

2021-04-03 Thread Peter J. Holzer
On 2021-04-01 21:56:17 -0400, Bruce Momjian wrote: > On Thu, Apr 1, 2021 at 09:55:28PM -0400, Bruce Momjian wrote: > > Here it is with descriptions: > > Sorry, please ignore. Too late. Now we all know the code names for previous PostgreSQL releases. hp -- _ | Peter J. Holzer|

Re: Upgrading from 11 to 13

2021-04-03 Thread Adrian Klaver
On 4/3/21 10:37 AM, Koen De Groote wrote: Yes that's it. Probably something to alert people to. If they have this set up, they can't "just to straight to 13". Yes you can. You run into the same issue going from 11 --> 12 --> 13, you would just hit it in a different portion of the process.

Re: Upgrading from 11 to 13

2021-04-03 Thread Koen De Groote
Yes that's it. Probably something to alert people to. If they have this set up, they can't "just to straight to 13". On Fri, Apr 2, 2021 at 1:32 AM Alvaro Herrera wrote: > On 2021-Apr-02, Koen De Groote wrote: > > > I seem to recall that going from 11 to 12, a certain configuration file > was >

Re: Upgrading from 11 to 13

2021-04-01 Thread Bruce Momjian
On Thu, Apr 1, 2021 at 09:55:28PM -0400, Bruce Momjian wrote: > > Here it is with descriptions: Sorry, please ignore. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com If only the physical world exists, free will is an illusio

Re: Upgrading from 11 to 13

2021-04-01 Thread Bruce Momjian
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 V

Re: Upgrading from 11 to 13

2021-04-01 Thread Bruce Momjian
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

Re: Upgrading from 11 to 13

2021-04-01 Thread Alvaro Herrera
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

Re: Upgrading from 11 to 13

2021-04-01 Thread Koen De Groote
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 be

Re: Upgrading from 11 to 13

2021-04-01 Thread Jonathan S. Katz
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

Re: Upgrading from 11 to 13

2021-04-01 Thread Bruce Momjian
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.westerm...@dbi-services.com> wrote: > The best place would be the release notes, I guess. Right at the beginning > here: > > Release notes are probably a

Re: Upgrading from 11 to 13

2021-03-30 Thread Adrian Klaver
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 a écrit :   I am currently using PostgreSQL 11.2 and would like to try and upgrade it   

Re: Upgrading from 11 to 13

2021-03-30 Thread Bruce Momjian
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 a > > > > écrit : > > > > > > > > I am

Re: Upgrading from 11 to 13

2021-03-30 Thread Ron
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 a écrit : I am currently using PostgreSQL 11.2 and would like to try and upgrade it to the latest version 13.  Can I

Re: Upgrading from 11 to 13

2021-03-30 Thread Bruce Momjian
On Tue, Mar 30, 2021 at 03:25:06PM +, 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

Re: Upgrading from 11 to 13

2021-03-30 Thread David G. Johnston
On Tue, Mar 30, 2021 at 8:25 AM Daniel Westermann (DWE) < daniel.westerm...@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? > >>

Re: Upgrading from 11 to 13

2021-03-30 Thread Daniel Westermann (DWE)
>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

Re: Upgrading from 11 to 13

2021-03-30 Thread Bruce Momjian
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.L

Re: Upgrading from 11 to 13

2021-03-30 Thread Adrian Klaver
On 3/30/21 8:06 AM, Bruce Momjian wrote: On Tue, Mar 30, 2021 at 02:53:10PM +, 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 a écrit : I am currently using PostgreSQL 11.2 and would

Re: Upgrading from 11 to 13

2021-03-30 Thread Bruce Momjian
On Tue, Mar 30, 2021 at 02:53:10PM +, 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 a > >> écrit : > >> > >> I am currently using PostgreSQL 11.2 and would like to try

Re: Upgrading from 11 to 13

2021-03-30 Thread Daniel Westermann (DWE)
>On Tue, Mar 30, 2021 at 04:34:34PM +0200, Guillaume Lelarge wrote: >> Hi, >> >> Le mar. 30 mars 2021 à 16:10, Susan Joseph 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

Re: Upgrading from 11 to 13

2021-03-30 Thread Adrian Klaver
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 importan

Re: Upgrading from 11 to 13

2021-03-30 Thread Bruce Momjian
On Tue, Mar 30, 2021 at 04:34:34PM +0200, Guillaume Lelarge wrote: > Hi, > > Le mar. 30 mars 2021 à 16:10, Susan Joseph 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 >

Re: Upgrading from 11 to 13

2021-03-30 Thread Guillaume Lelarge
Hi, Le mar. 30 mars 2021 à 16:10, Susan Joseph 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.