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 1ts2V3-00Dgbk-Iy for pgsql-general@arkaria.postgresql.org; Tue, 11 Mar 2025 16:30:37 +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 1ts2V2-00289f-AE for pgsql-general@arkaria.postgresql.org; Tue, 11 Mar 2025 16:30:36 +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 1ts2V1-00289W-VM for pgsql-general@lists.postgresql.org; Tue, 11 Mar 2025 16:30:35 +0000 Received: from ns7.gunduz.org ([165.232.104.158]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1ts2Uz-002G83-10 for pgsql-general@lists.postgresql.org; Tue, 11 Mar 2025 16:30:34 +0000 Received: from [127.0.0.1] (unknown [148.252.159.201]) (using TLSv1.3 with cipher TLS_AES_128_GCM_SHA256 (128/128 bits) key-exchange X25519 server-signature ECDSA (P-256) server-digest SHA256) (No client certificate requested) by ns7.gunduz.org (Postfix) with ESMTPSA id EA7C230001DC; Tue, 11 Mar 2025 16:30:30 +0000 (UTC) Date: Tue, 11 Mar 2025 16:30:29 +0000 From: =?ISO-8859-1?Q?Devrim_G=FCnd=FCz?= To: pgsql-general@lists.postgresql.org, Paul Foerster Subject: Re: Moving from Linux to Linux? User-Agent: K-9 Mail for Android In-Reply-To: <6E6059F6-E5A1-4A8D-8A5E-A41B921BBE67@gmail.com> References: <6E6059F6-E5A1-4A8D-8A5E-A41B921BBE67@gmail.com> Message-ID: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=----O625SYDW4KSBJ7G8ZLC6JKGGDYT4IE Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------O625SYDW4KSBJ7G8ZLC6JKGGDYT4IE Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Hi, (Sorry for the top posting) Streaming replication won't work between SLES and RHEL, mostly because of = glibc incompatibilities=2E Use logical replication=2E Regards, Devrim On 11 March 2025 16:22:26 GMT, Paul Foerster = wrote: >Hi, > >we are considering changing the PostgreSQL platform from SUSE SLE to Red = Hat=2E To keep service interruptions as short as possible, the idea is to s= et up a streaming replication from the SUSE server to be replaced to a temp= orary Red Hat server and then replace that SUSE server with the newly setup= Red Hat server=2E > >My idea is to set up a streaming replication for this=2E But this of cour= se only works if the data files would be binary compatible=2E > >So, I wonder, if this is possible=2E We have a lot of databases, some of = them need to be highly available and some are large too=2E > >Are there any obstacles that definitely make that a no-go? Do I risk corr= uption? It's both Linux, just a different distribution=2E > >Cheers, >Paul > ------O625SYDW4KSBJ7G8ZLC6JKGGDYT4IE Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable

Hi,

(Sorry for the top po= sting)

Streaming replication won't work between SLES and RHEL, mostl= y because of glibc incompatibilities=2E Use logical replication=2E

<= br>Regards, Devrim

On 11 March 2025 16:22:26 GMT, Paul Foerster <paul=2Efoerster@gmail=2E= com> wrote:

Hi,

we are considering chan=
ging the PostgreSQL platform from SUSE SLE to Red Hat=2E To keep service in=
terruptions as short as possible, the idea is to set up a streaming replica=
tion from the SUSE server to be replaced to a temporary Red Hat server and =
then replace that SUSE server with the newly setup Red Hat server=2E
My idea is to set up a streaming replication for this=2E But this of cours=
e only works if the data files would be binary compatible=2E

So, I w=
onder, if this is possible=2E We have a lot of databases, some of them need=
 to be highly available and some are large too=2E

Are there any obst=
acles that definitely make that a no-go? Do I risk corruption? It's both Li=
nux, just a different distribution=2E

Cheers,
Paul

<=
/pre>

------O625SYDW4KSBJ7G8ZLC6JKGGDYT4IE--