Re: logical replication via log shipping - Mailing list pgsql-admin

From Robert Treat
Subject Re: logical replication via log shipping
Date
Msg-id CABV9wwP4B88XBBpg4_uVyOPC9fArMVBtCrdAhryWVJiqiUbmeQ@mail.gmail.com
Whole thread Raw
In response to logical replication via log shipping  (Sbob <sbob@quadratum-braccas.com>)
Responses Re: logical replication via log shipping
List pgsql-admin
On Sat, Jan 3, 2026 at 1:36 PM Sbob <sbob@quadratum-braccas.com> 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



pgsql-admin by date:

Previous
From: Sbob
Date:
Subject: logical replication via log shipping
Next
From: Sbob
Date:
Subject: Re: logical replication via log shipping