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 1u8JuO-000yhL-8w for pgsql-general@arkaria.postgresql.org; Fri, 25 Apr 2025 14:20:04 +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 1u8JuM-00Btki-Ii for pgsql-general@arkaria.postgresql.org; Fri, 25 Apr 2025 14:20:03 +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 1u8JuM-00BtkZ-7x for pgsql-general@lists.postgresql.org; Fri, 25 Apr 2025 14:20:03 +0000 Received: from cloud.gatewaynet.com ([185.90.37.94]) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1u8JuK-001tzv-2x for pgsql-general@lists.postgresql.org; Fri, 25 Apr 2025 14:20:02 +0000 Content-Type: multipart/alternative; boundary="------------jcAI6VTl6vUtk1H2fWEtGMmX" Message-ID: Date: Fri, 25 Apr 2025 15:19:58 +0100 MIME-Version: 1.0 Subject: Re: replication To: pgsql-general@lists.postgresql.org References: Content-Language: en-US From: Achilleas Mantzios - cloud In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------jcAI6VTl6vUtk1H2fWEtGMmX Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit On 4/25/25 14:50, Marc Millas wrote: > Hello, > > > One of my customers tells me he did a replication with the master on a > debian 10 > and the slave on a debian 12, both with a pg13.20, one on a pgdg110+1, > the other a pgdg120.1 > > is this a good idea ??? (I don't think so...) Sorry I dont quite get the pgdg110 vs pgdg120 distinction I guess they each support a different release of debian, but using the same architecture (e.g. amd64), same on disk structure structure , same PostgreSQL major version is a minimum for physical replication and you are 100% safe with that. In order to be more flexible your client might want to try logical replication which lifts any of the restrictions mentioned above (if applicable) and even allows near zero-time upgrades. > > thanks, > > > Marc MILLAS > Senior Architect > +33607850334 > > --------------jcAI6VTl6vUtk1H2fWEtGMmX Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit

On 4/25/25 14:50, Marc Millas wrote:

Hello,

One of my customers tells me he did a replication with the master on a debian 10

and the slave on a debian 12, both with a pg13.20, one on a pgdg110+1, the other a pgdg120.1

is this a good idea ??? (I don't think so...)

Sorry I dont quite get the pgdg110 vs pgdg120 distinction I guess they each support a different release of debian, but using the same architecture (e.g. amd64), same on disk structure structure , same PostgreSQL major version is a minimum for physical replication and you are 100% safe with that.

In order to be more flexible your client might want to try logical replication which lifts any of the restrictions mentioned above (if applicable) and even allows near zero-time upgrades.

thanks,

Marc MILLAS
Senior Architect

+33607850334

--------------jcAI6VTl6vUtk1H2fWEtGMmX--