Re: Publication/Subscription Questions - Mailing list pgsql-general

From Christophe Pettus
Subject Re: Publication/Subscription Questions
Date
Msg-id FE9490C2-70F8-49E0-88DE-433F7DB1EE48@thebuild.com
Whole thread Raw
In response to Publication/Subscription Questions  (xOChilpili <xochilpili@gmail.com>)
List pgsql-general
> On Jul 27, 2018, at 01:34, xOChilpili <xochilpili@gmail.com> wrote:
>
> Why ? If i remove rows, from Server B and refresh publication, why data is not re-sync ?

ALTER SUBSCRIPTION ... REFRESH PUBLICATION doesn't do another initial copy of the data for existing tables in the
publication. Its function is to add tables that were added to the publication after the subscription was last created
orrefreshed.  It does (by default) copy the data from newly-added tables, but it does not resync the data from the
existingtables. 

--
-- Christophe Pettus
   xof@thebuild.com



pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: postgres with xcode
Next
From: Adrian Klaver
Date:
Subject: Re: Publication/Subscription Questions