From: | Steve Singer <steve(at)ssinger(dot)info> |
---|---|
To: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: 10 beta docs: different replication solutions |
Date: | 2017-08-01 00:09:52 |
Message-ID: | alpine.DEB.2.11.1707312007350.12702@opti.atlantida |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Mon, 31 Jul 2017, Merlin Moncure wrote:
> On Sun, Jul 30, 2017 at 8:34 PM, Steve Singer <steve(at)ssinger(dot)info> wrote:
>>
>> We don't seem to describe logical replication on
>>
>> https://www.postgresql.org/docs/10/static/different-replication-solutions.html
>>
>> The attached patch adds a section.
>
> This is a good catch. Two quick observations:
>
> 1) Super pedantic point. I don't like the 'repl.' abbreviation in the
> 'most common implementation' both for the existing hs/sr and for the
> newly added logical.
Updated
>
> 2) This lingo:
> + Logical replication allows the data changes from individual tables
> + to be replicated. Logical replication doesn't require a particular server
> + to be designated as a master or a slave but allows data to flow
> in multiple
> + directions. For more information on logical replication, see
> <xref linkend="logical-replication">.
>
> Is good, but I would revise it just a bit to emphasize the
> subscription nature of logical replication to link the concepts
> expressed strongly in the main section. For example:
>
> Logical replication allows the data changes [remove: "from individual
> tables to be replicated"] to be published to subscriber nodes. Data
> can flow in any direction between nodes on a per-table basis; there is
> no concept of a master server. Conflict resolution must be handled
> completely by the application. For more information on...
>
> what do you think?
Sounds good.
I've incorporated these changes into an updated patch but I changed the
language around conflict resolution. Conflict resolution could be handled
by triggers or adding extra columns to the primary key, that wouldn't be
'completely by the application'
>
> merlin
>
Attachment | Content-Type | Size |
---|---|---|
comparision-logical.diff | text/x-diff | 5.4 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2017-08-01 00:17:16 | Re: PL_stashcache, or, what's our minimum Perl version? |
Previous Message | Thomas Munro | 2017-07-31 23:55:45 | Re: Parallel Hash take II |