pg_upgradecluster version 10 to 16 question

From: Jim Cunning <jlcunning46(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: pg_upgradecluster version 10 to 16 question
Date: 2025-06-10 20:01:17
Message-ID: cb7713f2-8ff9-42eb-a3fa-a89c4dc8257a@gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

<!DOCTYPE html>
<html>
<head>

<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body>
I had a Ubuntu 20.04 LTS system with a postgresql version 10
database, and the system became unbootable.  The database was stored
in /var/lib/postgresql/10/main and I was able to recover the entire
contents of the data in that directory and below.  I now have a
system running ubuntu 24.04 LTS with postgresql version 16.<br>
<br>
I obviously no longer have a running version 10 server, so I cannot
use pg_dump to retrieve the data.  I have placed the recovered
version files in /var/lib/postgresql/10/main on my new system,
alongside the /var/lib/postgresql/16/main that was created when I
installed postgresql.  I have tried several iterations of the
pg_upgradecluster command, a Python script provided by Ubuntu, but
it says it cannot find the database files.<br>
<br>
I also see from the postgresql wiki pages that there is a pg_upgrade
utility program, but cannot find in any of the Ubuntu-provided
installation files.  Can anyone provide some guidance on how I might
proceed?<br>
<br>
Thanks in advance.<br>
<br>
</body>
</html>

Attachment Content-Type Size
unknown_filename text/html 1.2 KB

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2025-06-10 20:14:50 Re: pg_upgradecluster version 10 to 16 question
Previous Message Adrian Klaver 2025-06-10 16:03:48 Re: is pg_stat_activity "transactional"? How fast does it update?