From nobody Wed Oct 27 08:20:52 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 E8CEF18194E0
	for <freebsd-stable@mlmmj.nyi.freebsd.org>; Wed, 27 Oct 2021 08:20:54 +0000 (UTC)
	(envelope-from bapt@FreeBSD.org)
Received: from smtp.freebsd.org (smtp.freebsd.org [IPv6:2610:1c1:1:606c::24b:4])
	(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 "smtp.freebsd.org", Issuer "R3" (verified OK))
	by mx1.freebsd.org (Postfix) with ESMTPS id 4HfM8Q6H64z3JyL;
	Wed, 27 Oct 2021 08:20:54 +0000 (UTC)
	(envelope-from bapt@FreeBSD.org)
Received: from aniel.nours.eu (nours.eu [176.31.115.77])
	(using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits))
	(Client did not present a certificate)
	(Authenticated sender: bapt)
	by smtp.freebsd.org (Postfix) with ESMTPSA id 9068229EAB;
	Wed, 27 Oct 2021 08:20:54 +0000 (UTC)
	(envelope-from bapt@FreeBSD.org)
Received: by aniel.nours.eu (Postfix, from userid 1001)
	id 25CF3E578E; Wed, 27 Oct 2021 10:20:52 +0200 (CEST)
Date: Wed, 27 Oct 2021 10:20:52 +0200
From: Baptiste Daroussin <bapt@FreeBSD.org>
To: ftimmer@ft-c.de
Cc: "freebsd-stable@freebsd.org" <freebsd-stable@FreeBSD.org>
Subject: Re: pkg postgresql-client
Message-ID: <20211027082052.vuieglgwlgporlpk@aniel.nours.eu>
References: <fac711df3771e57983b7d8e032d7acb36496a7f1.camel@ft-c.de>
List-Id: Production branch of FreeBSD source code <freebsd-stable.freebsd.org>
List-Archive: https://lists.freebsd.org/archives/freebsd-stable
List-Help: <mailto:stable+help@freebsd.org>
List-Post: <mailto:stable@freebsd.org>
List-Subscribe: <mailto:stable+subscribe@freebsd.org>
List-Unsubscribe: <mailto:stable+unsubscribe@freebsd.org>
Sender: owner-freebsd-stable@freebsd.org
X-BeenThere: freebsd-stable@freebsd.org
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <fac711df3771e57983b7d8e032d7acb36496a7f1.camel@ft-c.de>
X-ThisMailContainsUnwantedMimeParts: N

On Wed, Oct 27, 2021 at 09:54:14AM +0200, ml@ft-c.de wrote:
> Hello, 
> 
> I have install postgresql version 13 
> (and in a few weeks I switch to version 14) 
> 
> When I install R-studio, then pkg would change/downgrade the
> postgresql-client version from 13 to 12. 
> 
> 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):
> 
> New packages to be INSTALLED:
>         RStudio: 1.4.1717_2
>         postgresql12-client: 12.8
>         soci: 4.0.1_1
> 
> This error has existed for more than 5 years.
> 
> Franz
> 
> uname -a :> FreeBSD  13.0-RELEASE-p4  amd64
> 
> 
> 

Welcome to the postgresql hell (same applies to mysql family) on freebsd

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.

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.

https://lists.freebsd.org/pipermail/freebsd-ports/2015-July/099842.html

Best regards,
Bapt