Question about pg_wal.tar.gz generated by pg_basebackup

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

Responses

Browse pgsql-admin by date

  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