public inbox for [email protected]
help / color / mirror / Atom feedRe: pg_upgradecluster version 10 to 16 question
6+ messages / 4 participants
[nested] [flat]
* Re: pg_upgradecluster version 10 to 16 question
@ 2025-06-11 18:59 Jim Cunning <[email protected]>
2025-06-11 19:53 ` Re: pg_upgradecluster version 10 to 16 question Bruce Momjian <[email protected]>
0 siblings, 1 reply; 6+ messages in thread
From: Jim Cunning @ 2025-06-11 18:59 UTC (permalink / raw)
To: Adrian Klaver <[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>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: pg_upgradecluster version 10 to 16 question
2025-06-11 18:59 Re: pg_upgradecluster version 10 to 16 question Jim Cunning <[email protected]>
@ 2025-06-11 19:53 ` Bruce Momjian <[email protected]>
2025-06-11 20:07 ` Re: pg_upgradecluster version 10 to 16 question David G. Johnston <[email protected]>
2025-06-11 20:10 ` Re: pg_upgradecluster version 10 to 16 question Adrian Klaver <[email protected]>
0 siblings, 2 replies; 6+ messages in thread
From: Bruce Momjian @ 2025-06-11 19:53 UTC (permalink / raw)
To: Jim Cunning <[email protected]>; +Cc: Adrian Klaver <[email protected]>; [email protected]
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 <[email protected]> https://momjian.us
EDB https://enterprisedb.com
Do not let urgent matters crowd out time for investment in the future.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: pg_upgradecluster version 10 to 16 question
2025-06-11 18:59 Re: pg_upgradecluster version 10 to 16 question Jim Cunning <[email protected]>
2025-06-11 19:53 ` Re: pg_upgradecluster version 10 to 16 question Bruce Momjian <[email protected]>
@ 2025-06-11 20:07 ` David G. Johnston <[email protected]>
2025-06-11 20:11 ` Re: pg_upgradecluster version 10 to 16 question Bruce Momjian <[email protected]>
2025-06-11 20:14 ` Re: pg_upgradecluster version 10 to 16 question Adrian Klaver <[email protected]>
1 sibling, 2 replies; 6+ messages in thread
From: David G. Johnston @ 2025-06-11 20:07 UTC (permalink / raw)
To: Bruce Momjian <[email protected]>; +Cc: Jim Cunning <[email protected]>; Adrian Klaver <[email protected]>; [email protected] <[email protected]>
On Wednesday, June 11, 2025, Bruce Momjian <[email protected]> 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.
David J.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: pg_upgradecluster version 10 to 16 question
2025-06-11 18:59 Re: pg_upgradecluster version 10 to 16 question Jim Cunning <[email protected]>
2025-06-11 19:53 ` Re: pg_upgradecluster version 10 to 16 question Bruce Momjian <[email protected]>
2025-06-11 20:07 ` Re: pg_upgradecluster version 10 to 16 question David G. Johnston <[email protected]>
@ 2025-06-11 20:11 ` Bruce Momjian <[email protected]>
1 sibling, 0 replies; 6+ messages in thread
From: Bruce Momjian @ 2025-06-11 20:11 UTC (permalink / raw)
To: David G. Johnston <[email protected]>; +Cc: Jim Cunning <[email protected]>; Adrian Klaver <[email protected]>; [email protected] <[email protected]>
On Wed, Jun 11, 2025 at 01:07:11PM -0700, David G. Johnston wrote:
> On Wednesday, June 11, 2025, Bruce Momjian <[email protected]> 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.
Oh, wow, yeah, good point.
--
Bruce Momjian <[email protected]> https://momjian.us
EDB https://enterprisedb.com
Do not let urgent matters crowd out time for investment in the future.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: pg_upgradecluster version 10 to 16 question
2025-06-11 18:59 Re: pg_upgradecluster version 10 to 16 question Jim Cunning <[email protected]>
2025-06-11 19:53 ` Re: pg_upgradecluster version 10 to 16 question Bruce Momjian <[email protected]>
2025-06-11 20:07 ` Re: pg_upgradecluster version 10 to 16 question David G. Johnston <[email protected]>
@ 2025-06-11 20:14 ` Adrian Klaver <[email protected]>
1 sibling, 0 replies; 6+ messages in thread
From: Adrian Klaver @ 2025-06-11 20:14 UTC (permalink / raw)
To: David G. Johnston <[email protected]>; Bruce Momjian <[email protected]>; +Cc: Jim Cunning <[email protected]>; [email protected] <[email protected]>
On 6/11/25 13:07, David G. Johnston wrote:
> On Wednesday, June 11, 2025, Bruce Momjian <[email protected]
> <mailto:[email protected]>> 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
[email protected]
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: pg_upgradecluster version 10 to 16 question
2025-06-11 18:59 Re: pg_upgradecluster version 10 to 16 question Jim Cunning <[email protected]>
2025-06-11 19:53 ` Re: pg_upgradecluster version 10 to 16 question Bruce Momjian <[email protected]>
@ 2025-06-11 20:10 ` Adrian Klaver <[email protected]>
1 sibling, 0 replies; 6+ messages in thread
From: Adrian Klaver @ 2025-06-11 20:10 UTC (permalink / raw)
To: Bruce Momjian <[email protected]>; Jim Cunning <[email protected]>; +Cc: [email protected]
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
[email protected]
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2025-06-11 20:14 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-06-11 18:59 Re: pg_upgradecluster version 10 to 16 question Jim Cunning <[email protected]>
2025-06-11 19:53 ` Bruce Momjian <[email protected]>
2025-06-11 20:07 ` David G. Johnston <[email protected]>
2025-06-11 20:11 ` Bruce Momjian <[email protected]>
2025-06-11 20:14 ` Adrian Klaver <[email protected]>
2025-06-11 20:10 ` Adrian Klaver <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox