public inbox for [email protected]
help / color / mirror / Atom feedFrom: chandan Kumar <[email protected]>
To: David G. Johnston <[email protected]>
Cc: Laurenz Albe <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: Review my steps for rollback to restore point
Date: Tue, 4 Mar 2025 21:15:39 +0530
Message-ID: <CAHV6zVm73D1pMUqg50Nep3pSh+eP-aAsRyUwu8qXFzudKjZb+g@mail.gmail.com> (raw)
In-Reply-To: <CAKFQuwbzEDV2e4yfSpr8SkLyxEmAk=WPn3uo3C2q+1xR5VymVA@mail.gmail.com>
References: <CAHV6zV=XN-keoXn-Qi=vMBvfG5JGxjhdFKTksczizXSXC31fXg@mail.gmail.com>
<[email protected]>
<CAHV6zV=TP=LYexUs8ZTmJxYeoX2HKJHmVPApgrc3WJfYb3niDA@mail.gmail.com>
<CAKFQuwbeakn6f8Qo1nOked-unPjYd-_tkG38E0xmjwYpL=VLcg@mail.gmail.com>
<CAHV6zV=G3od8Pa7XOH5dR6LUZQ2aoM__zyV-GMWrfyz=gufF9A@mail.gmail.com>
<CAKFQuwbzEDV2e4yfSpr8SkLyxEmAk=WPn3uo3C2q+1xR5VymVA@mail.gmail.com>
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 <[email protected]>
wrote:
> On Tuesday, March 4, 2025, chandan Kumar <[email protected]>
> 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*
view thread (6+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected]
Subject: Re: Review my steps for rollback to restore point
In-Reply-To: <CAHV6zVm73D1pMUqg50Nep3pSh+eP-aAsRyUwu8qXFzudKjZb+g@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox