Postgres Pro
Downloads
Home   >   mailing lists

Facing difficulty in PITR - Mailing list pgsql-general

From chiru r
Subject Facing difficulty in PITR
Date
Msg-id CA+RSxMgP9J2QqFxTfrppQ2peqU1jEpXgdsBvfUaNsukmAGEjHA@mail.gmail.com
Whole thread Raw
Responses Re: Facing difficulty in PITR
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Rob Sargent
Date:
Subject: Re: After dump/restoring from 32bit 8.4-windows to 64bit 9.2.4-linux experiencing 10x slowdown on queries
Next
From: Jerry Sievers
Date:
Subject: Re: Facing difficulty in PITR