pg_upgradecluster version 10 to 16 question
<!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>
On 6/10/25 13:01, Jim Cunning wrote:
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.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.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?
1) Do:
man pg_upgradecluster
2) Assuming you used the PGDG repos to install Postgres you can do:
sudo apt install postgresql-10
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.
Thanks in advance.
--
Adrian Klaver
adrian.klaver@aklaver.com
On Tue, Jun 10, 2025 at 1:01 PM Jim Cunning <jlcunning46@gmail.com> wrote:
I obviously no longer have a running version 10 server,
You will need to correct this lack if you want to make use of version 10
data files.
David J.
On 6/10/25 13:14, Adrian Klaver wrote:
On 6/10/25 13:01, Jim Cunning wrote:
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.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.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?1) Do:
man pg_upgradecluster
2) Assuming you used the PGDG repos to install Postgres you can do:
sudo apt install postgresql-10
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.
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.
Thanks in advance.
--
Adrian Klaver
adrian.klaver@aklaver.com
<!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@aklaver.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>
On 6/11/25 11:59, Jim Cunning wrote:
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
Out of curiosity what where the unsatisfied dependencies?
--
Adrian Klaver
adrian.klaver@aklaver.com
On Wed, Jun 11, 2025 at 11:59:24AM -0700, Jim Cunning wrote:
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.
Uh, newer vesions of pg_dump should be able to dump from a PG 10
cluster.
---------------------------------------------------------------------------
On 6/10/25 13:17, Adrian Klaver wrote:
On 6/10/25 13:14, Adrian Klaver wrote:
On 6/10/25 13:01, Jim Cunning wrote:
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.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.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?1) Do:
man pg_upgradecluster
2) Assuming you used the PGDG repos to install Postgres you can do:
sudo apt install postgresql-10
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.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.Thanks in advance.
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com
Do not let urgent matters crowd out time for investment in the future.
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
I have lost the console output of the installation attempt, but I
believe there were two unsatisfied dependencies. One I think was a
glibc version mismatch, but I don't recall the version numbers. I
was in a hurry to find an installation solution, so I didn't spend
much time investigating the problem, and just moved on to an earlier
linux version that met my needs.<br>
<br>
<div class="moz-cite-prefix">On 6/11/25 12:10, Adrian Klaver wrote:<br>
</div>
<blockquote type="cite"
cite="mid:82adf898-857b-45c0-a6d7-cd2f9780c436@aklaver.com">On
6/11/25 11:59, Jim Cunning wrote:
<br>
<blockquote type="cite">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 </blockquote>
<br>
Out of curiosity what where the unsatisfied dependencies?
<br>
<br>
<br>
</blockquote>
<br>
</body>
</html>
On Wednesday, June 11, 2025, Bruce Momjian <bruce@momjian.us> wrote:
On Wed, Jun 11, 2025 at 11:59:24AM -0700, Jim Cunning wrote:
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 becauseof
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 usepg_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.
Uh, newer vesions of pg_dump should be able to dump from a PG 10
cluster.
A running cluster, yes. Apparently the PGDG packaging for PG10 is
incompatible with Kubuntu 24.04 thus no running cluster. It worked in
22.04. Given that PG10 was obsolete when 24.04 came out this isn’t a shock
to me.
David J.
On 6/11/25 12:53, Bruce Momjian wrote:
On Wed, Jun 11, 2025 at 11:59:24AM -0700, Jim Cunning wrote:
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.Uh, newer vesions of pg_dump should be able to dump from a PG 10
cluster.
The issue is the OP just had the $DATADIR and no Postgres 10 binaries to
run an instance.
--
Adrian Klaver
adrian.klaver@aklaver.com
On Wed, Jun 11, 2025 at 01:07:11PM -0700, David G. Johnston wrote:
On Wednesday, June 11, 2025, Bruce Momjian <bruce@momjian.us> wrote:
On Wed, Jun 11, 2025 at 11:59:24AM -0700, Jim Cunning wrote:
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 becauseof
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 usepg_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.
Uh, newer vesions of pg_dump should be able to dump from a PG 10
cluster.A running cluster, yes. Apparently the PGDG packaging for PG10 is incompatible
with Kubuntu 24.04 thus no running cluster. It worked in 22.04. Given that
PG10 was obsolete when 24.04 came out this isn’t a shock to me.
Oh, wow, yeah, good point.
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com
Do not let urgent matters crowd out time for investment in the future.
On 6/11/25 13:07, David G. Johnston wrote:
On Wednesday, June 11, 2025, Bruce Momjian <bruce@momjian.us
<mailto:bruce@momjian.us>> wrote:On Wed, Jun 11, 2025 at 11:59:24AM -0700, Jim Cunning wrote:
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.
Uh, newer vesions of pg_dump should be able to dump from a PG 10
cluster.A running cluster, yes. Apparently the PGDG packaging for PG10 is
incompatible with Kubuntu 24.04 thus no running cluster. It worked in
22.04. Given that PG10 was obsolete when 24.04 came out this isn’t a
shock to me.
That is what is confusing me.
This:
https://apt.postgresql.org/pub/repos/apt/dists/noble-pgdg/10/
indicates it is at least expected to install.
David J.
--
Adrian Klaver
adrian.klaver@aklaver.com