Re: Review my steps for rollback to restore point

On Tuesday, March 4, 2025, chandan Kumar <chandan(dot)issyoga(at)gmail(dot)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.