Re: Upgrading from 12.3 to 12.11

On 8/3/22 11:44 AM, zaphod61 wrote:
> The server version is 2016. The installer is the one listed on the
> postgresql support page.  I think version 12.3 was installed the same
> way but that was before I came into contact with this application

You need to make sure, mixing installation methods can cause a mess.

Also how much downtime can you tolerate?

>
>
>
>
>
> Sent from my Verizon, Samsung Galaxy smartphone
>
>
> -------- Original message --------
> From: Adrian Klaver <adrian.klaver@aklaver.com>
> Date: 8/3/22 1:57 PM (GMT-05:00)
> To: zaphod61 <zaphod61@gmail.com>, pgsql-general@lists.postgresql.org
> Subject: Re: Upgrading from 12.3 to 12.11
>
> On 8/3/22 10:16 AM, zaphod61 wrote:
>  >
>  > I've inherited a postgresql 12.3 installation. It has 1 database in it.
>  > I need to upgrade it to the newest version, which appears to be 12.11.
>  > Can I just download the installer for 12
>  > 11 and run that to upgrade the product and still maintain access to the
>  > existing connections?
>
> What OS are you using?
>
> How was the Postgres 12.3 instance installed?
>
> What installer are you referring to?
>
>
> 12.3 -> 12.11 is a minor upgrade so you can do the update without a
> dump/restore or using pg_upgrade. That being said, at some point in the
> process the existing instance(12.3) will need to be stopped and then the
> new install for the 12.11 done and then start it. That means there will
>    be point where the connections will be lost.  How big an issue would
> that be?
>
>
>  >
>  >
>  >
>  >
>  > Sent from my Verizon, Samsung Galaxy smartphone
>  >
>
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com


--
Adrian Klaver
adrian.klaver@aklaver.com