Upgrading from 12.3 to 12.11

2022-08-03 Thread zaphod61
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 1211 and run that to upgrade the product and still 
maintain access to the existing connections?Sent from my Verizon, Samsung 
Galaxy smartphone

Re: Upgrading from 12.3 to 12.11

2022-08-03 Thread zaphod61
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 Sent from my Verizon, Samsung 
Galaxy smartphone
 Original message From: Adrian Klaver 
 Date: 8/3/22  1:57 PM  (GMT-05:00) To: zaphod61 
, 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 klaveradrian.kla...@aklaver.com

Re: Upgrading from 12.3 to 12.11

2022-08-03 Thread zaphod61
I am pretty sure it was a free version of the install, however, I will check 
the version tomorrow when I am back in the office.Thanks!Sent from my Verizon, 
Samsung Galaxy smartphone
 Original message From: Adrian Klaver 
 Date: 8/3/22  2:51 PM  (GMT-05:00) To: zaphod61 
, pgsql-general@lists.postgresql.org Subject: 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 applicationYou 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 > Date: 8/3/22 1:57 PM 
(GMT-05:00)> To: zaphod61 , 
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.kla...@aklaver.com-- Adrian klaveradrian.kla...@aklaver.com