On Tuesday, March 4, 2025, chandan Kumar <chandan.issy...@gmail.com> wrote:
> 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 > PostgreSQL doesn’t have a concept of “revert”. PITR just deals with raw bytes on disk for an entire cluster. If a new file appears in the WAL that file is created. That file can be a directory for a database. You cannot mix physical and logical images of the database so applying WAL on top of pg_restore is technically invalid - but it does effective convey the idea. It’s like saying pg_dump and pg_basebackup are similar. Sure, in some ways that is true - but the logical vs. physical distinction cannot be ignored fully. David J.
