Date: Sat, 4 Jan 2025 12:47:17 +0100
From: "Peter J. Holzer" <hjp-pgsql@hjp.at>
To: pgsql-general@lists.postgresql.org
Subject: Re: To uninstall or not to uninstall that is...
Message-ID: <20250104114717.44xaqmpuz2nrmhky@hjp.at>
Mail-Followup-To: pgsql-general@lists.postgresql.org
References: <BYAPR12MB2808A96CACDED340EDC88B79BA162@BYAPR12MB2808.namprd12.prod.outlook.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="jlgt2fanp4xs7lrz"
Content-Disposition: inline
In-Reply-To: <BYAPR12MB2808A96CACDED340EDC88B79BA162@BYAPR12MB2808.namprd12.prod.outlook.com>
Archived-At: <https://www.postgresql.org/message-id/20250104114717.44xaqmpuz2nrmhky%40hjp.at>
Precedence: bulk


--jlgt2fanp4xs7lrz
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On 2025-01-04 06:08:58 -0500, Arbol One wrote:
> In my Debian 12 machine, I have PostgreSQL-15 installed; I'd like to upgr=
ade to
> PostgreSQL-16. Should I first uninstalled PostgreSQL-15 and then install
> PostgreSQL-16 or is there a way to just do an upgrade?

How did you install it? Package from the Debian repo, package from the
PGDG repo or something else?

The packages from the repos are designed to be installed in parallel and
upgraded via pg_upgrade. There is a utility script "pg_upgradecluster"
to aid in this.

So the typical procedure is=20

1) Install new version
2) Drop the new (empty) database
3) Invoke pg_upgradecluster (see man-page for details)
4) Check that everything is ok
5) Drop old database and uninstall old version.

        hp

--=20
   _  | Peter J. Holzer    | Story must make more sense than reality.
|_|_) |                    |
| |   | hjp@hjp.at         |    -- Charles Stross, "Creative writing
__/   | http://www.hjp.at/ |       challenge!"

--jlgt2fanp4xs7lrz
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----

iQIzBAABCgAdFiEETtJbRjyPwVTYGJ5k8g5IURL+KF0FAmd5H78ACgkQ8g5IURL+
KF1ORQ/+MU9my5T/QURgTweRKiDGO5EEZ+sISR0uZQCdRqMvsVLVU0UbG17BQ+uC
DSmxVFMuWaByOKG0kznepF8AIvofLO2buX8QHFWl0oyJjzbsP+Dih6lmLtHhLjjj
I0vMmm75VCiNaT+N/pWpd0SOdFnJMY+veePzEtRjwo1kwWIpSrerq0BAbg7KJ869
RWwkrBhVQiSugs66fisH6j/jVULmtvGyJ+NdZt+2ejqoMiO/AEeG7M87r2LgbSA6
anoNbfvPpiBz2veVziXw8fUdwnbcZk5OXZ8BZATkobrme2f88pY2WBtouBjUVQFb
J1CzW3oHpfT2CwIljvIVRxEhZNIELF44xIDHksKBPuenuuPXa5p9XqCzcYqllkll
N7ucIlDQt14kDZNp80vb3nu+9qVVC4hZusPrtELtaFeEKybNsh25ZeHTv5fvB7rt
s4M3/6zDeUtTKYSr5/6J69sawLk+soei0xyzdL/lTITa2zWCLbNw0cItyRY8pvnH
EMsgrvtMkH6zMA0tfU5FhioecG0sVlOlMqxwgX5t8Z90hspwE2mcV1eGgqTYnsZF
IO4onJGb1gy52yAkDF3uMMZKn64tsZBWU6Wiv2oqJw6+PTpMqKSFe4EKPVfRj9UI
fC+FaD8mFU9csQ4OmxG/j9afU1SxuVlQCk7yrvKjvmQeHdMjhTQ=
=Uzsm
-----END PGP SIGNATURE-----

--jlgt2fanp4xs7lrz--