Message-ID: <20d47b36-b16e-28a3-3a6b-ab13d4d5b8c2@gmail.com>
Date: Wed, 10 May 2023 08:38:22 -0500
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101
 Thunderbird/102.10.0
Subject: Re: Question about pg_wal.tar.gz generated by pg_basebackup
Content-Language: en-US
To: pgsql-admin@lists.postgresql.org
References: 
 <CAEyh4sb3SnH6Mf88R98C3LBOdV_rW-sBu=1YoycVSqDYA+BA9A@mail.gmail.com>
From: Ron <ronljohnsonjr@gmail.com>
In-Reply-To: 
 <CAEyh4sb3SnH6Mf88R98C3LBOdV_rW-sBu=1YoycVSqDYA+BA9A@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: 
 <https://www.postgresql.org/message-id/20d47b36-b16e-28a3-3a6b-ab13d4d5b8c2%40gmail.com>
Precedence: bulk

On 5/10/23 03:41, Dhirendra Singh wrote:
> 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.

Use a dedicated tool instead of writing your own.  I like PgBackRest, but 
there are others.

-- 
Born in Arizona, moved to Babylonia.