From nobody Mon Jul 08 12:31:42 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 4WHk5L4tqbz5Q5t9 for ; Mon, 08 Jul 2024 12:31:50 +0000 (UTC) (envelope-from cli_junkie@protonmail.com) Received: from mail-40134.protonmail.ch (mail-40134.protonmail.ch [185.70.40.134]) (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-signature RSA-PSS (4096 bits) client-digest SHA256) (Client CN "protonmail.com", Issuer "R3" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4WHk5L0bBpz4dQb for ; Mon, 8 Jul 2024 12:31:50 +0000 (UTC) (envelope-from cli_junkie@protonmail.com) Authentication-Results: mx1.freebsd.org; dkim=pass header.d=protonmail.com header.s=protonmail3 header.b=y+4NqAEx; dmarc=pass (policy=quarantine) header.from=protonmail.com; spf=pass (mx1.freebsd.org: domain of cli_junkie@protonmail.com designates 185.70.40.134 as permitted sender) smtp.mailfrom=cli_junkie@protonmail.com DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=protonmail.com; s=protonmail3; t=1720441907; x=1720701107; bh=Unq9rRVtmQiKiSHiWoVYhct1yQy2sV41TKYyXXgEq40=; h=Date:To:From:Subject:Message-ID:In-Reply-To:References: Feedback-ID:From:To:Cc:Date:Subject:Reply-To:Feedback-ID: Message-ID:BIMI-Selector; b=y+4NqAEx1FlEPmKag11Xpj4ScgHp6ZO7AMuS3DGs7OkLKBQnQ+bHR9ACXgX4WqXKG NpoQc97eQApU85V/kaOwndlGjGvyXdMbkOVZUPj5ZM7epPhW5jhLIkKFn3uZnhoPPN 1rJFj5kf6n6pD/gwAP+jSg56yvBUG5UySHuHlpn69IXLfpcGcLwAaDg/dNuZtjrDbR Hr4SzaZSSjwzKTpYpfdOJybBI4GofIbnL9JIaxDCp7bbxvHvlQYufI1kVMwsmp1WNe Uko0VpSEMylTsqhLKGiItJ4Jd4MxIwJWnjnGzJwYUDiHcUqUxHt72sIGCIoCrgTaCD JnM26Kg6W8BJg== Date: Mon, 08 Jul 2024 12:31:42 +0000 To: "questions@freebsd.org" From: Pat Subject: Re: Setting default version in Poudriere Message-ID: In-Reply-To: <74d6fd53-a530-a905-2fa9-3920a5d50f39@ShaneWare.Biz> References: <74d6fd53-a530-a905-2fa9-3920a5d50f39@ShaneWare.Biz> Feedback-ID: 34340203:user:proton X-Pm-Message-ID: 343b0fedad5bf3811c4d30ab292dd54b0174917b 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 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-Spamd-Bar: --- X-Spamd-Result: default: False [-3.77 / 15.00]; NEURAL_HAM_LONG(-1.00)[-1.000]; NEURAL_HAM_MEDIUM(-1.00)[-1.000]; NEURAL_HAM_SHORT(-0.57)[-0.568]; DMARC_POLICY_ALLOW(-0.50)[protonmail.com,quarantine]; R_SPF_ALLOW(-0.20)[+ip4:185.70.40.0/24:c]; RWL_MAILSPIKE_VERYGOOD(-0.20)[185.70.40.134:from]; R_DKIM_ALLOW(-0.20)[protonmail.com:s=protonmail3]; MIME_GOOD(-0.10)[text/plain]; ASN(0.00)[asn:62371, ipnet:185.70.40.0/24, country:CH]; RCPT_COUNT_ONE(0.00)[1]; MIME_TRACE(0.00)[0:+]; RCVD_IN_DNSWL_NONE(0.00)[185.70.40.134:from]; MISSING_XM_UA(0.00)[]; FREEMAIL_ENVFROM(0.00)[protonmail.com]; FREEMAIL_FROM(0.00)[protonmail.com]; ARC_NA(0.00)[]; RCVD_COUNT_ZERO(0.00)[0]; MLMMJ_DEST(0.00)[questions@freebsd.org]; FROM_HAS_DN(0.00)[]; MID_RHS_MATCH_FROM(0.00)[]; FROM_EQ_ENVFROM(0.00)[]; TO_MATCH_ENVRCPT_ALL(0.00)[]; TO_DN_EQ_ADDR_ALL(0.00)[]; DKIM_TRACE(0.00)[protonmail.com:+] X-Rspamd-Queue-Id: 4WHk5L0bBpz4dQb On Saturday, July 6th, 2024 at 01:47, Shane Ambler = wrote: >=20 >=20 > On 5/7/24 06:27, Pat wrote: >=20 > > Hello, > >=20 > > Got a couple of rather silly question, but I can't find a definitive an= swer to either. > >=20 > > If I build PostgreSQL15-server, I get version 15.7. That is the latest = version, so not unexpected. > >=20 > > I would like to build version 15.6. Ideally I would like to have both v= ersions available because for the most part I want to install 15.7, but I n= eed 15.6 at the moment. > >=20 > > So my questions are: > > How do I configure things to have both versions available? > > If that is not possible, how do I set the default to be 15.6 for now, w= ith the intent of undoing that after my testing? >=20 >=20 > As far as ports go, you can configure the major postgresql version > (14.x, 15.x), in make.conf add DEFAULT_VERSIONS=3D pgsql=3D15 Thank you Shane. I did actually figure that out over the weekend too. First I tried setting that to 15.6 but got an error with a helpful message that stated the acceptable versions were 12 - 16. >=20 > Considering you have a database requiring 15.6, you would have that > installed and running already, I would suggest setting up 15.7 DB in a > jail or second machine for regression tests and not need a second 15.6 > server running. So you would only need to build the newer version. >=20 > Are you aware of the postgresql versioning changes since 10? The first > number is a major version, the second is a minor bug/security update >=20 > 15.6 to 15.7 is a minor update that can be done in-place. >=20 > From https://www.postgresql.org/support/versioning/ >=20 > Minor release upgrades do not require a dump and restore; you simply > stop the database server, install the updated binaries, and restart the > server. Such upgrades might require additional steps so always read the > release notes first. >=20 > Minor releases only contain fixes for frequently-encountered bugs, > low-risk fixes, security issues, and data corruption problems. The > community considers performing minor upgrades to be less risky than > continuing to run an old minor version. Yes, I am aware of all of that, but you had no way of knowing that, so I appreciate the time you took to explain this. I've been a PG DBA for 15 years :) We have a good bit of custom code and the developer claims to have run into an issue previously with a minor version change. So we want to stand up a separate test environment for grins. And, I wouldn't mind knowing how to do this for future reference, not just for PG but in general. Regards, Pat >=20 >=20 > -- > FreeBSD - the place to B...Serving Data >=20 > Shane Ambler