From nobody Fri Sep 8 18:22:26 2023 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 4Rj4GC17f8z4rxvb; Fri, 8 Sep 2023 18:22:27 +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 "R3" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4Rj4GC0fyQz3TQ9; Fri, 8 Sep 2023 18:22:27 +0000 (UTC) (envelope-from git@FreeBSD.org) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1694197347; 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=wyqXYK6t44ae8j1rRpyJ29O97qZKBB8RmVjt7gQ1TO0=; b=OSWAQAOW4Cxgg/SdnmSnjRvBq/F8i4duRwbvmGxbFmv0RpLHCXuFsfyzfNTyJy6MpRFC5z wtweKfBX2IJzylk7f/3C8Skqfjc5TM5ACN/0NBDxkLtiYJy2G2O7pDdGotFn1PwD9r4VQN nXQbgHuw8fSlPTzL2gVJhCHGdsbJLjQZRPXt1FFkTSbQX6OWxBzmT3HcAMzuy1nUQGhi1h 5f4Bdqy1z+W9UdEPgBfKC+nEkDUBULgV2F8ctXJeLPJGhrQD+5a2PyJinyd5Q74CM2aTbJ pAktfA2r5nq9mUV/7iiFPBc/3fRXXglVr+a1zBZOcfhsi6RfjsrArid+XsyLsQ== ARC-Seal: i=1; s=dkim; d=freebsd.org; t=1694197347; a=rsa-sha256; cv=none; b=Dpt4GI8c/XMWt5Aq+HXV5VTL4fYupGXDBs9XaLKl1xIs3kXQoQdFeMeT5b1cCbNDV0P0E3 Ue3SdL8e9v7YM8BsN58SdYTmOmL92onALuqLlab1uMCxWNf0M5MBUPlm7FwQnHEds2pFbg CNDOn7tkxx1bF3UUFhH8u2nMibhaNY35UOQzqMj05vc9unRdBQWeTM+b1SmuBgj4w/8L3q Apdx/lJgTcDpaesR6FqLk6xRFM8n7DqybrJ/ReLKEuS8aB5y7eTfm74VXfSdrbB4o+59m4 P/3fC8gn8OT45zs//Ypf5KiNvR1BhUG8p8vAAKy8jpj2w9VgVKtPN2OQmr92sw== 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=1694197347; 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=wyqXYK6t44ae8j1rRpyJ29O97qZKBB8RmVjt7gQ1TO0=; b=a13cpNdb+iRRnPNFXvMt+bLNz3+S2RPaIU6JqjLsjAF6HeLaZMWbVemx/8Ugzy9jQIPwM5 fv+nbJSjKeMiLMd/4lrwa2gjeESHg3sKASw2NVHzlozbpah7CFKAv9aROIfA1ZxkeIasMb lCa99Tk88CZsCDYhiCKN169wSPU3eQr9UWoftSOM/Eyyv12lGHPd/v89eqQfzQqzoFqWum ZZc+7QhygPj4HWtxyvhijrAYPTUzznsl6Dqr4rV39u5RtU/yhdWP3JtXRoRpWYRV1gUHZN s39kGzW8mGtPfB0fkRqIWHcl6iZIC6t/nevu+tp0bPFF6Ey42jspvihCf96TvA== 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 4Rj4GB6r8rzsKn; Fri, 8 Sep 2023 18:22:26 +0000 (UTC) (envelope-from git@FreeBSD.org) Received: from gitrepo.freebsd.org ([127.0.1.44]) by gitrepo.freebsd.org (8.17.1/8.17.1) with ESMTP id 388IMQuJ057998; Fri, 8 Sep 2023 18:22:26 GMT (envelope-from git@gitrepo.freebsd.org) Received: (from git@localhost) by gitrepo.freebsd.org (8.17.1/8.17.1/Submit) id 388IMQsO057995; Fri, 8 Sep 2023 18:22:26 GMT (envelope-from git) Date: Fri, 8 Sep 2023 18:22:26 GMT Message-Id: <202309081822.388IMQsO057995@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: 0c0bf56482b3 - main - Mk/bsd.default-versions.mk: Update to PostgreSQL 15 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: Sender: owner-dev-commits-ports-main@freebsd.org X-BeenThere: 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: 0c0bf56482b394740f5c14326ae1586158813129 Auto-Submitted: auto-generated The branch main has been updated by kbowling: URL: https://cgit.FreeBSD.org/ports/commit/?id=0c0bf56482b394740f5c14326ae1586158813129 commit 0c0bf56482b394740f5c14326ae1586158813129 Author: Kevin Bowling AuthorDate: 2023-09-08 18:20:55 +0000 Commit: Kevin Bowling CommitDate: 2023-09-08 18:20:55 +0000 Mk/bsd.default-versions.mk: Update to PostgreSQL 15 PR: 273058 Exp-run by: antoine --- Mk/bsd.default-versions.mk | 2 +- UPDATING | 56 ++++++++++++++++++++++++++++++++++++++++++++++ 2 files changed, 57 insertions(+), 1 deletion(-) diff --git a/Mk/bsd.default-versions.mk b/Mk/bsd.default-versions.mk index 2a02ff95704f..5780cfe7c374 100644 --- a/Mk/bsd.default-versions.mk +++ b/Mk/bsd.default-versions.mk @@ -125,7 +125,7 @@ _EXPORTED_VARS+= _PERL5_FROM_BIN PERL5_DEFAULT:= ${_PERL5_FROM_BIN:R} . endif # Possible values: 11, 12, 13, 14, 15 -PGSQL_DEFAULT?= 13 +PGSQL_DEFAULT?= 15 # Possible values: 8.0, 8.1, 8.2, 8.3 PHP_DEFAULT?= 8.1 # Possible values: rust, legacy diff --git a/UPDATING b/UPDATING index 20f526787b7f..154adaceb34a 100644 --- a/UPDATING +++ b/UPDATING @@ -5,6 +5,62 @@ 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. +20230908: + 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 13 to 15. + 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 13, your + files are named according to this. + + # service postgresql stop + # pkg create postgresql13-server postgresql13-contrib + # mkdir /tmp/pg-upgrade + # tar xf postgresql13-server-13.12.pkg -C /tmp/pg-upgrade + # tar xf postgresql13-contrib-13.12.pkg -C /tmp/pg-upgrade + # pkg delete -f databases/postgresql13-server databases/postgresql13-contrib databases/postgresql13-client + + Now update PostgreSQL: + + pkg user: + # pkg install databases/postgresql15-server databases/postgresql15-contrib + # pkg upgrade + + Portmaster users: + # portmaster databases/postgresql15-server databases/postgresql15-contrib + # portmaster -a + + Portupgrade users: + # portinstall databases/postgresql15-server databases/postgresql15-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/data15 -U postgres" + # su -l postgres -c "pg_upgrade -b /tmp/pg-upgrade/usr/local/bin/ -d /var/db/postgres/data13/ -B /usr/local/bin/ -D /var/db/postgres/data15/ -U postgres " + + Now the migration is finished. You can start PostgreSQL again with: + + # service postgresql start + + ATTENTION: + 1) The default user changed from "pgsql" to "postgres" in 11. The migration steps above now assume + the "postgres" database user and FreeBSD user. + 2) See the updating entry 20190829 if you are updating from a release prior to 11. + 3) If you use non-default initdb options, you have to adjust the initdb-command accordingly + 20230906: AUTHOR: jrm@FreeBSD.org AFFECTS: users of sysutils/devcpu-data*