| From: | Christophe Pettus <xof(at)thebuild(dot)com> |
|---|---|
| To: | xOChilpili <xochilpili(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Publication/Subscription Questions |
| Date: | 2018-07-29 04:29:59 |
| Message-ID: | FE9490C2-70F8-49E0-88DE-433F7DB1EE48@thebuild.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> On Jul 27, 2018, at 01:34, xOChilpili <xochilpili(at)gmail(dot)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 or refreshed. It does (by default) copy the data from newly-added tables, but it does not resync the data from the existing tables.
--
-- Christophe Pettus
xof(at)thebuild(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2018-07-29 04:31:19 | Re: Publication/Subscription Questions |
| Previous Message | Adrian Klaver | 2018-07-28 18:41:11 | Re: postgres with xcode |