From nobody Wed Oct 27 16:57:48 2021 X-Original-To: freebsd-stable@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 9BA40181CD79 for ; Wed, 27 Oct 2021 16:57:55 +0000 (UTC) (envelope-from spork@bway.net) Received: from smtp2.bway.net (smtp2.bway.net [216.220.96.28]) (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 4HfZcz3xg4z4SF4; Wed, 27 Oct 2021 16:57:55 +0000 (UTC) (envelope-from spork@bway.net) Received: from gaseousweiner.sporklab.com (pool-74-102-83-202.nwrknj.fios.verizon.net [74.102.83.202]) (using TLSv1.2 with cipher ECDHE-ECDSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) (Authenticated sender: spork@bway.net) by smtp2.bway.net (Postfix) with ESMTPSA id 114002931D; Wed, 27 Oct 2021 12:57:49 -0400 (EDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=bway.net; s=mail; t=1635353869; bh=8S6jqB15ZwJz5I1sN5rijUEhGJDDRSjaBroTTuNejWo=; h=Subject:From:In-Reply-To:Date:Cc:References:To; b=bVmrWNTsBJT1O3BEQ1at70ftHfSMfrsgfd4WR7pObPuOZk0cjGuMMCsyKUeFyvCtS fJU/LXrOOiS7aDlQgM0dikYHsg6EHiNTFkRMVS4mul0zRc/dbpNAjhxHfAI9ZwdcMC 3GPo6Rrkx7Qk/wUfTPaRnm4nN+Hs1uxO/VjSukuw= Content-Type: text/plain; charset=us-ascii List-Id: Production branch of FreeBSD source code List-Archive: https://lists.freebsd.org/archives/freebsd-stable List-Help: List-Post: List-Subscribe: List-Unsubscribe: Sender: owner-freebsd-stable@freebsd.org X-BeenThere: freebsd-stable@freebsd.org Mime-Version: 1.0 (Mac OS X Mail 12.4 \(3445.104.21\)) Subject: Re: pkg postgresql-client In-Reply-To: <20211027082052.vuieglgwlgporlpk@aniel.nours.eu> Date: Wed, 27 Oct 2021 12:57:48 -0400 Cc: ftimmer@ft-c.de, "freebsd-stable@freebsd.org" X-Mao-Original-Outgoing-Id: 657046668.294693-69f001754a8d86fc6011668543ae59a7 Content-Transfer-Encoding: quoted-printable Message-Id: <8362A12C-F144-4572-9DF3-F06239A53900@bway.net> References: <20211027082052.vuieglgwlgporlpk@aniel.nours.eu> To: Baptiste Daroussin X-Mailer: Apple Mail (2.3445.104.21) X-Rspamd-Queue-Id: 4HfZcz3xg4z4SF4 X-Spamd-Bar: ---- Authentication-Results: mx1.freebsd.org; none X-Spamd-Result: default: False [-4.00 / 15.00]; REPLY(-4.00)[] Reply-To: spork@bway.net From: Charles Sprickman via freebsd-stable X-Original-From: Charles Sprickman X-ThisMailContainsUnwantedMimeParts: N > On Oct 27, 2021, at 4:20 AM, Baptiste Daroussin = wrote: >=20 > On Wed, Oct 27, 2021 at 09:54:14AM +0200, ml@ft-c.de wrote: >> Hello,=20 >>=20 >> I have install postgresql version 13=20 >> (and in a few weeks I switch to version 14)=20 >>=20 >> When I install R-studio, then pkg would change/downgrade the >> postgresql-client version from 13 to 12.=20 >>=20 >> pkg install Rstudio >> Updating FreeBSD repository catalogue... >> FreeBSD repository is up to date. >> All repositories are up to date. >> The following 3 package(s) will be affected (of 0 checked): >>=20 >> New packages to be INSTALLED: >> RStudio: 1.4.1717_2 >> postgresql12-client: 12.8 >> soci: 4.0.1_1 >>=20 >> This error has existed for more than 5 years. >>=20 >> Franz >>=20 >> uname -a :> FreeBSD 13.0-RELEASE-p4 amd64 >>=20 >>=20 >>=20 >=20 > Welcome to the postgresql hell (same applies to mysql family) on = freebsd >=20 > This is because on freebsd beside the fact that multiple version = exists in the > ports tree only the "default" can be used when using binary packages. >=20 > I have posted a proposal on how to make any postgresql installable in = parallel, > shoudl be around 6 years ago, unfortunatly noone implemented it since = :(, my > proposal would have eliminated the concept of default and let the user = pick the > version it needs. +1 on that - pkg has gotten to the point where I very, very rarely use = ports and I love that Charles >=20 > = https://lists.freebsd.org/pipermail/freebsd-ports/2015-July/099842.html >=20 > Best regards, > Bapt >=20