From nobody Sat Jul 06 01:47:55 2024 X-Original-To: freebsd-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 4WGCvZ1zgkz5P9lj for ; Sat, 06 Jul 2024 01:48:10 +0000 (UTC) (envelope-from freebsd@shaneware.biz) Received: from mail-relay3.dca2.superb.net (mail-relay3.dca2.superb.net [66.148.95.55]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client did not present a certificate) by mx1.freebsd.org (Postfix) with ESMTPS id 4WGCvY1m2Fz4Sjc for ; Sat, 6 Jul 2024 01:48:09 +0000 (UTC) (envelope-from freebsd@shaneware.biz) Authentication-Results: mx1.freebsd.org; dkim=pass header.d=superb.net header.s=mailrelay header.b="ZFiYzg/F"; dmarc=fail reason="No valid SPF, DKIM not aligned (relaxed)" header.from=shaneware.biz (policy=quarantine); spf=softfail (mx1.freebsd.org: 66.148.95.55 is neither permitted nor denied by domain of freebsd@shaneware.biz) smtp.mailfrom=freebsd@shaneware.biz DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=superb.net; s=mailrelay; h=Content-Transfer-Encoding:Content-Type:In-Reply-To:From: References:To:Subject:MIME-Version:Date:Message-ID:Sender:Reply-To:Cc: Content-ID:Content-Description:Resent-Date:Resent-From:Resent-Sender: Resent-To:Resent-Cc:Resent-Message-ID:List-Id:List-Help:List-Unsubscribe: List-Subscribe:List-Post:List-Owner:List-Archive; bh=a+QE4hZE5P7fnZRpe+HLIehNlecmq9maA5gG2KJYB9g=; b=ZFiYzg/FurEZuWlmciN7dby2sO CZS1Zj9ptkTuGL1Da3wngZOpcjlrcLEVNzcwjF+vYbsfWIeZdjtnWhqyAgVxsXCUoktGHmhNjm5vm 1sOtnYdkOAowCBIOGxdptnR5LAnG89CJ1xs1KRy9TJyHy7MN8KyAwnG4VWWSM4kSHk2UdEhyjEyUC vG24upO+nk9fXvZg4NwRqrGCz5pAdyNGgiCa+Y8BEQa9EKmCHnyhIlZpkF4rFINSXUx2tR1RPOsSF NDvWRhG5iKfqkxJpx0vq8z6RPNqa3aYQpolHxT9crnnWiUi12e8RyN9fljNQ6OIvLnHSZHsh9zQ+B DVszOsWQ==; Received: from ppp230-11.static.internode.on.net ([203.122.230.11] helo=[192.168.9.155]) by mail-relay3.dca2.superb.net with esmtpsa (TLS1.2:ECDHE-RSA-AES128-GCM-SHA256:128) (envelope-from ) id 1sPuWv-0007SY-85; Fri, 05 Jul 2024 21:48:02 -0400 Message-ID: <74d6fd53-a530-a905-2fa9-3920a5d50f39@ShaneWare.Biz> Date: Sat, 6 Jul 2024 11:17:55 +0930 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 User-Agent: Mozilla/5.0 (X11; FreeBSD amd64; rv:102.0) Gecko/20100101 Thunderbird/102.11.0 Subject: Re: Setting default version in Poudriere To: Pat , freebsd-questions References: Content-Language: en-AU From: Shane Ambler In-Reply-To: Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-SA-Score: -3.1 X-Spamd-Bar: - X-Spamd-Result: default: False [-1.80 / 15.00]; DMARC_POLICY_QUARANTINE(1.50)[shaneware.biz : No valid SPF, DKIM not aligned (relaxed),quarantine]; NEURAL_HAM_MEDIUM(-1.00)[-1.000]; NEURAL_HAM_LONG(-1.00)[-1.000]; NEURAL_HAM_SHORT(-1.00)[-0.998]; R_DKIM_ALLOW(-0.20)[superb.net:s=mailrelay]; MIME_GOOD(-0.10)[text/plain]; ARC_NA(0.00)[]; RCVD_VIA_SMTP_AUTH(0.00)[]; ASN(0.00)[asn:14361, ipnet:66.148.95.0/24, country:US]; MIME_TRACE(0.00)[0:+]; RCVD_COUNT_ONE(0.00)[1]; DWL_DNSWL_NONE(0.00)[superb.net:dkim]; RCVD_TLS_ALL(0.00)[]; MID_RHS_MATCH_FROM(0.00)[]; RCPT_COUNT_TWO(0.00)[2]; FROM_EQ_ENVFROM(0.00)[]; FROM_HAS_DN(0.00)[]; FREEMAIL_TO(0.00)[protonmail.com,freebsd.org]; R_SPF_SOFTFAIL(0.00)[~all]; TO_DN_ALL(0.00)[]; TO_MATCH_ENVRCPT_SOME(0.00)[]; MLMMJ_DEST(0.00)[freebsd-questions@freebsd.org]; DKIM_TRACE(0.00)[superb.net:+] X-Rspamd-Queue-Id: 4WGCvY1m2Fz4Sjc On 5/7/24 06:27, Pat wrote: > Hello, > > Got a couple of rather silly question, but I can't find a definitive answer to either. > > If I build PostgreSQL15-server, I get version 15.7. That is the latest version, so not unexpected. > > I would like to build version 15.6. Ideally I would like to have both versions available because for the most part I want to install 15.7, but I need 15.6 at the moment. > > 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, with the intent of undoing that after my testing? As far as ports go, you can configure the major postgresql version (14.x, 15.x), in make.conf add DEFAULT_VERSIONS= pgsql=15 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. 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 15.6 to 15.7 is a minor update that can be done in-place. From https://www.postgresql.org/support/versioning/ 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. 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. -- FreeBSD - the place to B...Serving Data Shane Ambler