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 1ts6XT-00FDKM-K3 for pgsql-general@arkaria.postgresql.org; Tue, 11 Mar 2025 20:49:23 +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 1ts6XS-006h8g-7d for pgsql-general@arkaria.postgresql.org; Tue, 11 Mar 2025 20:49:22 +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 1ts6XR-006h8X-Rn for pgsql-general@lists.postgresql.org; Tue, 11 Mar 2025 20:49:21 +0000 Received: from mail-ej1-x635.google.com ([2a00:1450:4864:20::635]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1ts6XN-002IsH-2q for pgsql-general@lists.postgresql.org; Tue, 11 Mar 2025 20:49:21 +0000 Received: by mail-ej1-x635.google.com with SMTP id a640c23a62f3a-ac297cbe017so47278666b.0 for ; Tue, 11 Mar 2025 13:49:18 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1741726157; x=1742330957; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=DcXOCVVDdxlCRKinw9kR5NqklQXS28S1zXN3+CckVsU=; b=Jkg0Z0IYZT1st8mur2gs8wZ758YIBdlvtwH7MDGxdpDUwXNey0Uuvd6lAphQanWsUN 1F9T22SN61NEopxqH9SknB1sFu2RMlQ/w/MdU3E6V3osJoJViNb3GdwkoT+4/r0jJ1A6 82HoQD1ByF0Gg07Z8DJkp2atyRliOpO4py8maokT/4TXHcoASazgCBCpHB/hdKLTICP1 61mf7caDb88+E/CA+6xoqdOevrMdrdl1U5cgM2gnm5w4KECiX8xQBjRKVOPP+ZfEtp6A gLhUNbIJH482z2W4MwEymbbK7wCGadoVYpxh1JZEijppqBsiYjd5qJFmFPDgdW5FSFVk jlPQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1741726157; x=1742330957; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=DcXOCVVDdxlCRKinw9kR5NqklQXS28S1zXN3+CckVsU=; b=VTcSs8MhJVQTTczIYQqZcQWdrtiH7poPiNKFRFSlsmF1YruQLGAAwGW608vOR18ibD wOIjuY8fNGLkWLoSokfuD4PDHa7+vPx0XsMOsMAjV4G1owkFcJtFLoGPfFVmgTfULj7i CeDe00uX7i3H5k4HX9/rDneVEqtcPKq8lVEl42xWz+sqBSLK9/UmWOPOhywDUqjWMgxY BeN6kJ6T6hj8JnLoCmzf6DDoKDXrLfQVHKcfjpqy5kbIJqVbe3K4RkkBYrCsn+a0jhNC BuUxLw7TyQJRSoUxYGfb+xV82yvpsuMaEgxjBexfNXtv8mSuejcIVJpwWo0LsT3BKcyy CutA== X-Gm-Message-State: AOJu0YyKfItfGn49WWEm8DO4yRha/yRcZeiWf3h/VWnLPkCO5oMf53dW YNKpAgGUQakSoCO0gdRshze99duEjxuTs638OdiGfKjvOSsE78DckLdaDb9L1jnRfGpg2R1eTSA S4vtsDHE/TzNYuZUA4m+gq3hEIDg= X-Gm-Gg: ASbGnctzES59ygpBAbPklVal+UidQn3IaXuiu32QRcLtWwCvZ9hUr23Vs7Zg1L6dr4W vJM1yvNDpdog49X3lpljh4M1iJYCK0WaTzdS79I0UIbi2ujvhDl0A5uiMfHV24fSvkDnaaEwm5V AE6MLbaVfGBIfEoyakJs+t51WKxEF0zJa43puXWlIz6ZM= X-Google-Smtp-Source: AGHT+IE7HKQclZ2hFnZPnGY7+n5AXJPxMU1nPDmq58choIvOwGhf/7FG8Nhi3Ue07U7YCeovWCvVTgnsublHHM58AEA= X-Received: by 2002:a17:906:340b:b0:ac2:4f30:5033 with SMTP id a640c23a62f3a-ac2ba4ec6d5mr602141766b.15.1741726157064; Tue, 11 Mar 2025 13:49:17 -0700 (PDT) MIME-Version: 1.0 References: <6E6059F6-E5A1-4A8D-8A5E-A41B921BBE67@gmail.com> In-Reply-To: From: Thomas Boussekey Date: Tue, 11 Mar 2025 21:49:05 +0100 X-Gm-Features: AQ5f1Jq4Old3BamVx9dim-170JnTQq3fcmtJRX4ELFS1EMQWZxNMg1Kam-v5rmg Message-ID: Subject: Re: Moving from Linux to Linux? To: Ron Johnson Cc: Pgsql-General List Content-Type: multipart/alternative; boundary="000000000000e354360630173889" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000e354360630173889 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Le mar. 11 mars 2025 =C3=A0 20:35, Ron Johnson a =C3=A9crit : > On Tue, Mar 11, 2025 at 2:35=E2=80=AFPM Paul Foerster > wrote: > >> Hi Devrim, Thomas, Adrian, Ron, Joe, >> >> answering to myself as answering to five postings in one go is >> impossible. =F0=9F=A4=A3 >> >> > Are there any obstacles that definitely make that a no-go? Do I risk >> corruption? It's both Linux, just a different distribution. >> >> The question was a bit of an idea. So the glibc version in not known yet= , >> but I'm highly confident that they will differ. A reindex could in theor= y >> be possible in most cases, but is a definite show stopper on some of our >> databases, because it would mean too much application downtime. >> >> So, it's either logical replication or close to impossible. >> > > If you don't do much DDL, the LR should be quite workable. > Stop DDL during the copy process is mandatory, but there are so other restrictions to consider also (large objects, sequences...), see this page for an exhaustive list: https://www.postgresql.org/docs/current/logical-replication-restrictions.ht= ml > > -- > Death to , and butter sauce. > Don't boil me, I'm still alive. > lobster! > --000000000000e354360630173889 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable


Le=C2=A0mar. 11 mars 2025 =C3=A0=C2=A020:35, Ron Johnson <ronljohnsonjr@gmail.com> a =C3= =A9crit=C2=A0:
<= div dir=3D"ltr">
On Tue, Mar 11, 2025 at 2:35=E2=80=AFPM Pa= ul Foerster <paul.foerster@gmail.com> wrote:
Hi Devrim, Thomas, Adrian, = Ron, Joe,

answering to myself as answering to five postings in one go is impossible. = =F0=9F=A4=A3

> Are there any obstacles that definitely make that a no-go? Do I risk c= orruption? It's both Linux, just a different distribution.

The question was a bit of an idea. So the glibc version in not known yet, b= ut I'm highly confident that they will differ. A reindex could in theor= y be possible in most cases, but is a definite show stopper on some of our = databases, because it would mean too much application downtime.

So, it's either logical replication or close to impossible.

If you don't do much DDL, the LR should be qui= te workable.
Stop DDL d= uring the copy process is mandatory, but there are so other restrictions to= consider also (large objects, sequences...), see this page for an exhausti= ve list:
https://www.postgresql.o= rg/docs/current/logical-replication-restrictions.html=C2=A0

--
Death to <Redacted>, and butter sauce.
Don't boil me, I&#= 39;m still alive.
<Redacted> lobster!
<= /div>
--000000000000e354360630173889--