MIME-Version: 1.0
References: <CAHV6zV=XN-keoXn-Qi=vMBvfG5JGxjhdFKTksczizXSXC31fXg@mail.gmail.com>
 <ddda8f051bfe265e74d50f17dd8a4227211b9633.camel@cybertec.at>
 <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>
In-Reply-To: <CAKFQuwbzEDV2e4yfSpr8SkLyxEmAk=WPn3uo3C2q+1xR5VymVA@mail.gmail.com>
From: chandan Kumar <chandan.issyoga@gmail.com>
Date: Tue, 4 Mar 2025 21:15:39 +0530
Message-ID: <CAHV6zVm73D1pMUqg50Nep3pSh+eP-aAsRyUwu8qXFzudKjZb+g@mail.gmail.com>
Subject: Re: Review my steps for rollback to restore point
To: "David G. Johnston" <david.g.johnston@gmail.com>
Cc: Laurenz Albe <laurenz.albe@cybertec.at>, 
	"pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000ff0315062f862a0b"
Archived-At: <https://www.postgresql.org/message-id/CAHV6zVm73D1pMUqg50Nep3pSh%2BeP-aAsRyUwu8qXFzudKjZb%2Bg%40mail.gmail.com>
Precedence: bulk

--000000000000ff0315062f862a0b
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

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=E2=80=AFPM David G. Johnston <david.g.johnston@=
gmail.com>
wrote:

> On Tuesday, March 4, 2025, chandan Kumar <chandan.issyoga@gmail.com>
> wrote:
>
>> Thank you for your time and clarification.
>> Does PITR recreate database internally ?  can i say it is not the same a=
s
>> 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=E2=80=99t have a concept of =E2=80=9Crevert=E2=80=9D.
>
> 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 directo=
ry
> for a database.
>
> You cannot mix physical and logical images of the database so applying WA=
L
> on top of pg_restore is technically invalid - but it does effective conve=
y
> the idea.  It=E2=80=99s like saying pg_dump and pg_basebackup are similar=
.  Sure,
> in some ways that is true - but the logical vs. physical distinction cann=
ot
> be ignored fully.
>
> David J.
>
>

--=20
*With warm regards*
*     Chandan*

--000000000000ff0315062f862a0b
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi David,=C2=A0 <br>You catched my word &quot;revert&quot;=
. Thats so encouraging to see how this community helps. Your answer has cle=
ared my 99% doubt. Thanks again.<br>I wish I also contribute one day .=C2=
=A0 Have a good time!</div><br><div class=3D"gmail_quote gmail_quote_contai=
ner"><div dir=3D"ltr" class=3D"gmail_attr">On Tue, Mar 4, 2025 at 9:08=E2=
=80=AFPM David G. Johnston &lt;<a href=3D"mailto:david.g.johnston@gmail.com=
">david.g.johnston@gmail.com</a>&gt; wrote:<br></div><blockquote class=3D"g=
mail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204=
,204,204);padding-left:1ex">On Tuesday, March 4, 2025, chandan Kumar &lt;<a=
 href=3D"mailto:chandan.issyoga@gmail.com" target=3D"_blank">chandan.issyog=
a@gmail.com</a>&gt; wrote:<br><blockquote class=3D"gmail_quote" style=3D"ma=
rgin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:=
1ex"><div dir=3D"ltr">Thank you for your time and clarification.=C2=A0<div>=
Does PITR recreate database internally ?=C2=A0 can i say it is not the same=
 as pg_restore=C2=A0 or it is same as pg_restore plus applying WAL on top o=
f it.=C2=A0 I am asking because can we revern DDL operations without PITR i=
n streaming replication</div></div></blockquote><div><br></div><div>Postgre=
SQL doesn=E2=80=99t have a concept of =E2=80=9Crevert=E2=80=9D.</div><div><=
br></div><div>PITR just deals with raw bytes on disk for an entire cluster.=
=C2=A0 If a new file appears in the WAL that file is created.=C2=A0 That fi=
le can be a directory for a database.</div><div><br></div><div>You cannot m=
ix 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.=C2=
=A0 It=E2=80=99s like saying pg_dump and pg_basebackup are similar.=C2=A0 S=
ure, in some ways that is true - but the logical vs. physical distinction c=
annot be ignored fully.</div><div><br></div><div>David J.</div><div><br></d=
iv>
</blockquote></div><div><br clear=3D"all"></div><div><br></div><span class=
=3D"gmail_signature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_s=
ignature"><div><font style=3D"background-color:rgb(255,255,255)" face=3D"co=
mic sans ms,sans-serif" color=3D"#000099"><strong>With warm regards</strong=
></font></div>
<div><font style=3D"background-color:rgb(255,255,255)" face=3D"comic sans m=
s,sans-serif" color=3D"#000099"><strong>=C2=A0=C2=A0=C2=A0=C2=A0 Chandan</s=
trong></font></div></div>

--000000000000ff0315062f862a0b--