| From: | Ron Johnson <ronljohnsonjr(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: PITR |
| Date: | 2024-02-14 19:20:45 |
| Message-ID: | CANzqJaAc7qjNUcCZ+JeRAJHWThSCUvKUO81oxWkL0F1W-R8Uqg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, Feb 14, 2024 at 1:39 PM Yongye Serkfem <yserkfem(at)gmail(dot)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 ...".
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Sabino Mullane | 2024-02-14 19:40:49 | Re: PITR |
| Previous Message | Adrian Klaver | 2024-02-14 19:13:15 | Re: How to do faster DML |