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 1t4okU-002Mj6-Ii for pgsql-general@arkaria.postgresql.org; Sat, 26 Oct 2024 21:55:06 +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 1t4okS-00C4kP-8G for pgsql-general@arkaria.postgresql.org; Sat, 26 Oct 2024 21:55:04 +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 1t4okR-00C4kG-Sp for pgsql-general@lists.postgresql.org; Sat, 26 Oct 2024 21:55:04 +0000 Received: from mail-oa1-x2a.google.com ([2001:4860:4864:20::2a]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1t4okP-0030x8-Dc for pgsql-general@postgresql.org; Sat, 26 Oct 2024 21:55:02 +0000 Received: by mail-oa1-x2a.google.com with SMTP id 586e51a60fabf-28862804c9dso1637768fac.0 for ; Sat, 26 Oct 2024 14:55:01 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1729979700; x=1730584500; darn=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=jEZEySgv9N2lglZMPdcDNNNGw3BtegI5e9P5uR9Udu4=; b=WzJbl1hWPBbaWGrUXs4y1T7XdekmgFWECQhYu7tY6LFO1xmLQFQ07mNOJLQa1/TFX2 7DVFTN92BtXg8AWPXctqLo1WNWBAbB2v88otAcswjQsz3rN+qlzsmspgFQgF50j0Iazy JojeGV9WKoU4UHZvBZyfB33Py+ZFgjKFqhkRreim/rAhkHhg3DhP+6kUEJtobhgPM5yk fFAEvjBcEvQ/RP81bZSapwD1Pq2Nc1eep+6tF+1iYXTEVfkDeLGrhQKtjPxkIG2TLgV5 Gn45edoER5efoZpzA7/xOS2Rf2R4PQedK029AlvfDoRH6YZR9VjfKh3ZsLb57E9ztmn5 Ejtg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1729979700; x=1730584500; 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=jEZEySgv9N2lglZMPdcDNNNGw3BtegI5e9P5uR9Udu4=; b=Pw/+apzEvNxIiwlt+iykKHIHO6CHTf9/U638gb1Hufu1XWhcMYs+3KvHW/07EZilJ4 fZnPraZ2LOUMn8xWKnEr9sGhs4tyuAN3318lg4Uann1zRO1tjLYKLPi2fof/AiaImBKa TK6YvpzRDhoRANoBVmjoGxEdPVsV/X/uFfZyhTjw/ncPRdfjky5BO3bqBn8ZnWhcyT0d D/sU7Ious+ruDRISwOVLqlKF6u3tsWLkZ2mcTUq6Z/xXUfbX3i3YgM/ypzDkkLejHj2Q mu+J0Q5yIi37564u1jlSWFnVhOsvgIbMqgr1BAivNOxibi7oy3TtnNdOlEyet31PZtkD PVvA== X-Forwarded-Encrypted: i=1; AJvYcCXj26c1Kq0BFMV2c6AAnUVVG2GxgAmVmGW1/jHU3d/DiZwBR6WHnONZiQwnJlcS4lqSN3gKb2IGfvfH8L8J@postgresql.org X-Gm-Message-State: AOJu0YxbM/03/lM5mPR+2opWs7BZF71I/bF0dQsmSBflj60Yr2OfWFbI lzf8CsDaekiW6P8W0/quTgmBwEP9DahNx9FsEcKGpRPVZ3Io/9BMRzJkKTn1/SEYU2mkAeIcmKy x7rP2lzte/rTspRh9o7A8CV1r6rs= X-Google-Smtp-Source: AGHT+IFOEU2BfCNBI8NfGFEg+WzhKL1d+o0rL5EjlIXUm6lZXkohAifSPo7BexmuwyD5S4NJ04IWiNy4s/Q/ba8I1eY= X-Received: by 2002:a05:6870:2247:b0:279:b5ac:d1c1 with SMTP id 586e51a60fabf-2905103a3dcmr2013770fac.8.1729979700494; Sat, 26 Oct 2024 14:55:00 -0700 (PDT) MIME-Version: 1.0 References: <1e16e035-e7e5-460a-86f8-9a207fd2ffef@aklaver.com> <56a90390-5a4b-4ffc-a0bc-5a09c46d6876@aklaver.com> <06a12f4c-1b6e-40d7-bf77-0193c93af127@aklaver.com> In-Reply-To: <06a12f4c-1b6e-40d7-bf77-0193c93af127@aklaver.com> From: rajesh kumar Date: Sat, 26 Oct 2024 17:53:18 -0400 Message-ID: Subject: Re: Pgsql 16 to 14 using builtin logical To: Adrian Klaver Cc: Asad Ali , Durgamahesh Manne , pgsql-general , PostgreSQL mailing lists Content-Type: multipart/alternative; boundary="0000000000008448ae06256849f6" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000008448ae06256849f6 Content-Type: text/plain; charset="UTF-8" I have tested it around 3 - 4 years ago. Logical replication is backward compatible as well. So 16 to 14 does work :) On Sat, Oct 26, 2024, 17:16 Adrian Klaver wrote: > On 10/26/24 11:38, Asad Ali wrote: > > I missed to mentioned in the last. > > ? > > > > -- > Adrian Klaver > adrian.klaver@aklaver.com > > > > --0000000000008448ae06256849f6 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

I have tested it around 3 - 4 years ago.
Logical replication is backward compatible as well.

So 16 to 14 does work :)


On Sat= , Oct 26, 2024, 17:16 Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 10/26/24 11:38, Asad Ali wrote:
> I missed to mentioned in the last.

?



--
Adrian Klaver
adrian.klaver@aklaver.com



--0000000000008448ae06256849f6--