progress of PITR

From: Andreas Brandl <ml(at)3(dot)141592654(dot)de>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: progress of PITR
Date: 2012-10-27 20:45:35
Message-ID: c3795e2c-3275-42f3-9603-e4ac4c25704d@store1.zcs.ext.wpsrv.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 there any way of getting the timestamp of the last replayed transaction or the like? I know that I can look at the creation timestamp of the xlog currently being replayed, but this might be prone to some error (due to archiving to remote destination / moving xlogs around).

Thank you!

Regards,
Andreas

Browse pgsql-general by date

  From Date Subject
Next Message Torsten Zühlsdorff 2012-10-27 20:46:09 Re: Improve MMO Game Performance
Previous Message Andreas Brandl 2012-10-27 20:33:03 PITR / progress