Re: Streaming Replication vs Logical

Bruce Momjian <bruce@momjian.us>

From: Bruce Momjian <bruce@momjian.us>
To: Robert Treat <rob@xzilla.net>
Cc: Paul A Jungwirth <pj@illuminatedcomputing.com>, Laurenz Albe <laurenz.albe@cybertec.at>, pgsql-docs@lists.postgresql.org
Date: 2025-12-19T17:02:41Z
Lists: pgsql-docs
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.

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  Do not let urgent matters crowd out time for investment in the future.



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