| From: | Dhirendra Singh <dhirendraks(at)gmail(dot)com> |
|---|---|
| To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Question about pg_wal.tar.gz generated by pg_basebackup |
| Date: | 2023-05-10 08:41:34 |
| Message-ID: | CAEyh4sb3SnH6Mf88R98C3LBOdV_rW-sBu=1YoycVSqDYA+BA9A@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hi All,
I am taking backup using pg_basebackup for the purpose of point in time
recovery in case something goes wrong with the data.
The backup generates pg_wal.tar.gz which contains the wal file generated
during the backup.
Is it of any use in the point in time recovery? do i have to archive it?
According to the documentation, any wal files in pg_wal directory has to be
deleted after the base backup is restored and before the recovery starts.
So if i understand it correctly, pg_wal.tar.gz is not required for point in
time recovery...but just want to confirm if my understanding is correct.
My sole purpose of taking the backup is for point in time recovery. I am
not going to use it to create a standby server.
Thanks,
Dhirendra
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephen Frost | 2023-05-10 12:06:15 | Re: Question about pg_wal.tar.gz generated by pg_basebackup |
| Previous Message | Ron | 2023-05-09 14:24:17 | The download page says that Pg 14 is available for RHEL 6 |