public inbox for [email protected]  

help / color / mirror / Atom feed

logical replication via log shipping
3+ messages / 2 participants
[nested] [flat]

* logical replication via log shipping
@ 2026-01-03 18:36  Sbob <[email protected]>
  0 siblings, 1 reply; 3+ messages in thread

From: Sbob @ 2026-01-03 18:36 UTC (permalink / raw)
  To: [email protected]

Is there a way to perform logical replication via log shipping?






^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: logical replication via log shipping
@ 2026-01-03 20:51  Robert Treat <[email protected]>
  parent: Sbob <[email protected]>
  0 siblings, 1 reply; 3+ messages in thread

From: Robert Treat @ 2026-01-03 20:51 UTC (permalink / raw)
  To: Sbob <[email protected]>; +Cc: [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





^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: logical replication via log shipping
@ 2026-01-03 22:06  Sbob <[email protected]>
  parent: Robert Treat <[email protected]>
  0 siblings, 0 replies; 3+ messages in thread

From: Sbob @ 2026-01-03 22:06 UTC (permalink / raw)
  To: Robert Treat <[email protected]>; +Cc: [email protected]


On 1/3/26 1:51 PM, Robert Treat wrote:
> 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


Thanks! can you point me to an example of how I would decode the logical 
log files?








^ permalink  raw  reply  [nested|flat] 3+ messages in thread

end of thread, other threads:[~2026-01-03 22:06 UTC | newest]

Thread overview: 3+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2026-01-03 18:36 logical replication via log shipping Sbob <[email protected]>
2026-01-03 20:51 ` Robert Treat <[email protected]>
2026-01-03 22:06   ` Sbob <[email protected]>

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