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 1ts5NX-00F3vf-AV for pgsql-general@arkaria.postgresql.org; Tue, 11 Mar 2025 19:35:03 +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 1ts5NV-005PiQ-4f for pgsql-general@arkaria.postgresql.org; Tue, 11 Mar 2025 19:35:01 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ts5NU-005PiI-Pt for pgsql-general@lists.postgresql.org; Tue, 11 Mar 2025 19:35:00 +0000 Received: from mail-oi1-x234.google.com ([2607:f8b0:4864:20::234]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1ts5NT-002HiE-01 for pgsql-general@lists.postgresql.org; Tue, 11 Mar 2025 19:34:59 +0000 Received: by mail-oi1-x234.google.com with SMTP id 5614622812f47-3f94b7bd964so1304862b6e.1 for ; Tue, 11 Mar 2025 12:34:59 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1741721698; x=1742326498; darn=lists.postgresql.org; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :from:to:cc:subject:date:message-id:reply-to; bh=g3zABSz/uOulyYUJGIZUdi0k1mqA2yL5BBCBEzTMzbs=; b=Ve9u6zCAOnHSMHtgN3jP0eZPBlD9cN9TR2dv1b9lPkIK+75v4JqlBIIAtTE4At2MlY VBN2uH/S5/AnYaNk/kn1piYRgxwYpD25jpY7jju9VOe647uDGD0inXKbqv8U80iZhCmD tZizgg4dXsaauR98HDJ3Q0nmCY3RRIqyfRyD4jr2vRX753hPsGp4TQcHep2hdSVKYbE+ yPK6MCxrba1g+UBHj/38oWzCyrOoeZtj693KBnjxiQKLiHgeBK4AWOdat7AVt9obqhaU ROwVJGK0FUWEky4hxETxU5wcK6r7AjboHd0HCeXNxuw70raIIrK4b2GVHBSaVtE+sE+n 1ruQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1741721698; x=1742326498; h=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=g3zABSz/uOulyYUJGIZUdi0k1mqA2yL5BBCBEzTMzbs=; b=p8muxm05fXRWfUE8pL95ge/0pu1pEXu8g8NZD4VIv5eiTBoPBO6f1rZK5BQ6ML+Qi1 xUza7fC27fIuSzfFSSE2nu4lmBfnNHgqAOuD5GF47IBDGOhsA05x1mk9W8cOqM5qNUc0 XuJ1HSsIa578O1XHMduMSoQJW+zcQLA1+4/L0OtszWiXRxlQZeiQ+N73Hw1LthyNXYSk 6e8PZKK2bPnQOnAvtQ79a9zWs18Y9wkClJz0Y5qDvcgMSq00lv53GGiC5inArmMqEbOU n3Jo8PC1RHHAzNI7m6FA/iCOOub6LoMxTxE+64ELNFGlfGEWZ50MiXK2N/M5OGRO6Umv +Wxg== X-Gm-Message-State: AOJu0YxSzz4uQa8N2QCvKsF/77HHj+D/U1s6AcUslFDUhh5xdTHzy+kx IKz3oPqen7XZQw11A20DtcHaIs1AMnPytfZaSjX42nziyzlDwjLHPu+UmJncGMBZuszc0PIVhYK l1I18/xG1AHGFKheqewEXa9MovrFLzA== X-Gm-Gg: ASbGncvHUjIBJEaTCcVsS5NyX3R9+C8pt0rYM2r7T+afbevSxY7VpBFln/lv9VWkP5I KI+GL2OoPssRDm3YCNUEjeNNpnoKsL6Dl+7vazcg3oUl+ZaKLDENxV6BSFt59GN70SBz2Pi5emu 4HU08CUZ+vD1oXbFm1D/v+arY5pT8GOv+UIW//G2hqKiO89k5+MVIbE9oUIDnjDqJiQ8B+FA== X-Google-Smtp-Source: AGHT+IEFfYyTJRfUQIwhbkFqiAP+AMDo4vLZXYn0RdZRTVvpH+rnoPPewyZi4jrQUDG1ZB/Wd1SGWF90fLVkGx1+ycc= X-Received: by 2002:a05:6808:1787:b0:3f8:1df6:404 with SMTP id 5614622812f47-3f81df607b7mr5830087b6e.8.1741721697696; Tue, 11 Mar 2025 12:34:57 -0700 (PDT) MIME-Version: 1.0 References: <6E6059F6-E5A1-4A8D-8A5E-A41B921BBE67@gmail.com> In-Reply-To: From: Ron Johnson Date: Tue, 11 Mar 2025 15:34:45 -0400 X-Gm-Features: AQ5f1JqcqK0wxTMKg5ttO5OiDrfF5FWsqWB9V-rcicew-FwTW6ma9JoDKJ4dFzY Message-ID: Subject: Re: Moving from Linux to Linux? To: Pgsql-General List Content-Type: multipart/alternative; boundary="00000000000016c4560630162f0b" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000016c4560630162f0b Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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 theory > 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. --=20 Death to , and butter sauce. Don't boil me, I'm still alive. lobster! --00000000000016c4560630162f0b Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Tue, Mar 11, 2025 at 2:35=E2=80=AFPM P= aul Foerster <paul.foerster@g= mail.com> wrote:
Hi Devrim, Thomas, Adr= ian, 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.

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'= ;m still alive.
<Redacted> lobster!
--00000000000016c4560630162f0b--