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 1t4Zse-001C1f-Gv for pgsql-general@arkaria.postgresql.org; Sat, 26 Oct 2024 06:02:32 +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 1t4Zsa-006atF-Vx for pgsql-general@arkaria.postgresql.org; Sat, 26 Oct 2024 06:02:29 +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 1t4Zsa-006asw-IN for pgsql-general@lists.postgresql.org; Sat, 26 Oct 2024 06:02:29 +0000 Received: from mail-ej1-x630.google.com ([2a00:1450:4864:20::630]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1t4ZsY-002uoH-AL for pgsql-general@postgresql.org; Sat, 26 Oct 2024 06:02:27 +0000 Received: by mail-ej1-x630.google.com with SMTP id a640c23a62f3a-a9a156513a1so395792666b.0 for ; Fri, 25 Oct 2024 23:02:26 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1729922544; x=1730527344; 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=cji/K85/bNA0YL0BHEgV48TCdw/q/Fr+ZS/dfRPUag4=; b=f78+Xdackb+G2gph+Lup7288PowzO7DkWmn++yWt64Or1DRdwJkSusUW3HRaGnvJ5f 6YPe+CsmZZ0hBQVQdG1h1NC063dBc+jwPuyu5Gi+8ncTgGQ6flOSKydjMiiwfY6UlR5r 1ticEtu6FS2COzFmmFEGHEJf/7P+yUp/5OGsjo3eat3puN+lwpYDTNFlILGVH3Ck/5XZ 8CSSZiwbzGvdyacW5W/N3sKnhfGiekPRC6xfYdP3eBUfrhrvMAo2ybfIkZJ4tFQNW1DM LSPK84EyQjlyAlYM/A9Tc52cqkA8nQvZ0yoo36u7jGQ9pFCbQvd8rZUykWJJTQgpbegq n82A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1729922544; x=1730527344; 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=cji/K85/bNA0YL0BHEgV48TCdw/q/Fr+ZS/dfRPUag4=; b=XO3s2QwtzKCZkOvcfZ/dBAdpn5kiw06Eb09Cga+oM/vQofqpGp5+wFcvzU6n4iZ+Dk kKYSlVJqX0WJnRHfrAShxN6eayGVc+r2/9j/SL7QcUmzEJitwY+Hx4iyzIZdGqrJ7X8y jKHQChEO6jLlTST7ntf/XhdwxBQarSE8PvUKnoD1thkwBrrqhNIVt777nG1OfbPuoS2k 47yXRJHuqr4V2NCIZtSOsIOlxg6kKk4gtrFBavCKQ6jOWkRij8v9xJMP+4VVW5foLQds wZIg/tHbozGfQ5HJRdvsrKyOL4P3fL/nCSx5/28JLc5KkoF4FMLCTOPQmykTOmurxSU4 PGcA== X-Forwarded-Encrypted: i=1; AJvYcCVS3W9LqHNK/vZGUAYiuObGwGzdw8YTo0NhzSyrCt5ToOlb2gAO3q+yXbuECQjGCoSq7btbrjncF8hfU8Zi@postgresql.org X-Gm-Message-State: AOJu0YwV6U6pSDqA74qxsgvJikS5GCxMQg9LBql8ID+vFBJel+UJGz0o MSjOL8rMX4/JR+gK/xI60tCp3TSSsYrs0wwsv5OqZsyCMK8zY+t/UvR13hPlvYZXSv/7RkaN8T0 f/+vinB7t+2BwfrauqG3BXZQxZ1Q= X-Google-Smtp-Source: AGHT+IFZLMeRWgM/c11lcKPLQnUoJJSVIaz9kRg+y3c8pZHidjogTiCzp9oeWFieo5cGCTkymojb6FXqGUQ46wEAAh8= X-Received: by 2002:a17:907:7e9e:b0:a9a:46:83ee with SMTP id a640c23a62f3a-a9de61d1a69mr99191066b.48.1729922543865; Fri, 25 Oct 2024 23:02:23 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Asad Ali Date: Sat, 26 Oct 2024 11:02:11 +0500 Message-ID: Subject: Re: Pgsql 16 to 14 using builtin logical To: Durgamahesh Manne Cc: pgsql-general , PostgreSQL mailing lists Content-Type: multipart/alternative; boundary="000000000000b757e106255afae6" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000b757e106255afae6 Content-Type: text/plain; charset="UTF-8" Hi Durgamahesh, Yes, you can replicate a PostgreSQL 16 database to PostgreSQL 14 using built-in logical replication. PostgreSQL's built-in logical replication allows for replicating data between different versions of PostgreSQL, provided the source version is higher than or equal to the target version. Regards, Asad On Sat, Oct 26, 2024, 8:28 AM Durgamahesh Manne wrote: > Hi > > Can we replicate 16 to 14 using builtin logical similarly pglogical? > > Regards > Durga Mahesh > --000000000000b757e106255afae6 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi Durgamahesh,

Yes, you can replicate a PostgreSQ= L 16 database to PostgreSQL 14 using built-in logical replication. PostgreS= QL's built-in logical replication allows for replicating data between d= ifferent versions of PostgreSQL, provided the source version is higher than= or equal to the target version.

Regards,
Asad


On S= at, Oct 26, 2024, 8:28 AM Durgamahesh Manne <maheshpostgres9@gmail.com> wrote:
Hi

Can we replicate 16 to 14 using builtin logical simila= rly pglogical?

Regards=C2=A0
Durga Mahesh=C2=A0
--000000000000b757e106255afae6--