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
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.
