pg_upgradecluster version 10 to 16 question

[Jim Cunning]

  
  
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?

Thanks in advance.

  

Re: pg_upgradecluster version 10 to 16 question

[Jim Cunning]

  
  
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.

On 6/11/25 12:10, Adrian Klaver wrote:

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?
  
  
  


  

Re: pg_upgradecluster version 10 to 16 question

[Jim Cunning]

  
  
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.

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.