From: | "Mikael Sterner" <msterner(at)mxy(dot)se> |
---|---|
To: | pgsql-novice(at)lists(dot)postgresql(dot)org |
Subject: | Why clear pg_wal when recovering? |
Date: | 2021-11-12 15:55:48 |
Message-ID: | 34654dce-25fe-4d12-bf6e-b8b28a54b164@www.fastmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs pgsql-novice |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Terry Gilbert | 2021-11-12 16:04:29 | RE: Ltree pattern matching |
Previous Message | Tom Lane | 2021-11-12 15:37:04 | Re: Ltree pattern matching |
From | Date | Subject | |
---|---|---|---|
Next Message | Cabe Steele | 2021-11-12 20:41:38 | Regclass what does reg mean |
Previous Message | Laurenz Albe | 2021-11-11 16:11:50 | Re: Phonetic representation LENGHT for DMETAPHONE, is there a way to make it longer? |