Re: To uninstall or not to uninstall that is...

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 upgrade 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

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

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