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