Re: Why we lost Uber as a user - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Why we lost Uber as a user
Date
Msg-id 14878.1470251754@sss.pgh.pa.us
Whole thread Raw
In response to Re: Why we lost Uber as a user  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: Why we lost Uber as a user  (Kevin Grittner <kgrittn@gmail.com>)
List pgsql-hackers
"Joshua D. Drake" <jd@commandprompt.com> writes:
> On 08/03/2016 11:23 AM, Tom Lane wrote:
>> I think the realistic answer if you suffer replication-induced corruption
>> is usually going to be "re-clone that slave", and logical rep doesn't
>> really offer much gain in that.

> Yes, it actually does. The ability to unsubscribe a set of tables, 
> truncate them and then resubscribe them is vastly superior to having to 
> take a base backup.

True, *if* you can circumscribe the corruption to a relatively small
part of your database, logical rep might provide more support for a
partial re-clone.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Álvaro Hernández Tortosa
Date:
Subject: Re: Implementing full UTF-8 support (aka supporting 0x00)
Next
From: Geoff Winkless
Date:
Subject: Re: Implementing full UTF-8 support (aka supporting 0x00)