Logical subscription / publication lifetimes

From: andrew cooke <andrew(at)acooke(dot)org>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Logical subscription / publication lifetimes
Date: 2022-04-22 12:00:39
Message-ID: 20220422120039.rpvohhfllv3s2im7@acooke.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Laurenz Albe 2022-04-22 13:20:41 Re: logical replication worker can't find postgis function
Previous Message Willy-Bas Loos 2022-04-22 11:25:45 logical replication worker can't find postgis function