From nobody Thu Jan 20 18:13:17 2022 X-Original-To: ports@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 0477E196FB2D for ; Thu, 20 Jan 2022 18:13:34 +0000 (UTC) (envelope-from freebsd@gushi.org) Received: from prime.gushi.org (prime.gushi.org [IPv6:2620:137:6000:10::142]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client CN "prime.gushi.org", Issuer "RapidSSL TLS DV RSA Mixed SHA256 2020 CA-1" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4JfrH11M4Qz4b5S for ; Thu, 20 Jan 2022 18:13:33 +0000 (UTC) (envelope-from freebsd@gushi.org) Received: from smtpclient.apple ([IPv6:2601:602:0:8e8:7914:df08:8b33:11e8]) (authenticated bits=0) by prime.gushi.org (8.16.1/8.16.1) with ESMTPSA id 20KIDMWs068724 (version=TLSv1.2 cipher=ECDHE-RSA-AES256-GCM-SHA384 bits=256 verify=NO); Thu, 20 Jan 2022 10:13:24 -0800 (PST) (envelope-from freebsd@gushi.org) DKIM-Filter: OpenDKIM Filter v2.10.3 prime.gushi.org 20KIDMWs068724 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gushi.org; s=prime2014; t=1642702404; bh=3/cHPGEkWnU8aKJns0fEbnjZaQ3pqQMDMxljVtkYKa8=; h=Subject:From:In-Reply-To:Date:Cc:References:To; z=Subject:=20Re:=20p5-dbd-pg|From:=20Dan=20Mahoney=20|In-Reply-To:=20|Date:=20Thu, =2020=20Jan=202022=2010:13:17=20-0800|Cc:=20ports@freebsd.org|Refe rences:=20<760559B7-EE1A-421D-BB8A-8402A9305FF6@gushi.org>=0D=0A=2 0|To:=20Christoph=20Moench-Tegeder =20; b=KiZziUszcD4uFERfesGAWMLTD84NT4sP9B55Tf4dObz0x+tTtzzLkB0Yp4VaxuRYM ZiwCqaXmdnbmeIu0k9Qx/gVVpiFS6KVTfJFtQIAuiEnsfZQnPZbtDFdkELU6gA93Np vq+lZVajwsHjnhqqIq57ahXywH68J+z2wfa3M81CzEi9WdVRtsd5T6alKQxBumEAFr hChXkaArAysTTT4U8I5L8ExwIjLfgFXQtrkMK4mHzRHXoTq5Fwelq4gIoecPPb4Gk6 Q4tgQRuYAVuq7hIiwGhUwqBd3o2llFRHdiOl0ZtuET0RLS/lLcM1aBzSadsnZ8i1DK UQX7MUXftRNHA== X-Authentication-Warning: prime.gushi.org: Host [IPv6:2601:602:0:8e8:7914:df08:8b33:11e8] claimed to be smtpclient.apple Content-Type: text/plain; charset=us-ascii List-Id: Porting software to FreeBSD List-Archive: https://lists.freebsd.org/archives/freebsd-ports List-Help: List-Post: List-Subscribe: List-Unsubscribe: Sender: owner-freebsd-ports@freebsd.org X-BeenThere: freebsd-ports@freebsd.org Mime-Version: 1.0 (Mac OS X Mail 15.0 \(3693.40.0.1.81\)) Subject: Re: p5-dbd-pg From: Dan Mahoney In-Reply-To: Date: Thu, 20 Jan 2022 10:13:17 -0800 Cc: ports@freebsd.org Content-Transfer-Encoding: quoted-printable Message-Id: References: <760559B7-EE1A-421D-BB8A-8402A9305FF6@gushi.org> To: Christoph Moench-Tegeder X-Mailer: Apple Mail (2.3693.40.0.1.81) X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.6.2 (prime.gushi.org [IPv6:2620:137:6000:10:0:0:0:142]); Thu, 20 Jan 2022 18:13:24 +0000 (UTC) X-Rspamd-Queue-Id: 4JfrH11M4Qz4b5S X-Spamd-Bar: ---- Authentication-Results: mx1.freebsd.org; dkim=pass header.d=gushi.org header.s=prime2014 header.b=KiZziUsz; dmarc=pass (policy=none) header.from=gushi.org; spf=pass (mx1.freebsd.org: domain of freebsd@gushi.org designates 2620:137:6000:10::142 as permitted sender) smtp.mailfrom=freebsd@gushi.org X-Spamd-Result: default: False [-4.20 / 15.00]; RCVD_VIA_SMTP_AUTH(0.00)[]; TO_DN_SOME(0.00)[]; MV_CASE(0.50)[]; R_SPF_ALLOW(-0.20)[+mx]; HAS_XAW(0.00)[]; RCVD_DKIM_ARC_DNSWL_MED(-0.50)[]; RCVD_IN_DNSWL_MED(-0.20)[2620:137:6000:10::142:from]; RCPT_COUNT_TWO(0.00)[2]; DMARC_POLICY_ALLOW(-0.50)[gushi.org,none]; DKIM_TRACE(0.00)[gushi.org:+]; NEURAL_HAM_SHORT(-1.00)[-1.000]; FROM_EQ_ENVFROM(0.00)[]; MIME_TRACE(0.00)[0:+]; ASN(0.00)[asn:393507, ipnet:2620:137:6000::/44, country:US]; MID_RHS_MATCH_FROM(0.00)[]; ARC_NA(0.00)[]; R_DKIM_ALLOW(-0.20)[gushi.org:s=prime2014]; FROM_HAS_DN(0.00)[]; DWL_DNSWL_MED(-2.00)[gushi.org:dkim]; NEURAL_HAM_LONG(-1.00)[-1.000]; MIME_GOOD(-0.10)[text/plain]; NEURAL_SPAM_MEDIUM(1.00)[1.000]; TO_MATCH_ENVRCPT_SOME(0.00)[]; MLMMJ_DEST(0.00)[ports]; RCVD_COUNT_TWO(0.00)[2]; RCVD_TLS_ALL(0.00)[] X-ThisMailContainsUnwantedMimeParts: N > On Jan 20, 2022, at 9:38 AM, Christoph Moench-Tegeder = wrote: >=20 > ## Dan Mahoney (freebsd@gushi.org): >=20 >> On doing a routine pkg upgrade at the dayjob, the perl module = p5-DBD-pg >> forced an upgrade from postgresql12-client to postgresql13-client = (which >> uninstalled postgresql12-server). >=20 > p5-DBD-Pg uses the "default" postgresql version, which switched from > 12 to 13 in Octobe r(or with the Quarterly switch, depending on what > you use). > If you build your own packages, you could pin the default postgresql > version according to your needs via the make.conf mechanism, that is > DEFAULT_VERSIONS+=3D pgsql=3D12 as an example. The whole point of using pkg is that I should not have to build my own = packages. My ticket system was down for several hours while I reinstalled = postgresql12 (which uininstalled p5-dbd-pg), dumped a 3.5G db, and then = reinstalled postgresql13-server, and reimported, because that's what you = have to do when you upgrade postgres. (I hate this about postgres, but = it is what it is). Worse still, the initial install of p5-dbd-pg pulled in = postgres13-client, but DID NOT DELETE postgres12-client or = postgres12-server, so I assumed the whole "these things can coexist" = problem had been fixed. As people had said, the actual client is stable = -- and besides which, a 13 client can talk to a 12 DB (as it might do = over the internet). The SECOND pkg upgrade then wiped out the = postgresql12 stuff. For a perl module that could be flavored so it works with whatever thing = you have installed. (It doesn't call for a specific version, it just = has uses =3D pgsql). Had I seen this level of fail coming, I would have deployed on a = parallel VM, or done the db dump beforehand, but the initial pkg upgrade = did not show it was deleting postgres 12. Luckily, this ticket system is internal, and we have a process to cache = inbound tickets on our border MXes, so it wasn't the end of the world, = but it was still annoying. (We have backups, of course, but they're not down-to-the-transaction). -Dan