From nobody Wed Jul 10 16:59:05 2024 X-Original-To: questions@mlmmj.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mlmmj.nyi.freebsd.org (Postfix) with ESMTP id 4WK3x45Ss5z5Qnb7 for ; Wed, 10 Jul 2024 16:59:20 +0000 (UTC) (envelope-from paul@gromit.dlib.vt.edu) Received: from gromit.dlib.vt.edu (gromit.dlib.vt.edu [128.173.126.123]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256) (Client did not present a certificate) by mx1.freebsd.org (Postfix) with ESMTPS id 4WK3x43MjVz4mDH for ; Wed, 10 Jul 2024 16:59:20 +0000 (UTC) (envelope-from paul@gromit.dlib.vt.edu) Authentication-Results: mx1.freebsd.org; none Received: from smtpclient.apple (unknown [IPv6:2601:5cf:407e:55c1::5]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by gromit.dlib.vt.edu (Postfix) with ESMTPSA id B34AB22A87; Wed, 10 Jul 2024 12:59:16 -0400 (EDT) Content-Type: text/plain; charset=utf-8 List-Id: User questions List-Archive: https://lists.freebsd.org/archives/freebsd-questions List-Help: List-Post: List-Subscribe: List-Unsubscribe: X-BeenThere: freebsd-questions@freebsd.org Sender: owner-freebsd-questions@FreeBSD.org Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3774.600.62\)) Subject: Re: Setting default version in Poudriere From: Paul Mather In-Reply-To: <1CcA1gzWSQjmaV5-UXsm-1GjQkyJu_cNIACuG2SJ4-cDsYsytEWlePiTcwPK_tM05-NBDNSqKy42HtnIcI2qUlGagbCzJ2_xWpz02uwQT0k=@protonmail.com> Date: Wed, 10 Jul 2024 12:59:05 -0400 Cc: "questions@freebsd.org" Content-Transfer-Encoding: quoted-printable Message-Id: <6FDCCD1A-AABE-489A-AB05-91B08316B432@gromit.dlib.vt.edu> References: <2a09efe671bc45d93f84ff69269e4388@smokepit.net> <1CcA1gzWSQjmaV5-UXsm-1GjQkyJu_cNIACuG2SJ4-cDsYsytEWlePiTcwPK_tM05-NBDNSqKy42HtnIcI2qUlGagbCzJ2_xWpz02uwQT0k=@protonmail.com> To: Pat X-Mailer: Apple Mail (2.3774.600.62) X-Spamd-Bar: ---- X-Rspamd-Pre-Result: action=no action; module=replies; Message is reply to one we originated X-Spamd-Result: default: False [-4.00 / 15.00]; REPLY(-4.00)[]; ASN(0.00)[asn:1312, ipnet:128.173.0.0/16, country:US] X-Rspamd-Queue-Id: 4WK3x43MjVz4mDH On Jul 10, 2024, at 12:39=E2=80=AFPM, Pat = wrote: > On Monday, July 8th, 2024 at 13:01, Matthew Seaman = wrote: >=20 >>=20 >>=20 >> On 08/07/2024 13:24, Pat wrote: >>=20 >>> On Friday, July 5th, 2024 at 21:14, Daniel Lysfjord = lysfjord.daniel@smokepit.net wrote: >>>=20 >>>> I would suggest just creating a port for postgres 15.6 in addition = to >>>> the 15.7 that's already in the ports tree >>>=20 >>> Thank you Daniel. That makes sense, but I do not know how to create = a >>> port. Can you point me to any documentation that would explain what = I >>> am missing? And apologies if there is something obvious that I >>> missed. >>=20 >>=20 >> In this case, all you need to do is look at the history of the >> databases/postgresql15-server port in eg. GitHub -- >>=20 >> = https://github.com/freebsd/freebsd-ports/tree/main/databases/postgresql15-= server >>=20 >> where you want to look at Makefile and distinfo in paticular. >>=20 >> You can see what was changed from the last update and basically = revert >> those for your purposes. Postgresql ports are unfortunately rather = more >> complicated than most since they use a common base for all postgresql >> branches, but hopefully you can make sense of it. >>=20 >> OTOH, if you already have postgresql-15.6 installed anywhere, you can >> make a package tarball from that: >>=20 >> pkg create -f tbz postgresql15-server-15.6 >=20 > Now that is a handy trick, and will probably work well for our needs! You might also want to look at the /usr/ports/UPDATING entry for = upgrading between major versions of PostgreSQL (e.g., the 20230908 = entry). It uses "pkg create" to create an installable package version = of the existing PostgreSQL binaries prior to installing the new ones and = performing the upgrade. Cheers, Paul.