Re: 10 beta docs: different replication solutions

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

In response to

Browse pgsql-hackers by date

  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