MIME-Version: 1.0
References: <CAKgGyB_UaN7a5Pe9ea2e5at7LLrypYEQit=XmWc_SKXnHWpjdg@mail.gmail.com>
In-Reply-To: <CAKgGyB_UaN7a5Pe9ea2e5at7LLrypYEQit=XmWc_SKXnHWpjdg@mail.gmail.com>
From: Greg Sabino Mullane <htamfids@gmail.com>
Date: Wed, 25 Sep 2024 17:32:23 -0400
Message-ID: <CAKAnmmKeJB=o6=qHy8C=e7t7zooC4wrGJ=nowEWroOSaH+8pyw@mail.gmail.com>
Subject: Re: PgBackRest : Restore to a checkpoint shows further transactions
To: KK CHN <kkchn.in@gmail.com>
Cc: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000bfc3680622f85d08"
Archived-At: <https://www.postgresql.org/message-id/CAKAnmmKeJB%3Do6%3DqHy8C%3De7t7zooC4wrGJ%3DnowEWroOSaH%2B8pyw%40mail.gmail.com>
Precedence: bulk

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

On Wed, Sep 25, 2024 at 2:13=E2=80=AFAM KK CHN <kkchn.in@gmail.com> wrote:

> PgBackRest :  I tried to restore the latest backup taken at my RepoServer
> to a  testing EPAS server freshly deployed .
> ...
>
Now I  comment out the archive command in the test EPAS server
> postgresql.conf  and started the EPAS server.
>

* To disable archiving, you can pass --archive-mode=3Doff to pgbackrest in
the restore command. Actually, for safety, you should always use this
argument when restoring.

* Please say "Postgres" not "EPAS"

* The restore starts from your incremental backup, but then it will replay
WAL created after that backup. Check out the postgresql.auto.conf file.

* I think what you are looking for is --type=3Dimmediate

* For debugging and helping to learn, it can be useful to use
--pg1-path=3D/tmp/restoretest to restore to a different data directory. Jus=
t
remember to change the port. And always use --archive-mode=3Doff :)

See specifically this section of the docs:
https://pgbackrest.org/command.html#command-restore

Cheers,
Greg

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

<div dir=3D"ltr"><div dir=3D"ltr">On Wed, Sep 25, 2024 at 2:13=E2=80=AFAM K=
K CHN &lt;<a href=3D"mailto:kkchn.in@gmail.com">kkchn.in@gmail.com</a>&gt; =
wrote:<br></div><div class=3D"gmail_quote"><blockquote class=3D"gmail_quote=
" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);=
padding-left:1ex"><div dir=3D"ltr"><div>PgBackRest :=C2=A0 I tried to resto=
re the latest backup taken at my RepoServer to a=C2=A0 testing EPAS server =
freshly deployed .</div><div><span style=3D"font-family:Calibri,sans-serif;=
font-size:11pt">...</span>=C2=A0</div></div></blockquote><blockquote class=
=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rg=
b(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div><span style=3D"font-=
family:Calibri,sans-serif;font-size:11pt">Now I=C2=A0 comment out the archi=
ve command in the test EPAS server postgresql.conf=C2=A0 and started the EP=
AS server.</span><br></div></div></blockquote><div><br></div><div>* To disa=
ble archiving, you can pass --archive-mode=3Doff to pgbackrest in the resto=
re command. Actually, for safety, you should always use this argument when =
restoring.</div><div><br></div><div>* Please say &quot;Postgres&quot; not &=
quot;EPAS&quot;</div><div><br></div><div>* The restore starts from your inc=
remental backup, but then it will replay WAL=C2=A0created after that backup=
. Check out the postgresql.auto.conf file.</div><div><br></div><div>* I thi=
nk what you are looking for is --type=3Dimmediate</div><div><br></div><div>=
* For debugging and helping to learn, it can be useful to use --pg1-path=3D=
/tmp/restoretest to restore to a different data directory. Just remember to=
 change the port. And always use --archive-mode=3Doff :)</div><div><br></di=
v><div>See specifically this section of the docs: <a href=3D"https://pgback=
rest.org/command.html#command-restore">https://pgbackrest.org/command.html#=
command-restore</a></div><div><br></div><div>Cheers,</div><div>Greg</div><d=
iv><br></div></div></div>

--000000000000bfc3680622f85d08--