Logical subscription / publication lifetimes - Mailing list pgsql-general

From andrew cooke
Subject Logical subscription / publication lifetimes
Date
Msg-id 20220422120039.rpvohhfllv3s2im7@acooke.org
Whole thread Raw
Responses Re: Logical subscription / publication lifetimes
List pgsql-general
If I define a publication at time Tp, then load some data on the
publisher, then start a subscription at time Ts, then load some more
data on the publisher, does the subscriber get data from Tp or Ts
onwards?

Also, if a subscription is disabled and then re-enabled does it lose
the data inbetween, or is it back-filled?

I am not finding the answers to these questions in the docs at
https://www.postgresql.org/docs/current/logical-replication.html but
maybe I am overlooking something.  The link above does mention copying
an existing table which may imply Ts?

Thanks,
Andrew



pgsql-general by date:

Previous
From: Willy-Bas Loos
Date:
Subject: logical replication worker can't find postgis function
Next
From: Laurenz Albe
Date:
Subject: Re: logical replication worker can't find postgis function