Re: git: 0c0bf56482b3 - main - Mk/bsd.default-versions.mk: Update to PostgreSQL 15

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 <kbowling@FreeBSD.org>
> AuthorDate: 2023-09-08 18:20:55 +0000
> Commit:     Kevin Bowling <kbowling@FreeBSD.org>
> 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 <Cy.Schubert@cschubert.com>
FreeBSD UNIX:  <cy@FreeBSD.org>   Web:  https://FreeBSD.org
NTP:           <cy@nwtime.org>    Web:  https://nwtime.org

			e^(i*pi)+1=0