| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | "Subramanian,Ramachandran" <ramachandran(dot)subramanian(at)alte-leipziger(dot)de> |
| Cc: | "pgsql-novice(at)lists(dot)postgresql(dot)org" <pgsql-novice(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Very basic question about Archive logs |
| Date: | 2026-03-26 12:30:24 |
| Message-ID: | CAKFQuwZwA=sq7xeLV032QJCzZ99NQnq8SNg4a6Y_hBxN_D=PmA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On Thursday, March 26, 2026, Subramanian,Ramachandran <
ramachandran(dot)subramanian(at)alte-leipziger(dot)de> wrote:
> Further more, if I execute the PIT-recovery On Tuesday at 0005 Hours and
> specify a Target recovery time of Monday 2300 Hours, then Postgres will
> look at the active logs and any archive logs ( if it does not already exist
> in the active logs ) that were written between Tuesday 0005 Hours and
> Monday 2300 Hours and use these logs to Undo all the changes to the current
> Database. Is my understanding correct?
>
> There is no rolling back. You deploy the base backup first to 0100
Monday, then it would apply the WAL up to the target time.
David J.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Subramanian,Ramachandran | 2026-03-26 12:38:56 | AW: Very basic question about Archive logs |
| Previous Message | Subramanian,Ramachandran | 2026-03-26 12:09:50 | Very basic question about Archive logs |