From nobody Tue May 06 18:35:26 2025 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 4ZsRsV3mlDz5vDtQ; Tue, 06 May 2025 18:35:26 +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 4ZsRsV3HhRz3LlZ; Tue, 06 May 2025 18:35:26 +0000 (UTC) (envelope-from git@FreeBSD.org) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1746556526; 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=nW8mzv8kfnLInYiVTsI2hYDaI9iotl1rGRLZ3o14K2o=; b=IElejNGJQ34MOGB0nqf7OMOVkWVdHTY/y8IlY3RWwvckuEoUMB1g/kLEw5kOodyrDtr0SH Pq5CI1LrmOhLWLqHVmH11t7FcFMmRgTJeqYUU8BY0qf2lZVqVt75qVDTfqCQ/1qyRpzsf2 LpfHkAnUAuiMxmP9J9mDHfZDSgYYWcrABNE1HF+JkJJe/MwEsmI0XOIqaA7Z1f2zy3rsml N4LQ0wMpGquxGCJsrLuDDOrcriTFhcl7nnOiShGqwdeLY2X5VDnbHBwV9HZPy77h5ZaGg8 UaDHSeFmn6FfkUyPPqTRzq0jsJzdSc8N4N61Sa5wJgXcIxxc+AiP+chxO4nr/w== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1746556526; 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=nW8mzv8kfnLInYiVTsI2hYDaI9iotl1rGRLZ3o14K2o=; b=azLtcKt/MQlwu8zoN9C36JrCx9Yn7c2b6JKPYxQDyIOK/wzLt3cXZjhBhrcc1oxIKl5hG+ Ba95RP9+A6rX3pV49rkMTu/K2O7vtkjVGJj7J9/ECe2rwDatD7Y5cK9v7Hv0iHHeyAIEA8 xMz9C3Q3zl44fWjb185ch0lqmH4WUl/srNc2Mc1C+OC8s0GKHsqEARJ6w2/aYC/LeVIVx8 W36oes4zKW+2FkLvnt0hEJNdsNfZU91x7ocL5GEJ+Ud4N4H4uDxJ5OrjM8sYOE9jYIQtOx i0L06WMyNSSCY+Mkdc3kEjM5g99QmK5iqIPA7kMi0ZRv07Su/VmgJT5J9PZ7Ww== ARC-Seal: i=1; s=dkim; d=freebsd.org; t=1746556526; a=rsa-sha256; cv=none; b=jt/LAEK7+r65kXSmnJm0GCAOQnP8RUlpUtNlJ9LoRY05gj4Nt7k0PnKZG9aJVmR24OYdNl +8iAAGoTKByvn0dP9PA3fMQatvCfaVA40/JgpBcZToKX6w7yJSmXI/3JGlPyPqxkeVPZZm PUeNztDlXcTr9BJ0upchmXXMEm1RApKJGI9MmqXvwQ2kn6yOjkJi85wNpTHFoJDO2t/TvS uEP/2m7QXPc3n9tVE+CyYfsD6ViXkoFrHpmvd67LAP6FG/tKIyfN6A9RJDFqNdwSmdA+aI DpnSxw5EYW/adv38HRh2LCbG0Ewc27mz8dlHOuXM3XTjHU3foQTS294hwLGWUQ== ARC-Authentication-Results: i=1; mx1.freebsd.org; none 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 4ZsRsV2sSqz19mV; Tue, 06 May 2025 18:35:26 +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 546IZQRC039291; Tue, 6 May 2025 18:35:26 GMT (envelope-from git@gitrepo.freebsd.org) Received: (from git@localhost) by gitrepo.freebsd.org (8.18.1/8.18.1/Submit) id 546IZQ83039288; Tue, 6 May 2025 18:35:26 GMT (envelope-from git) Date: Tue, 6 May 2025 18:35:26 GMT Message-Id: <202505061835.546IZQ83039288@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: bcb73b4107fc - main - Mk/bsd.default-versions.mk: Update to PostgreSQL 17 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: bcb73b4107fc6d0d3b01c39e6382277d25192919 Auto-Submitted: auto-generated The branch main has been updated by kbowling: URL: https://cgit.FreeBSD.org/ports/commit/?id=bcb73b4107fc6d0d3b01c39e6382277d25192919 commit bcb73b4107fc6d0d3b01c39e6382277d25192919 Author: Kevin Bowling AuthorDate: 2025-05-06 18:33:16 +0000 Commit: Kevin Bowling CommitDate: 2025-05-06 18:34:32 +0000 Mk/bsd.default-versions.mk: Update to PostgreSQL 17 See UPDATING for upgrade advice PR: 283788 Approved by: antoine (exp-run) --- 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 775bcd1783bc..177b350b2a93 100644 --- a/Mk/bsd.default-versions.mk +++ b/Mk/bsd.default-versions.mk @@ -131,7 +131,7 @@ _EXPORTED_VARS+= _PERL5_FROM_BIN PERL5_DEFAULT:= ${_PERL5_FROM_BIN:R} . endif # Possible values: 13, 14, 15, 16, 17 -PGSQL_DEFAULT?= 16 +PGSQL_DEFAULT?= 17 # Possible values: 8.1, 8.2, 8.3, 8.4 PHP_DEFAULT?= 8.3 # Possible values: rust, legacy diff --git a/UPDATING b/UPDATING index 3c4865293c07..617d0f1646a9 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. +20250506: + 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 16 to 17. + 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 16, your + files are named according to this. + + # service postgresql stop + # pkg create postgresql16-server postgresql16-contrib + # mkdir /tmp/pg-upgrade + # tar xf postgresql16-server-16.8.pkg -C /tmp/pg-upgrade + # tar xf postgresql16-contrib-16.8.pkg -C /tmp/pg-upgrade + # pkg delete -f databases/postgresql16-server databases/postgresql16-contrib databases/postgresql16-client + + Now update PostgreSQL: + + pkg user: + # pkg install databases/postgresql17-server databases/postgresql17-contrib + # pkg upgrade + + Portmaster users: + # portmaster databases/postgresql17-server databases/postgresql17-contrib + # portmaster -a + + Portupgrade users: + # portinstall databases/postgresql17-server databases/postgresql17-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/data17 -U postgres" + # su -l postgres -c "pg_upgrade -b /tmp/pg-upgrade/usr/local/bin/ -d /var/db/postgres/data16/ -B /usr/local/bin/ -D /var/db/postgres/data17/ -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 + 20250503: AFFECTS: users of sysutils/bastille AUTHOR: jdhurtado@orbiware.com