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(dot)klaver(at)aklaver(dot)com> Date: 8/3/22 2:51 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 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 <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 Klaveradrian(dot)klaver(at)aklaver(dot)com