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