Re: Review my steps for rollback to restore point

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(dot)g(dot)johnston(at)gmail(dot)com>
wrote:

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

--
*With warm regards*
* Chandan*