| From: | chiru r <chirupg(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Facing difficulty in PITR |
| Date: | 2013-04-09 21:21:26 |
| Message-ID: | CA+RSxMgP9J2QqFxTfrppQ2peqU1jEpXgdsBvfUaNsukmAGEjHA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jerry Sievers | 2013-04-09 23:27:57 | Re: Facing difficulty in PITR |
| Previous Message | Rob Sargent | 2013-04-09 21:17:55 | Re: After dump/restoring from 32bit 8.4-windows to 64bit 9.2.4-linux experiencing 10x slowdown on queries |