public inbox for [email protected]  

help / color / mirror / Atom feed

From: Robert Treat <[email protected]>
To: Sbob <[email protected]>
Cc: [email protected]
Subject: Re: logical replication via log shipping
Date: Sat, 3 Jan 2026 15:51:10 -0500
Message-ID: <CABV9wwP4B88XBBpg4_uVyOPC9fArMVBtCrdAhryWVJiqiUbmeQ@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>

On Sat, Jan 3, 2026 at 1:36 PM Sbob <[email protected]> wrote:
>
> 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

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: logical replication via log shipping
  In-Reply-To: <CABV9wwP4B88XBBpg4_uVyOPC9fArMVBtCrdAhryWVJiqiUbmeQ@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox