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(dot)klaver(at)aklaver(dot)com>
> Date: 8/3/22 1:57 PM (GMT-05:00)
> To: zaphod61 <zaphod61(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)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(dot)klaver(at)aklaver(dot)com

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com