Thank you for your time and clarification. Does PITR recreate database internally ? can i say it is not the same as pg_restore or it is same as pg_restore plus applying WAL on top of it. I am asking because can we revern DDL operations without PITR in streaming replication
On Tue, Mar 4, 2025 at 8:37 PM David G. Johnston <david.g.johns...@gmail.com> wrote: > On Tuesday, March 4, 2025, chandan Kumar <chandan.issy...@gmail.com> > wrote: > >> Thank you for your answer. I want to clarify one more doubt. Can PITR >> be achieved without applying Base Backup >> > > The point-in-time you choose must be in the future relative to whatever > data files you are applying WAL on top of. That is only possible of you’ve > backed up the data files at some point in the past and use that backup. > > David J. > > -- *With warm regards* * Chandan*