Re: Streaming Replication vs Logical

Robert Treat <rob@xzilla.net>

From: Robert Treat <rob@xzilla.net>
To: Bruce Momjian <bruce@momjian.us>
Cc: Paul A Jungwirth <pj@illuminatedcomputing.com>, Laurenz Albe <laurenz.albe@cybertec.at>, pgsql-docs@lists.postgresql.org
Date: 2025-12-19T22:19:15Z
Lists: pgsql-docs
On Fri, Dec 19, 2025 at 12:02 PM Bruce Momjian <bruce@momjian.us> wrote:
>
> On Thu, Nov 27, 2025 at 12:16:01AM -0500, Bruce Momjian wrote:
> > On Mon, Nov 24, 2025 at 11:28:22PM -0500, Robert Treat wrote:
> > > > I took a look through some of the replication slot stuff and ISTM that it basically gets the streaming logical/physical replication distinctions correct, and I *think*
> > > > it gets the slot distinctions correct as well, but to the degree there might be some issue there, I think it could be addressed separately.
> > > >
> > >
> > > Hey Bruce,
> > >
> > > Your recent commit on this topic [1] reminded me of the patch from
> > > earlier this year meant to address some other areas where we are
> > > blurry about using streaming vs physical vs logical replication. I
> > > think (I might possibly still be jet lagged) I have updated the
> > > previous version of that patch against HEAD, attached, and bumping it
> > > up for review.
> >
> > Funny you found this patch, and I was thinking about it recently also
> > because of the fixes for physical vs logical replication.  I will apply
> > this patch after sufficient review time, thanks.
>
> Great, patch applied, and commitfest updated.  I apologize this dropped
> off my radar for so long.
>

Thanks Bruce / All!

Robert Treat
https://xzilla.net



Commits

  1. doc: clarify when physical/logical replication is used

  2. doc: clarify "physical" replication slot creation on the primary

  3. doc: reorder logical replication benefits in a logical order