How to monitor logical replication initial sync?

From: Doug Gorley <doug(at)gorley(dot)ca>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: How to monitor logical replication initial sync?
Date: 2018-03-07 23:23:38
Message-ID: 201803072323.w27NNcvr009303@mail70c0.megamailservers.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

Good day,

How does one monitor the status or progress of an initial sync under logical replication? For example:

* I create a publication in database db_pub
* I create a subscription in database db_sub
* In 15 minutes I want to check an see that the initial sync is N% complete

Is it possible to tell when the initial sync is complete, or better yet, how complete it is?

Thanks,
---
Doug Gorley | doug(at)gorley(dot)ca

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2018-03-08 08:25:05 Re: Update overwriting
Previous Message Campbell, Lance 2018-03-07 21:08:05 Update overwriting

Browse pgsql-general by date

  From Date Subject
Next Message geoff hoffman 2018-03-08 00:04:54 Timescale with replication advice
Previous Message David G. Johnston 2018-03-07 23:21:35 Re: cached plan must not change result type