"Joshua D. Drake" <j...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers