Re: PITR - Mailing list pgsql-general

From Ron Johnson
Subject Re: PITR
Date
Msg-id CANzqJaAc7qjNUcCZ+JeRAJHWThSCUvKUO81oxWkL0F1W-R8Uqg@mail.gmail.com
Whole thread Raw
In response to PITR  (Yongye Serkfem <yserkfem@gmail.com>)
List pgsql-general
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 ...".

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: How to do faster DML
Next
From: Greg Sabino Mullane
Date:
Subject: Re: PITR