Re: How to monitor logical replication initial sync?

Поиск
Список
Период
Сортировка
От bricklen
Тема Re: How to monitor logical replication initial sync?
Дата
Msg-id CAGrpgQ91Sh+y18FhsbsSQVQSnuT72e=TA7x8AFXjuw6n4dsoWA@mail.gmail.com
обсуждение исходный текст
Ответы Re: How to monitor logical replication initial sync?
Список pgsql-general

On Wed, Mar 7, 2018 at 3:23 PM, Doug Gorley <doug@gorley.ca> wrote:
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?

​This is a question I'm quite interested in as well (and one I do not have an answer to).​
 
​Does anyone with more familiarity ​with logical replication have any suggestions on how to determine the status of the initial sync?

В списке pgsql-general по дате отправления:

Предыдущее
От: rob stone
Дата:
Сообщение: Re: Snapshot recovery or rolling back commited
Следующее
От: Mike Rylander
Дата:
Сообщение: Change ON UPDATE behavior of fkey