Message-ID: <c3eb27eaf33d223c1773208ef6af87191c57b188.camel@cybertec.at>
Subject: Re: fail to run postgresql16 after update from postgresql13
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Ianseeks <bingmybong@btinternet.com>, pgsql-novice@lists.postgresql.org
Date: Thu, 02 Nov 2023 15:27:34 +0100
In-Reply-To: <5997577.lOV4Wx5bFT@lian-li>
References: <4842483.GXAFRqVoOG@lian-li>
	 <a45642cc5574077ea57536812273bd10ae4bd1c5.camel@cybertec.at>
	 <5997577.lOV4Wx5bFT@lian-li>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.48.4 (3.48.4-1.fc38) 
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/c3eb27eaf33d223c1773208ef6af87191c57b188.camel%40cybertec.at>
Precedence: bulk

On Thu, 2023-11-02 at 11:13 +0000, Ianseeks wrote:
> On Thursday, 2 November 2023 10:16:33 GMT Laurenz Albe wrote:
>=20
> > > I can't get Akonadi to load as it fails to start postgresql16, its fa=
iling
> > > with a message saying it needs postgesql9.6 as the DB was originally
> > > created using 9.6. I can't see why it insists on ver 9.6 being there =
as
> > > i've updated to ver 16 and that process means i create an empty DB.  =
I
> > > can't even install Ver 9.6 to see if that cures the problem as its no
> > > longer in the opensuse repos.
> > >=20
> > > This is from "systemctl status postgresql.service"
> > >=20
> > > Oct 31 16:24:13 Lian-Li systemd[1]: Starting PostgreSQL database serv=
er...
> > > Oct 31 16:24:13 Lian-Li postgresql-script[5916]:  Your database files=
 were created by PostgreSQL version 9.6.
> >=20
> > These error messages are not from PostgreSQL, but they seem to be from
> > the script "postgresql-script".  That script is not part of PostgreSQL.
> >=20
> > Look into that script and try to figure out how it arrives at that
> > conclusion. If you cannot figure it out yourself, please share the rele=
vant
> > parts.
>=20
> Is it acceptable to attach text files to email in this mailing list?  I k=
now=20
> some don't like it.
> I've found the script file (/usr/share/postgresql/postgresql-script) and =
that=20
> message is in there but the coding in it is beyond my expertise as i can =
only=20
> do basic stuff.
> Here is a cut and paste of part of it.
>=20
> ----- /usr/share/postgresql/postgresql-script ----
>=20
> PG_SYSCONFIG=3D/etc/sysconfig/postgresql
> test -f $PG_SYSCONFIG && . $PG_SYSCONFIG

Look into "/etc/sysconfig/postgresql" and see if it sets POSTGRES_DATADIR.

> eval DATADIR=3D${POSTGRES_DATADIR:-~postgres/data}

If not, DATADIR is set to the subdirectory "data" of the home directory
of user "postgres".

Is DATADIR the data directory you upgraded?

> OPTIONS=3D${POSTGRES_OPTIONS}
> INITDB_OPTS=3D${POSTGRES_INITDB_OPTS}
> PIDFILE=3D$DATADIR/postmaster.pid
>=20
> #=20
> if test -r $DATADIR/PG_VERSION ; then
>     DATA_VERSION=3D$(cat $DATADIR/PG_VERSION)
>     POSTGRES=3D/usr/lib/postgresql$(echo -n $DATA_VERSION | tr -d .)/bin/=
postgres
> fi

DATA_VERSION is set to the first line in the PG_VERSION file in DATADIR.

What is that?  According to the error message, it should be 9.6.

POSTGRES is set to /usr/lib/postgresql<DATA_VERSION with periods removed>/b=
in/postgres

> if test -x /usr/bin/postgres; then
>     ACTIVE=3D$(readlink -q -f /usr/bin/postgres)
>     test -z "$POSTGRES" && POSTGRES=3D"$ACTIVE"
> fi
> if test -n "$DATA_VERSION"; then
>     if test -z "$ACTIVE" -o "$ACTIVE" !=3D "$POSTGRES"; then
> 	echo " Your database files were created by PostgreSQL version $DATA_VERS=
ION."

Looks like /usr/bin/postgres, if you resolve the symbolic link, is differen=
t
from POSTGRES constructed above.

Yours,
Laurenz Albe