Message-ID: <2526a5dea2caece88ec6d73b4217d69cedc15d4d.camel@cybertec.at>
Subject: Re: Info regarding pg upgrade from 12.18 to 15.6
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Motog Plus <mplus7535@gmail.com>, pgsql-admin@lists.postgresql.org
Date: Fri, 27 Sep 2024 14:38:36 +0200
In-Reply-To: 
 <CAL5Gnisd1zZ54HATHoLvV4h5FtLnsfejq_phN7E2+3W=WCwNDw@mail.gmail.com>
References: 
	<CAL5Gnisd1zZ54HATHoLvV4h5FtLnsfejq_phN7E2+3W=WCwNDw@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.52.4 (3.52.4-1.fc40) 
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/2526a5dea2caece88ec6d73b4217d69cedc15d4d.camel%40cybertec.at>
Precedence: bulk

On Fri, 2024-09-27 at 16:55 +0530, Motog Plus wrote:
> We are upgrading postgres from 12.18 to 15.6. Can you please advise how c=
an I check on the below points?
> 1. Compatibility between postgreSQL 15.6 and:
> =C2=A0 =C2=A0 =C2=A0- Springboot(3.3..x)
> =C2=A0 =C2=A0 =C2=A0- Java(17)
> =C2=A0 =C2=A0 =C2=A0- JPA
> =C2=A0 =C2=A0 =C2=A0- Hikari pool
> =C2=A0 =C2=A0 =C2=A0- pgpool II

Check the documentation of these programs to see if they support PostgreSQL=
 v15.

But the most important part is that you test your applications thoroughly.
Even if all the software on your stack supports PostgreSQL v15, it is
conceivable that your program does something with the database that changed
in an incompatible fashion.

It is instructive to read the "migration" section of the release notes
for the PostgreSQL major releases, but there is no way for you to avoid
testing your program.

Yours,
Laurenz Albe