public inbox for [email protected]
help / color / mirror / Atom feedFrom: Jim Cunning <[email protected]>
To: Adrian Klaver <[email protected]>
To: [email protected]
Subject: Re: pg_upgradecluster version 10 to 16 question
Date: Wed, 11 Jun 2025 11:59:24 -0700
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
<[email protected]>
<[email protected]>
<!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:[email protected]">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>
view thread (6+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: pg_upgradecluster version 10 to 16 question
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox