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 ...".