Re: logical replication via log shipping

From: Robert Treat <rob(at)xzilla(dot)net>
To: Sbob <sbob(at)quadratum-braccas(dot)com>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: logical replication via log shipping
Date: 2026-01-03 20:51:10
Message-ID: CABV9wwP4B88XBBpg4_uVyOPC9fArMVBtCrdAhryWVJiqiUbmeQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Sat, Jan 3, 2026 at 1:36 PM Sbob <sbob(at)quadratum-braccas(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Sbob 2026-01-03 22:06:27 Re: logical replication via log shipping
Previous Message Sbob 2026-01-03 18:36:23 logical replication via log shipping