From owner-freebsd-questions@freebsd.org Wed Jan 20 17:58:28 2021 Return-Path: Delivered-To: freebsd-questions@mailman.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mailman.nyi.freebsd.org (Postfix) with ESMTP id EC6B34FD98A for ; Wed, 20 Jan 2021 17:58:28 +0000 (UTC) (envelope-from gobble.wa@gmail.com) Received: from mail-ed1-x534.google.com (mail-ed1-x534.google.com [IPv6:2a00:1450:4864:20::534]) (using TLSv1.3 with cipher TLS_AES_128_GCM_SHA256 (128/128 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256 client-signature RSA-PSS (2048 bits) client-digest SHA256) (Client CN "smtp.gmail.com", Issuer "GTS CA 1O1" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4DLYD41M2Gz3NTM for ; Wed, 20 Jan 2021 17:58:27 +0000 (UTC) (envelope-from gobble.wa@gmail.com) Received: by mail-ed1-x534.google.com with SMTP id n6so11731664edt.10 for ; Wed, 20 Jan 2021 09:58:27 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:from:date:message-id:subject:to; bh=uXH1uc8jCCPyQpajP8m0O7lh4ErwISaAX7SMylp2si4=; b=RhJ7jatp35kUmE2kWYnonA3DIj20x0qdI1iOutgQuy5PS5Y7yHvg4i/83pmyK++csw hdKww/5RvUSo2eLcceGtOxtGLw5gZAnpcfDtFQpSpZnU2mb341XpUqK+PAAhvehCGEzV C4YNTkL2Q+aPkF8JdeFjAekPmENSK95uq93JInhrkQSi3+Xt0Y9aH1oyWRofksGNDyOR ZEQPvkKXvFH4/q0XziKK8u/6nXAVSUF1QVBrAl7zJrpce1EvK091RbYTy9AkVp1C5REO WzlRWi6sNpgwx1vFYSS0tPP9Q9Ski1j5Uo0EBFVrkq7uDgU+CEMYqmA3RiEYD0ss30/5 MB0A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=uXH1uc8jCCPyQpajP8m0O7lh4ErwISaAX7SMylp2si4=; b=FqM1TTgc20mYGYo5hYkymQZP3ejHGmRD4FNUKRk18vrVIIiVcg3JjgLMuEzMeCCD+A yICSFnI/aVxWDXKrb+lbG05t8qzZAgDPLe/45IXI6i0H/adTcGW+irrU/q1fe94YeIKE EXoSia4UWlx6p5Zo2nleMlsMHMnM6rW4tyhYlvlqtl588AZ1opDzqcmkYz2Pnct4VWAX qKvb9kjV7nLu3gMvkbrh982EPPlev/H+QGrSeS7bXLpYf1/BtgiNqLigYJHiE5ElK85G MNj49OW+nfp0kHBoxs7p35PW5zlj+SLYDsu1tjm9I3lDXnPAa3hUffAt6D/I50KDvVCD Z+Ug== X-Gm-Message-State: AOAM5334EYIDhaBnN6H9nU96/zr2C2QHIXoo6Cu5PFYRD0rnXXtATf+j NmDJGbvWBmlNw8FODgSNNn44ArfPIpNf59+HRloy/iDigLJKsgfI X-Google-Smtp-Source: ABdhPJxaShKNYQIwmSpjX2f5Ckx4N5Bcj1+bnsJPjkZp/+xMlRCkK7I/2T+aJ7hgSvEvMNNjGvu0vDFpUwcrpj7YRlc= X-Received: by 2002:a05:6402:34c3:: with SMTP id w3mr8400504edc.3.1611165506594; Wed, 20 Jan 2021 09:58:26 -0800 (PST) MIME-Version: 1.0 From: Waitman Gobble Date: Wed, 20 Jan 2021 13:58:15 -0400 Message-ID: Subject: pkg solver question To: FreeBSD Content-Type: text/plain; charset="UTF-8" X-Rspamd-Queue-Id: 4DLYD41M2Gz3NTM X-Spamd-Bar: - Authentication-Results: mx1.freebsd.org; dkim=pass header.d=gmail.com header.s=20161025 header.b=RhJ7jatp; dmarc=pass (policy=none) header.from=gmail.com; spf=pass (mx1.freebsd.org: domain of gobblewa@gmail.com designates 2a00:1450:4864:20::534 as permitted sender) smtp.mailfrom=gobblewa@gmail.com X-Spamd-Result: default: False [-1.75 / 15.00]; R_SPF_ALLOW(-0.20)[+ip6:2a00:1450:4000::/36:c]; FREEMAIL_FROM(0.00)[gmail.com]; TO_DN_ALL(0.00)[]; DKIM_TRACE(0.00)[gmail.com:+]; DMARC_POLICY_ALLOW(-0.50)[gmail.com,none]; FROM_EQ_ENVFROM(0.00)[]; MIME_TRACE(0.00)[0:+]; RBL_DBL_DONT_QUERY_IPS(0.00)[2a00:1450:4864:20::534:from]; FREEMAIL_ENVFROM(0.00)[gmail.com]; ASN(0.00)[asn:15169, ipnet:2a00:1450::/32, country:US]; TAGGED_FROM(0.00)[]; DWL_DNSWL_NONE(0.00)[gmail.com:dkim]; ARC_NA(0.00)[]; NEURAL_HAM_MEDIUM(-0.75)[-0.749]; R_DKIM_ALLOW(-0.20)[gmail.com:s=20161025]; FROM_HAS_DN(0.00)[]; TO_MATCH_ENVRCPT_ALL(0.00)[]; NEURAL_HAM_LONG(-1.00)[-1.000]; MIME_GOOD(-0.10)[text/plain]; PREVIOUSLY_DELIVERED(0.00)[freebsd-questions@freebsd.org]; RCPT_COUNT_ONE(0.00)[1]; SPAMHAUS_ZRD(0.00)[2a00:1450:4864:20::534:from:127.0.2.255]; NEURAL_SPAM_SHORT(1.00)[1.000]; RCVD_IN_DNSWL_NONE(0.00)[2a00:1450:4864:20::534:from]; RCVD_COUNT_TWO(0.00)[2]; RCVD_TLS_ALL(0.00)[]; MAILMAN_DEST(0.00)[freebsd-questions] X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.34 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 20 Jan 2021 17:58:29 -0000 I've noticed this happening on pkg upgrade. New packages to be INSTALLED: postgresql12-client: 12.5 postgresql12-contrib: 12.5 postgresql12-server: 12.5 Installed packages to be UPGRADED: postgis30: 3.0.1_2 -> 3.0.3 postgresql11-client: 11.8 -> 11.10 postgresql11-contrib: 11.8 -> 11.10 postgresql11-server: 11.8_2 -> 11.10 I think what happens is it decides to uninstall postrgresql11-* because they both cannot exist in the same space. So, it happily installs and starts postgresql12-* but postgresql12-* cannot read postgres11-* data. It's just an empty database. IMHO the best way is to migrate from 11 to 12 running servers. pkg upgrade basically wrecks the database, with the only option of restoring from backup or copying the 11 binaries from another system and putting them in /opt or something. (also copying a few libraries that were upgraded) I think this is not very user friendly and could be much better, at least a warning. -- Waitman Gobble