Re: Facing difficulty in PITR

Thanks Jerry,it worked for me and saved my time.

Regards,
Chiru

On Wed, Apr 10, 2013 at 4:57 AM, Jerry Sievers <gsievers19(at)comcast(dot)net>wrote:

> chiru r <chirupg(at)gmail(dot)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(dot)consulting(at)comcast(dot)net
> p: 312.241.7800
>