From: | Ron <ronljohnsonjr(at)gmail(dot)com> |
---|---|
To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
Subject: | Re: Question about pg_wal.tar.gz generated by pg_basebackup |
Date: | 2023-05-10 13:38:22 |
Message-ID: | 20d47b36-b16e-28a3-3a6b-ab13d4d5b8c2@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Matthew Planchard | 2023-05-10 15:04:43 | Index recreation details with REINDEX TABLE CONCURRENTLY |
Previous Message | Stephen Frost | 2023-05-10 12:13:03 | Re: Patroni Issue |