Re: Upgrading from 12.3 to 12.11 - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Upgrading from 12.3 to 12.11
Date
Msg-id 26ffcd70-84a2-1dfd-0417-1bd227531e12@aklaver.com
Whole thread Raw
In response to Re: Upgrading from 12.3 to 12.11  (zaphod61 <zaphod61@gmail.com>)
Responses Re: Upgrading from 12.3 to 12.11
List pgsql-general
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



pgsql-general by date:

Previous
From: zaphod61
Date:
Subject: Re: Upgrading from 12.3 to 12.11
Next
From: Poornima Venkatesan
Date:
Subject: Re: BUG #17567: Unable to Set Max_Connection in Postgresql which has replicas