Re: PgBackRest : Restore to a checkpoint shows further transactions

public inbox for [email protected]  
help / color / mirror / Atom feed

From: Greg Sabino Mullane <[email protected]>
To: KK CHN <[email protected]>
Cc: pgsql-general <[email protected]>
Subject: Re: PgBackRest : Restore to a checkpoint shows further transactions
Date: Wed, 25 Sep 2024 17:32:23 -0400
Message-ID: <CAKAnmmKeJB=o6=qHy8C=e7t7zooC4wrGJ=nowEWroOSaH+8pyw@mail.gmail.com> (raw)
In-Reply-To: <CAKgGyB_UaN7a5Pe9ea2e5at7LLrypYEQit=XmWc_SKXnHWpjdg@mail.gmail.com>
References: <CAKgGyB_UaN7a5Pe9ea2e5at7LLrypYEQit=XmWc_SKXnHWpjdg@mail.gmail.com>

On Wed, Sep 25, 2024 at 2:13 AM KK CHN <[email protected]> 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=off 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=immediate

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

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

Cheers,
Greg

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]
  Subject: Re: PgBackRest : Restore to a checkpoint shows further transactions
  In-Reply-To: <CAKAnmmKeJB=o6=qHy8C=e7t7zooC4wrGJ=nowEWroOSaH+8pyw@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