From: Zwettler Markus (OIZ) <Markus.Zwettler@zuerich.ch>
To: pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
Subject: postgres restore & needed history files
Date: Tue, 3 Jan 2023 16:03:01 +0000
Message-ID: <0ce7906d55174fa6902c011c0aa0e884@zuerich.ch> (raw)
We are using a DIY Postgres backup:
---
psql -c "select pg_start_backup ('Full');"
save -s "${NSR_SERVER}" -g "${NSR_POOL}" "${PGDATA}"
psql -c "select pg_stop_backup();"
---
The pg_wal directory is not saved with it because it is a linked directory.
After some time, we had to perform a point-in-time recovery of 1 of the 5 databases to a point in time 7 days in the past.
We tried to perform a point-in-time restore on another host, which did not work until we copied the contents of the current pg_wal directory.
The current pg_wal directory included 8 history files: 00000002.history to 00000009.history.
The point-in-time restore worked smoodly after it had all these history files.
Afaik, all necessary history files should also be restored by the restore_command.
I had a look at our archived wal backups and found that 00000002.history to 00000008.history files already had been deleted due to our NSR backup retention of 30 days.
Question: Is it necessary to retain all history files?
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-general@postgresql.org
Cc: Markus.Zwettler@zuerich.ch
Subject: Re: postgres restore & needed history files
In-Reply-To: <0ce7906d55174fa6902c011c0aa0e884@zuerich.ch>
References: <0ce7906d55174fa6902c011c0aa0e884@zuerich.ch>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox