From nobody Sat Sep 9 04:40:57 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 4RjKzx0CXYz4s2yd; Sat, 9 Sep 2023 04:41:01 +0000 (UTC) (envelope-from cy.schubert@cschubert.com) Received: from omta002.cacentral1.a.cloudfilter.net (omta002.cacentral1.a.cloudfilter.net [3.97.99.33]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client CN "Client", Issuer "CA" (not verified)) by mx1.freebsd.org (Postfix) with ESMTPS id 4RjKzw4fxBz3dsT; Sat, 9 Sep 2023 04:41:00 +0000 (UTC) (envelope-from cy.schubert@cschubert.com) Authentication-Results: mx1.freebsd.org; none Received: from shw-obgw-4001a.ext.cloudfilter.net ([10.228.9.142]) by cmsmtp with ESMTP id egJ2qNT5Y6NwhepmFqY8F8; Sat, 09 Sep 2023 04:40:59 +0000 Received: from spqr.komquats.com ([70.66.152.170]) by cmsmtp with ESMTPA id epmDqKZESHFsOepmEqe2l6; Sat, 09 Sep 2023 04:40:59 +0000 X-Authority-Analysis: v=2.4 cv=XZqaca15 c=1 sm=1 tr=0 ts=64fbf75b a=y8EK/9tc/U6QY+pUhnbtgQ==:117 a=y8EK/9tc/U6QY+pUhnbtgQ==:17 a=kj9zAlcOel0A:10 a=zNV7Rl7Rt7sA:10 a=6I5d2MoRAAAA:8 a=YxBL1-UpAAAA:8 a=EkcXrb_YAAAA:8 a=6YQtcBVCNNt6GgF1LbgA:9 a=CjuIK1q_8ugA:10 a=IjZwj45LgO3ly-622nXo:22 a=Ia-lj3WSrqcvXOmTRaiG:22 a=LK5xJRSDVpKd5WXXoEvA:22 Received: from slippy.cwsent.com (slippy [10.1.1.91]) by spqr.komquats.com (Postfix) with ESMTP id 5DB355CE; Fri, 8 Sep 2023 21:40:57 -0700 (PDT) Received: by slippy.cwsent.com (Postfix, from userid 1000) id 25CD21CA; Fri, 8 Sep 2023 21:40:57 -0700 (PDT) X-Mailer: exmh version 2.9.0 11/07/2018 with nmh-1.8+dev Reply-to: Cy Schubert From: Cy Schubert X-os: FreeBSD X-Sender: cy@cwsent.com X-URL: http://www.cschubert.com/ To: Kevin Bowling cc: ports-committers@FreeBSD.org, dev-commits-ports-all@FreeBSD.org, dev-commits-ports-main@FreeBSD.org Subject: Re: git: 0c0bf56482b3 - main - Mk/bsd.default-versions.mk: Update to PostgreSQL 15 In-reply-to: <202309081822.388IMQsO057995@gitrepo.freebsd.org> References: <202309081822.388IMQsO057995@gitrepo.freebsd.org> Comments: In-reply-to Kevin Bowling message dated "Fri, 08 Sep 2023 18:22:26 +0000." 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=us-ascii Date: Fri, 08 Sep 2023 21:40:57 -0700 Message-Id: <20230909044057.25CD21CA@slippy.cwsent.com> X-CMAE-Envelope: MS4xfF7/+AVSqoAjOvopwx9EPzKCUjFSpNh+ijw+Vsyi3X55ag3vB0cNs1hwr2SIPWJF2DKGdx6gM7h+FJJw1sL1fgmQB8Hd4cR7bR/eQ6dm6hFvAiweLrtp JsB+WsqSe/Yyqrq+j1AAQxyft9O/biWec5uHnqYME5XICG8UOnqARCdeKLYHwIlaND2VFjCehKpuLxPOSYsECEjXp2bkRGHuJcIks5D0GJe50pcmE2Y2cz9F HGcwdAXywPVn4yaJPLUe/oSJ4ADpfom1aPCSYL835I8Y6OTBmgopia3VS7GnDWSRyJvddewxWziDGgcE9CS0smzzCmoZOX3IXaPX2yaYpvK4oZCy8Ut0BAvF LKdnZT2s X-Spamd-Bar: ---- X-Rspamd-Pre-Result: action=no action; module=replies; Message is reply to one we originated X-Spamd-Result: default: False [-4.00 / 15.00]; REPLY(-4.00)[]; ASN(0.00)[asn:16509, ipnet:3.96.0.0/15, country:US] X-Rspamd-Queue-Id: 4RjKzw4fxBz3dsT In message <202309081822.388IMQsO057995@gitrepo.freebsd.org>, Kevin Bowling wri tes: > The branch main has been updated by kbowling: > > URL: https://cgit.FreeBSD.org/ports/commit/?id=0c0bf56482b394740f5c14326ae158 > 6158813129 > > 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 PostgreSQ > L 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 dat > a. > + 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-contr > ib databases/postgresql13-client > + > + Now update PostgreSQL: > + > + pkg user: > + # pkg install databases/postgresql15-server databases/postgresql15-contr > ib > + # pkg upgrade > + > + Portmaster users: > + # portmaster databases/postgresql15-server databases/postgresql15-contri > b > + # portmaster -a > + > + Portupgrade users: > + # portinstall databases/postgresql15-server databases/postgresql15-contr > ib > + # 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 postgre > s " > + > + 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 migratio > n steps above now assume > + the "postgres" database user and FreeBSD user. > + 2) See the updating entry 20190829 if you are updating from a release prio > r to 11. > + 3) If you use non-default initdb options, you have to adjust the initdb-co > mmand accordingly > + > 20230906: > AUTHOR: jrm@FreeBSD.org > AFFECTS: users of sysutils/devcpu-data* > Thank you for the excellent UPDATING instructions. -- Cheers, Cy Schubert FreeBSD UNIX: Web: https://FreeBSD.org NTP: Web: https://nwtime.org e^(i*pi)+1=0