<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
I configured the PGDG repository and tried to install postgresql-10
on my kubuntu 24.04 LTS desktop system, but apt refused to install
it because of unsatisfied dependencies. I then installed kubuntu
22.04 LTS on a backup system and was able to install postgresql-10
there. I was able to use pg_dump to recover all the data and move
it to the replacement server running ubuntu 24.04 LTS with
postgresql-16. All should be good. Thanks for the help.<br>
<br>
<div class="moz-cite-prefix">On 6/10/25 13:17, Adrian Klaver wrote:<br>
</div>
<blockquote type="cite"
cite="mid:3183251c-4c06-490b-a0d7-8e2c6d0386e6(at)aklaver(dot)com">On
6/10/25 13:14, Adrian Klaver wrote:
<br>
<blockquote type="cite">On 6/10/25 13:01, Jim Cunning wrote:
<br>
<blockquote type="cite">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>
</blockquote>
<br>
1) Do:
<br>
<br>
man pg_upgradecluster
<br>
<br>
2) Assuming you used the PGDG repos to install Postgres you can
do:
<br>
<br>
sudo apt install postgresql-10
<br>
<br>
to get a Postgres 10 install. I would move the
/var/lib/postgresql/10/main you created out of the way and then
move the contents back in to the installed version.
<br>
</blockquote>
<br>
Forgot to say, be sure and retain a copy of the original 10
$DATADIR somewhere where you can fetch it should the above not
work as planned.
<br>
<br>
<blockquote type="cite">
<br>
<blockquote type="cite">
<br>
Thanks in advance.
<br>
<br>
</blockquote>
<br>
</blockquote>
<br>
</blockquote>
<br>
</body>
</html>