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.johnston@xxxxxxxxx> wrote:
On Tuesday, March 4, 2025, chandan Kumar <chandan.issyoga@xxxxxxxxx> wrote:Thank you for your answer. I want to clarify one more doubt. Can PITR be achieved without applying Base BackupThe 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
