Postgres Pro
Downloads
Home   >   mailing lists

Thread: Facing difficulty in PITR

Facing difficulty in PITR

From
chiru r
Date:
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

Re: Facing difficulty in PITR

From
Jerry Sievers
Date:
chiru r <chirupg@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.consulting@comcast.net
p: 312.241.7800

Re: Facing difficulty in PITR

From
chiru r
Date:
Thanks Jerry,it worked for me and saved my time.

Regards,
Chiru


On Wed, Apr 10, 2013 at 4:57 AM, Jerry Sievers <gsievers19@comcast.net> wrote:
chiru r <chirupg@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.consulting@comcast.net
p: 312.241.7800