Hi David, You catched my word "revert". Thats so encouraging to see how this community helps. Your answer has cleared my 99% doubt. Thanks again. I wish I also contribute one day . Have a good time!
On Tue, Mar 4, 2025 at 9:08 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 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. > > -- *With warm regards* * Chandan*
