From nobody Tue Jul 23 16:31:39 2024 X-Original-To: dev-commits-ports-main@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 4WT2j73GFPz5SC7H; Tue, 23 Jul 2024 16:31:39 +0000 (UTC) (envelope-from git@FreeBSD.org) Received: from mxrelay.nyi.freebsd.org (mxrelay.nyi.freebsd.org [IPv6:2610:1c1:1:606c::19:3]) (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 "mxrelay.nyi.freebsd.org", Issuer "R11" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4WT2j72q6wz4cZv; Tue, 23 Jul 2024 16:31:39 +0000 (UTC) (envelope-from git@FreeBSD.org) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1721752299; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding; bh=tWTrQY/n/1XvOlHScmf3KhhS5y+RI8sgLMPuJm+Csus=; b=Ei6LzfVMykHaQewOF8uumP0r9o3qvBvsrlOf/lcxf4PlWt6CHN0is/bUQdtP1Qzatnke1m qez0cZd2Mdg7GqYprKKWLCYeohysAqpCpmmCmf9PHXtKURisklQaQNki+jHqe2JnRx1Mym DWWA+8Nsu3bLql/5qP+qPL6PFQ/SIliy4cXtDHQiDQxnmatGI1WqiuZWubQbH8a6LvN+h0 YGfUTZHD59ixXg0bHNE8QM3VezhTYBAARMv6kwUUgpxAm3l5UZpr+3F3AL4hhJnaeYmytc kd8eOvTs2y7bQjWAJJdg01Sly2FsfGFm3/JVwh8VINPehbqYAWfzxjxOV0SzFA== ARC-Seal: i=1; s=dkim; d=freebsd.org; t=1721752299; a=rsa-sha256; cv=none; b=FHx/8vQrc3K87IIDc/Xv+qeaJY/0k2zPoKysvYxJ1lTQebUSdtRdcw3WZxGZr2sSdD6yAC Lz7u/t+hZTx0vUvtCxXJ6k2Do+MqnFVgwaYdbQopOJIrU9VAuXOU3gotLbgnBvgI6bzejj Bkr0XADAOedx6x1VL/6kkzcUyq9chDy5phIvz3l7MpKoyA8K/o5YOPiBcEwhdg+prPx582 eR6Pi2CTmycx0ayl5SMr2U5oWIF9gYb4whoQf5UsF8GE4NpSYQ5m9n2LgwM1p61HToL3Al 9qrhmIHCkckWLMpHdvp8YWHzfF2wBl0m9Kk+vkR6V0n7n7ADG3OvLh2+XIFEcg== ARC-Authentication-Results: i=1; mx1.freebsd.org; none ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1721752299; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding; bh=tWTrQY/n/1XvOlHScmf3KhhS5y+RI8sgLMPuJm+Csus=; b=P8JlgBGKt3MCt2jEC/1bAfFfM1nLkIG3nxBEj/Oqv0fhcf0u3sB4BFGJTqUbHEVqcrW1Oc XixNsZLdUUZK0GRf5brdudWje+UsGNHVYjFiZWMyHcamjVtOKmi595gR3m6XyI7Cf36NJr FgFaH/tZORmxQtSsuKh4CuXmqN8I6FtGj+300XrLlktUezT0pQm1DxEGSTSi1jtNK3FKq1 INCUPinRdX6IN6btgmFqvqf9BXy7te7dstGmypIy3NtfVKoUc9JtXv0xP+fhLF4EQX51n2 LqvofE+pyxD4t954AONhSfxez6mIFLPXs4mmyDZYNIc8eHnSsjwP9jYtEzstxQ== Received: from gitrepo.freebsd.org (gitrepo.freebsd.org [IPv6:2610:1c1:1:6068::e6a:5]) (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 did not present a certificate) by mxrelay.nyi.freebsd.org (Postfix) with ESMTPS id 4WT2j72QXpzbfR; Tue, 23 Jul 2024 16:31:39 +0000 (UTC) (envelope-from git@FreeBSD.org) Received: from gitrepo.freebsd.org ([127.0.1.44]) by gitrepo.freebsd.org (8.18.1/8.18.1) with ESMTP id 46NGVdg9042000; Tue, 23 Jul 2024 16:31:39 GMT (envelope-from git@gitrepo.freebsd.org) Received: (from git@localhost) by gitrepo.freebsd.org (8.18.1/8.18.1/Submit) id 46NGVd52041997; Tue, 23 Jul 2024 16:31:39 GMT (envelope-from git) Date: Tue, 23 Jul 2024 16:31:39 GMT Message-Id: <202407231631.46NGVd52041997@gitrepo.freebsd.org> To: ports-committers@FreeBSD.org, dev-commits-ports-all@FreeBSD.org, dev-commits-ports-main@FreeBSD.org From: Kevin Bowling Subject: git: b86336fa4d39 - main - Mk/bsd.default-versions.mk: Update to PostgreSQL 16 List-Id: Commits to the main branch of the FreeBSD ports repository List-Archive: https://lists.freebsd.org/archives/dev-commits-ports-main List-Help: List-Post: List-Subscribe: List-Unsubscribe: X-BeenThere: dev-commits-ports-main@freebsd.org Sender: owner-dev-commits-ports-main@FreeBSD.org MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit X-Git-Committer: kbowling X-Git-Repository: ports X-Git-Refname: refs/heads/main X-Git-Reftype: branch X-Git-Commit: b86336fa4d39af5eb0a1f228a649ca4389e628dc Auto-Submitted: auto-generated The branch main has been updated by kbowling: URL: https://cgit.FreeBSD.org/ports/commit/?id=b86336fa4d39af5eb0a1f228a649ca4389e628dc commit b86336fa4d39af5eb0a1f228a649ca4389e628dc Author: Kevin Bowling AuthorDate: 2024-07-23 16:29:21 +0000 Commit: Kevin Bowling CommitDate: 2024-07-23 16:31:07 +0000 Mk/bsd.default-versions.mk: Update to PostgreSQL 16 See UPDATING for upgrade advice PR: 278885 Exp-run by: antoine --- Mk/bsd.default-versions.mk | 2 +- UPDATING | 53 ++++++++++++++++++++++++++++++++++++++++++++++ 2 files changed, 54 insertions(+), 1 deletion(-) diff --git a/Mk/bsd.default-versions.mk b/Mk/bsd.default-versions.mk index c86a911f095b..3c62ece4b8ce 100644 --- a/Mk/bsd.default-versions.mk +++ b/Mk/bsd.default-versions.mk @@ -127,7 +127,7 @@ _EXPORTED_VARS+= _PERL5_FROM_BIN PERL5_DEFAULT:= ${_PERL5_FROM_BIN:R} . endif # Possible values: 12, 13, 14, 15, 16 -PGSQL_DEFAULT?= 15 +PGSQL_DEFAULT?= 16 # Possible values: 8.1, 8.2, 8.3 PHP_DEFAULT?= 8.2 # Possible values: rust, legacy diff --git a/UPDATING b/UPDATING index 82535af1a623..1cf96e29c93e 100644 --- a/UPDATING +++ b/UPDATING @@ -5,6 +5,59 @@ they are unavoidable. You should get into the habit of checking this file for changes each time you update your ports collection, before attempting any port upgrades. +20240723: + AFFECTS: users of databases/postgresql* and other software using PostgreSQL to run + AUTHOR: kbowling@FreeBSD.org + + The default version of PostgreSQL has been switched from 15 to 16. + The upgrade procedure can use up twice the space the databases + currently needs. If you have a big amount of stored data take a + closer look at the manpage of pg_upgrade for avoidance and/or + speedup of the upgrade. + + The upgrade instructions consider a basic usage and do not match + complex scenarios like replication, sharding, or similar. + + Upgrade instructions: + + First stop your PostgreSQL, create PostgreSQL-binaries and backup your data. + If you have another Version of PostgreSQL installed, for example 15, your + files are named according to this. + + # service postgresql stop + # pkg create postgresql15-server postgresql15-contrib + # mkdir /tmp/pg-upgrade + # tar xf postgresql15-server-15.7.pkg -C /tmp/pg-upgrade + # tar xf postgresql15-contrib-15.7.pkg -C /tmp/pg-upgrade + # pkg delete -f databases/postgresql15-server databases/postgresql15-contrib databases/postgresql15-client + + Now update PostgreSQL: + + pkg user: + # pkg install databases/postgresql16-server databases/postgresql16-contrib + # pkg upgrade + + Portmaster users: + # portmaster databases/postgresql16-server databases/postgresql16-contrib + # portmaster -a + + Portupgrade users: + # portinstall databases/postgresql16-server databases/postgresql16-contrib + # portupgrade -a + + After installing the new PostgreSQL version you need to convert + all your databases to new version: + + # su -l postgres -c "/usr/local/bin/initdb --encoding=utf-8 --lc-collate=C -D /var/db/postgres/data16 -U postgres" + # su -l postgres -c "pg_upgrade -b /tmp/pg-upgrade/usr/local/bin/ -d /var/db/postgres/data15/ -B /usr/local/bin/ -D /var/db/postgres/data16/ -U postgres " + + Now the migration is finished. You can start PostgreSQL again with: + + # service postgresql start + + ATTENTION: + 1) If you use non-default initdb options, you have to adjust the initdb-command accordingly + 20240715: AFFECTS: net-mgmt/netbox AUTHOR: kai@FreeBSD.org