Hello,
We are facing difficulty in PITR.
Case :
Production server backups are happening every day at 12:00AM mid night and we are refreshing Test server with the backup and applying wal archives up to 10:00AM.
Issue:
While transferring wal archives from Production to Test server, unfortunately missing few wal archives,Due to this while doing PITR database is opening before reaching/satisfying recovery_target_time mentioned in recovery conf file.
Question: Is there any way we can stop/Pause PITR and get message if any wal archives got missed before reaching recovery_target_time mentioned in recovery.conf file?.
Thanks in advance.Any suggestions would be appreciated.
Regards,
Chiru