Обсуждение: logical replication via log shipping

Поиск
Список
Период
Сортировка

logical replication via log shipping

От
Sbob
Дата:
Is there a way to perform logical replication via log shipping?




Re: logical replication via log shipping

От
Robert Treat
Дата:
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



Re: logical replication via log shipping

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


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