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.96) (envelope-from ) id 1vc8au-002ORw-0E for pgsql-admin@arkaria.postgresql.org; Sat, 03 Jan 2026 20:51:29 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vc8ar-00Dtmq-01 for pgsql-admin@arkaria.postgresql.org; Sat, 03 Jan 2026 20:51:25 +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.96) (envelope-from ) id 1vc8aq-00Dtmh-1j for pgsql-admin@lists.postgresql.org; Sat, 03 Jan 2026 20:51:25 +0000 Received: from mail-vk1-xa30.google.com ([2607:f8b0:4864:20::a30]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vc8ao-0041ni-2m for pgsql-admin@lists.postgresql.org; Sat, 03 Jan 2026 20:51:23 +0000 Received: by mail-vk1-xa30.google.com with SMTP id 71dfb90a1353d-559748bcf99so11192210e0c.3 for ; Sat, 03 Jan 2026 12:51:22 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=xzilla-net.20230601.gappssmtp.com; s=20230601; t=1767473481; x=1768078281; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=f4D+6KrbuafTti5sv+tMGgHocRu1v6ly7q0OWeBei34=; b=k+AXKqHEAegzqSH4iZTLkkY7fwtQgdLktC6JQIw8rVLqZdt9S5b9NROJbURt/KQzH4 XCEdenlam4+vKhC/+hedEMa9KbHNeBbeJ+KZk1UUfz6dyYtfjUzInVQ67gqI1geDQG3E KjtdXtITUToCa+7GIvrCuD9MOItTzsA0VYU4WsarqUVJhdaQyn3kiRb6KuBuTihlU9uz nCRO5NKjppv4wrqm2P93N2WT5k6ChkdlwzfVeUFauNMdiMMKNLGRq50JlsQBitB4fMDM vB5/dmWs06eRJf4iYR5M8h9GESRytX8W0yxlsumBMdCRFCZiUwu2TKdpMoR/IQS88FkT ucgQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1767473481; x=1768078281; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-gg:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=f4D+6KrbuafTti5sv+tMGgHocRu1v6ly7q0OWeBei34=; b=w+kGSUJ0LtssiYSLpCytDJxS4oi3qIjv40VbeaRsOvOKQqEIhmiovoFxXQzx1ylhIQ ZhlB4IzOya+I3TkwSAAV65xJYO/YdLzhyRZYY5ExuBzpohi5WkqzgIAEqOFkagqusFTl 7nd/1w/XEssb8tSfbHo6t4zeEBMSp3k+e7fxfl1wDlr+G2jcy5rdy1JmQw1xT55sOAzc oVWZXAFR8LmTTUBCTtFNfdE441BendYurk8kxm2mr83HbDwZMMm3OmM/+XBz51xlt6/e jsiMoSrivtibuVj6SIpfXKubSwLBod0nv1l9h1lMJ+039VRAQiPG0I0TqmqqGGjk12OZ kUog== X-Gm-Message-State: AOJu0YzS/z7zAZQqUZYcG1jCRG7nfv6CRkfgVozW0tT84sAfDELdv4bm fhnDqSH8H7BMT/8I8ajMQYFR/SzcLybheMn6euFsR1dG8MNZ39Kb8e3YTPsqBihLAGOG+j2Omag 3LrL/Nt8lQ96va2jPlswBB1NXjpMOPENlcrIm60NPm4nLFLX3BG7c X-Gm-Gg: AY/fxX52VhveCtDlHTGIUecLeoMdra652xlLtzQp9zRyCOyxJRwilrX4qYysgJKVRtl Jaxw3xJTthMGLJdvxBMI3EGd3avlKh/vr2gM183ejABjIDc6viMFVAdeVoX+2Wz4QjJgiHBthdj PXRMXDM+LkylgqiJCqBFu6YlOmsFvq5uy29NtNGyn58/scecmccRtCqZ/deemKnk1gRFZylvfSX eaJaDCSB+OUo6qvy8ni4wUvxCWv1T3AxvDtYV8cRGRKcxOWdVHqm38hlhKCUHawenIb06myQN72 jrzXTw== X-Google-Smtp-Source: AGHT+IEWaKcJWLnnR0uVZBWecqjOVhLj6hZ0j8LpRmi9DS0UwLc7AgGcHwuCoCklT0Eg/aRXwlw7/XQdKxl0FZ57evg= X-Received: by 2002:a05:6122:4fa4:b0:557:c743:e14c with SMTP id 71dfb90a1353d-5615be07393mr15169368e0c.11.1767473481651; Sat, 03 Jan 2026 12:51:21 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Robert Treat Date: Sat, 3 Jan 2026 15:51:10 -0500 X-Gm-Features: AQt7F2pcno7hfg3xPpCgfxEC8_MB0oG4zUjmNtPE1GQuG1PmQotSZqygD5GjqrI Message-ID: Subject: Re: logical replication via log shipping To: Sbob Cc: pgsql-admin@lists.postgresql.org Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Sat, Jan 3, 2026 at 1:36=E2=80=AFPM Sbob wr= ote: > > Is there a way to perform logical replication via log shipping? > The short answer is no; as it stands now, the built in stuff for log shipping via wal_archiving is all designed around the binary file formats and the features and limitations that come with that. That said, one could in theory use something like logical replication and wal2json to create "logical log files" and then ship those files to remote systems which then decode and apply them. To the degree that qualifies as log shipping to you, that is certainly one possible way to do something similar to what you are asking. Robert Treat https://xzilla.net