Thanks Jerry,it worked for me and saved my time. Regards, Chiru
On Wed, Apr 10, 2013 at 4:57 AM, Jerry Sievers <gsiever...@comcast.net>wrote: > chiru r <chir...@gmail.com> writes: > > > 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?. > > Consider using pg_standby which will wait for a missing WAL rather > than using plain cp. > > Your instance will come up if time target is reached else sit there > spinning while you figure out where the missing WALs are and move them > into place. > > HTH > > > Thanks in advance.Any?suggestions?would be?appreciated. > > > > Regards, > > Chiru > > > > -- > Jerry Sievers > Postgres DBA/Development Consulting > e: postgres.consult...@comcast.net > p: 312.241.7800 >
