Postgres Pro
Downloads
Home   >   mailing lists

Thread: PITR

PITR

From
Yongye Serkfem
Date:
Hi,
I hope you are all doing well. I am trying to do PITR on Postgresql v12. Now that the recovery.conf file is not available in this version, where should I set the recovery_target_time? I checked the Postgresql.conf file and can't find the appropriate parameter to set the target time.
I'm looking forward to reading your thoughts.

Best regards
Yong Serkfem

Re: PITR

From
Ron Johnson
Date:
On Wed, Feb 14, 2024 at 1:39 PM Yongye Serkfem <yserkfem@gmail.com> wrote:
Hi,
I hope you are all doing well. I am trying to do PITR on Postgresql v12. Now that the recovery.conf file is not available in this version, where should I set the recovery_target_time? I checked the Postgresql.conf file and can't find the appropriate parameter to set the target time.

Consider using PgBackRest.  It's multithreaded, and you specify the "restore-from start point" and "recover until" time on the command line.  It then handles everything for you, besides the final "pg_ctl start -D ...".

Re: PITR

From
Greg Sabino Mullane
Date:
On Wed, Feb 14, 2024 at 1:39 PM Yongye Serkfem <yserkfem@gmail.com> wrote:
 I checked the Postgresql.conf file and can't find the appropriate parameter to set the target time.

It is set inside the postgresql.conf file. Unless you have modified it, there is a section in there called "Recovery Target" which has a handful of commented-out variables starting with "recovery_"

Cheers,
Greg