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 <adrian.klaver@xxxxxxxxxxx> Date: 8/3/22 2:51 PM (GMT-05:00) To: zaphod61 <zaphod61@xxxxxxxxx>, pgsql-general@xxxxxxxxxxxxxxxxxxxx Subject: Re: Upgrading from 12.3 to 12.11 > 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@xxxxxxxxxxx> > Date: 8/3/22 1:57 PM (GMT-05:00) > To: zaphod61 <zaphod61@xxxxxxxxx>, pgsql-general@xxxxxxxxxxxxxxxxxxxx > 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@xxxxxxxxxxx -- Adrian Klaver adrian.klaver@xxxxxxxxxxx |
