Re: Replication protocol doc fix - Mailing list pgsql-hackers

From Jeff Davis
Subject Re: Replication protocol doc fix
Date
Msg-id 25346d82854bfe37b2fb4695613969fdf8a5216d.camel@j-davis.com
Whole thread Raw
In response to Re: Replication protocol doc fix  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Replication protocol doc fix  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
On Fri, 2021-06-11 at 16:57 -0400, Robert Haas wrote:
> My impression was that CopyBoth can be initiated either way, 

The docs say: "In either physical replication or logical replication
walsender mode, only the simple query protocol can be used." Is there
some way to initiate CopyBoth outside of walsender?

> but if
> you use the extended query protocol, then the result is a hopeless
> mess, because the protocol is badly designed:
> 
> 
https://www.postgresql.org/message-id/CA+Tgmoa4eA+cPXaiGQmEBp9XisVd3ZE9dbvnbZEvx9UcMiw2tg@mail.gmail.com

It seems like you're saying that CopyIn and CopyBoth are both equally
broken in extended query mode. Is that right?

> But I think you're correct in saying that the discard-until-Sync
> behavior only happens if the extended query protocol is used, so I
> agree that the current text is wrong.

Should we just document how CopyBoth works with the simple query
protocol, or should we make it match the CopyIn docs?

Regards,
    Jeff Davis





pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: Teaching users how they can get the most out of HOT in Postgres 14
Next
From: Peter Geoghegan
Date:
Subject: Re: Teaching users how they can get the most out of HOT in Postgres 14