Re: [GENERAL] 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 wrote: > chiru r 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 >
Re: [GENERAL] Facing difficulty in PITR
chiru r 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] Facing difficulty in PITR
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