Обсуждение: PITR
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
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 ...".
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