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: | Raw Message | Whole Thread | 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 |