On 2026/07/08 10:26, Olivier Cherrier wrote: > Hello, > > While upgrading using method 1 (dump / restore), > the 'postgresql-pg_upgrade' pkg is not installed. > > Please see attached patch. > @@ -120,7 +120,7 @@ Examine your old file for local changes > (/var/postgresql/data/postgresql.conf). The following command may help > identify them: > > -# diff -wu ${LOCALBASE}/share/postgresql-${PREV_MAJOR}/postgresql.conf.sample \ > +# diff -wu ${LOCALBASE}/share/postgresql/postgresql.conf.sample \ > /var/postgresql/data-${PREV_MAJOR}/postgresql.conf It's probably better to install postgresql-pg_upgrade. This will allow comparing the live config file against a default one with fewer differences as it's from a more similar version. e.g. Index: Makefile =================================================================== RCS file: /cvs/ports/databases/postgresql/Makefile,v diff -u -p -r1.319 Makefile --- Makefile 25 May 2026 00:36:13 -0000 1.319 +++ Makefile 8 Jul 2026 10:14:17 -0000 @@ -10,6 +10,8 @@ PREV_MAJOR= 17 DISTNAME= postgresql-${VERSION} PKGNAME-main= postgresql-client-${VERSION} +REVISION-server=0 + DPB_PROPERTIES= parallel CATEGORIES= databases Index: pkg/README-server =================================================================== RCS file: /cvs/ports/databases/postgresql/pkg/README-server,v diff -u -p -r1.39 README-server --- pkg/README-server 22 Jan 2026 01:24:20 -0000 1.39 +++ pkg/README-server 8 Jul 2026 10:14:17 -0000 @@ -97,8 +97,11 @@ to the current version. 2) Shutdown the server: # rcctl stop postgresql -3) Upgrade your PostgreSQL package with pkg_add. +3) Upgrade your PostgreSQL package with pkg_add. Even though you're not +using pg_upgrade for the update, install it to provide an unmodified +configuration file from a closer version for step 6. # pkg_add -ui postgresql-server +# pkg_add postgresql-pg_upgrade 4) Backup your old data directory and rename: # cd /var/postgresql && tar cf - data | gzip -1 > data.tar.gz @@ -144,7 +147,7 @@ faster than a dump and reload, especiall enabled by default until PostgreSQL 18): # su _postgresql -c '/usr/local/bin/pg_checksums -e -D /var/postgresql/data' -3) Upgrade your PostgreSQL package with pkg_add. +3) Install the PostgreSQL pg_upgrade package with pkg_add. # pkg_add postgresql-pg_upgrade 4) Backup your old data directory:
No comments:
Post a Comment