Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uPRjB-008BLl-9x for pgsql-general@arkaria.postgresql.org; Wed, 11 Jun 2025 20:07:17 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1uPRj9-006F9j-AZ for pgsql-general@arkaria.postgresql.org; Wed, 11 Jun 2025 20:07:15 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uPRj8-006F9b-W2 for pgsql-general@lists.postgresql.org; Wed, 11 Jun 2025 20:07:15 +0000 Received: from mail-ot1-x329.google.com ([2607:f8b0:4864:20::329]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uPRj8-001W2k-0G for pgsql-general@lists.postgresql.org; Wed, 11 Jun 2025 20:07:15 +0000 Received: by mail-ot1-x329.google.com with SMTP id 46e09a7af769-7382ffcb373so135284a34.0 for ; Wed, 11 Jun 2025 13:07:13 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1749672432; x=1750277232; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=0WzhT+bCsSa5hqiDewLOYRdhw4tKEyG5G9ApIyXyDsA=; b=JQPOsvt74ROJY4t6DXEP+YtLzPVbP4UdOcCKldGf0FtqEpwTGUgFZ1YWcokyQLwBgc H0NvplGKZ2HHSQiwaOOy3JNO1sUoa7uJu0UirJslYsx+hWkkFqikOnUhY6hIHi02AFwH gqE1xL4TKb8y8Ce2Jm9SE1o3hDxt5TUK9WyfBUFQb90fQ04csxNHzTifMQfzQjeQju0i gt2fwQRllQt9CLpFX2NGuTY/onaU87RlLY9FGQus/kRABNYJc+f7axDfv6xOunM4Fu0D Vimld3aMZ6VhGrebz6tsDIRJEQJ7BrLxEmpdwxFVdCbRqLyJA+W0ZBQM1zKmbipHalQ2 rMGw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1749672432; x=1750277232; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=0WzhT+bCsSa5hqiDewLOYRdhw4tKEyG5G9ApIyXyDsA=; b=Ur2uTDPkzuL6RFj/rTcX3mM6fTBYexb1QQUig3KSBrhe/VWpvs9FnJgH9Mlm79/hDG K1J/k/ZIH7jg/ou/WMSGD+NPFjY1BLqakc6KAVLWD9UTYg0eD74whfTYLkCMJIwugkXj YcHPKm+H/hpyw6BHlRzOWJ3khwTo7DWrhuds0RBHYTNazTaX/6ceuN4Q4I5r76Bz2ATp cuqm3o566Yhm3P0Aiqvc5VWmp8HofoA+Ahx4dziVheIF/EO73TKEDGdjcpTvPLrTQlKl CP5RPoNs7Ark/B5fpCmxhrev63ojjXNR4ruPbHgzYrZWy4dE/GA1w8g3rcIWIn4JmtDv xK1A== X-Forwarded-Encrypted: i=1; AJvYcCU62/8JtHDwElUcz4REL94eOCLomBAZQ5+2o9p8Scr8wtDw1r9cNwfBYiokcs+g/5/ZTK/RB7cgW7Hq0ibb@lists.postgresql.org X-Gm-Message-State: AOJu0YwjOO0sq1PzLxfNPWMuVGo7N7mv52R1L+0qNzXFXLzhjVso0WQ5 yajFxCexGGoPdVBveurssURZzrBZcIxwjrAYSPAK+yLocGsmT/7l4hZtjehTfmeYtmOfk4S+fsc 46J3Ai38/QsXswED6OWoQbCAATDUucf4= X-Gm-Gg: ASbGnctNRNIwM89gSEhEJ8o1/KTDScmKNBeGalESWXdTvLCubQziWbS/keLXLNdHsBU todP7NKWgClvjuH1kcvKFEyuiRWVvV3lcrI3NM9TZbo/0wTXsfQDyi8pD4hM8xRcUmNpLGj2RrZ cUgyK4zdGajz90rzuCArkrr4gPlwf0NhpYzQf2RQjuz8Ow7PgQeC6XCiuqfKDzaV7Qi+al6l3AK dJX X-Google-Smtp-Source: AGHT+IHyG4oSj4WPAi7ecIdWWuDL2HXloi4g6wIMiXhKd0IwTQgZs6fpwHbglV1AVkDR+umPiBFbRtk0nKh6vN2H1wM= X-Received: by 2002:a05:6870:51cf:b0:2d5:246d:4b67 with SMTP id 586e51a60fabf-2ea96e5040amr2231402fac.24.1749672431927; Wed, 11 Jun 2025 13:07:11 -0700 (PDT) MIME-Version: 1.0 Received: by 2002:ac9:7fd2:0:b0:5c9:f01c:52e7 with HTTP; Wed, 11 Jun 2025 13:07:11 -0700 (PDT) In-Reply-To: References: <98182efc-eb12-42f0-8016-01163b5c6fcb@aklaver.com> <3183251c-4c06-490b-a0d7-8e2c6d0386e6@aklaver.com> From: "David G. Johnston" Date: Wed, 11 Jun 2025 13:07:11 -0700 X-Gm-Features: AX0GCFuOQBzp2ZL6bV5HKFKcCrNSYOFlEKJxlZBuZaY9fYHZOu1OQWO_e7pFqBA Message-ID: Subject: Re: pg_upgradecluster version 10 to 16 question To: Bruce Momjian Cc: Jim Cunning , Adrian Klaver , "pgsql-general@lists.postgresql.org" Content-Type: multipart/alternative; boundary="000000000000c7468b0637515bec" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000c7468b0637515bec Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Wednesday, June 11, 2025, 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 back= up > > 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=E2=80=99t= a shock to me. David J. --000000000000c7468b0637515bec Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Wednesday, June 11, 2025, Bruce Momjian <bruce@momjian.us> wrote:
O= n 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 becaus= e of
> unsatisfied dependencies.=C2=A0 I then installed kubuntu 22.04 LTS on = a backup
> system and was able to install postgresql-10 there.=C2=A0 I was able t= o use pg_dump
> to recover all the data and move it to the replacement server running = ubuntu
> 24.04 LTS with postgresql-16.=C2=A0 All should be good.=C2=A0 Thanks f= or the help.

Uh, newer vesions of pg_dump should be able to dump from a PG 10
cluster.


A running cluster, yes.=C2=A0 Apparently t= he PGDG packaging for PG10 is incompatible with Kubuntu 24.04 thus no runni= ng cluster.=C2=A0 It worked in 22.04.=C2=A0 Given that PG10 was obsolete wh= en 24.04 came out this isn=E2=80=99t a shock to me.

David J.

--000000000000c7468b0637515bec--