public inbox for [email protected]  

help / color / mirror / Atom feed

From: Mikael Sterner <[email protected]>
To: [email protected]
Subject: Why clear pg_wal when recovering?
Date: Fri, 12 Nov 2021 16:55:48 +0100
Message-ID: <[email protected]> (raw)

Hi!

In the guide at https://www.postgresql.org/docs/current/continuous-archiving.html#BACKUP-PITR-RECOVERY
step 5 is to remove any files present in the pg_wal directory. Is this
still the recommendation if the source of the file system restore in step 4
was a base backup generated by pg_basebackup? Because in that case, wouldn't
the files in pg_wal still be needed to recover from the basebackup state?

I guess these files that were removed would normally be restored from the
WAL archive, but if you have for some reason lost your WAL archive, or it's
not complete, wouldn't it be better if you had retained them in the restored
data directory so that you could at least reach the state at the end of your
latest base backup?

Yours,
Mikael

view thread (2+ 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]
  Subject: Re: Why clear pg_wal when recovering?
  In-Reply-To: <[email protected]>

* 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