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 1e87c671-08f3-cabc-0d0b-3c463dbfb657@aklaver.com
Whole thread Raw
In response to 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 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



pgsql-general by date:

Previous
From: Christophe Pettus
Date:
Subject: Re: Upgrading from 12.3 to 12.11
Next
From: zaphod61
Date:
Subject: Re: Upgrading from 12.3 to 12.11