From: Doug Gorley <doug@gorley.ca>
To: pgsql-admin@lists.postgresql.org
Subject: How to monitor logical replication initial sync?
Date: Wed, 07 Mar 2018 18:23:38 -0500
Message-ID: <201803072323.w27NNcvr009303@mail70c0.megamailservers.com> (raw)
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@gorley.ca
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: doug@gorley.ca, pgsql-admin@lists.postgresql.org
Subject: Re: How to monitor logical replication initial sync?
In-Reply-To: <201803072323.w27NNcvr009303@mail70c0.megamailservers.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox