On Mon, 2 Jun 2025 17:18:06 -0700 "Dan Mahoney (Ports)" <[email protected]> wrote:
> > On May 20, 2025, at 02:30, Dan Mahoney (Ports) <[email protected]> > > wrote: > > > > > > > >> On May 19, 2025, at 22:47, Mathieu Arnold <[email protected]> wrote: > >> > > > >> Well, you have three choices : > >> > >> - Upgrade your PostgreSQL server. Using packages means you upgrade > >> everything all the time. > >> - Build your own packages with the default PostgreSQL set to 15. > >> - Do not upgrade. > >> > >> The FreeBSD packages system, and ports, is a "rolling release", > >> you have to move with the flow. Hi Dan, We're in a similar situation as you are. We're tracking an older version of PostgreSQL. > > Then what is the purpose of having four older (and still supported) > versions of Posgresql client/server in pkg at all? > Major version upgrades of PostgreSQL are not always trivial. So the purpose of having multiple versions of PostgreSQL in the ports tree is that you can track those and stay on your current major version while still receiving security updates. Such a setup works well with project provided packages as long as you run your postgresql server on a separate host or in a separate jail, as client libraries are backwards compatible. If you want to keep running the server and the client on the same host and stay on an older version of postgresql, you'll have to build packages yourself. Cheers Michael -- Michael Gmelin
