Обсуждение: progress of PITR

Поиск
Список
Период
Сортировка

progress of PITR

От
Andreas Brandl
Дата:
Hi,

I'm currently doing a point in time recovery with a recovery_target_time set.

As it takes quite a while, I was wondering if there is a way to see the progress in terms of 'realtime' somehow? Is
thereany way of getting the timestamp of the last replayed transaction or the like? I know that I can look at the
creationtimestamp of the xlog currently being replayed, but this might be prone to some error (due to archiving to
remotedestination / moving xlogs around). 

Thank you!

Regards,
Andreas