Re: Backup From HotStandby - Mailing list pgsql-admin

From Rui DeSousa
Subject Re: Backup From HotStandby
Date
Msg-id 1F62FCE5-E2AB-4307-81C4-859208B24865@crazybean.net
Whole thread Raw
In response to Backup From HotStandby  (Licio Matos <licio.matos@gmail.com>)
Responses Re: Backup From HotStandby  (Licio Matos <licio.matos@gmail.com>)
List pgsql-admin

> On Aug 28, 2019, at 3:31 PM, Licio Matos <licio.matos@gmail.com> wrote:
>
> I have been using a lvm snapshot, all the database files are on the same disk.

Sounds good; note that the filesystem will also need recovery thus you may want to consider trying to quiesce the
filesystembefore creating the snapshot to avoid filesystem issues.     


> My script start the pg_start_backup() make a lvm snapshot stop the backup and then copy the files do another
filesystemfrom the snap and after to the tape. 

Hmm… are you running that on the replica? It should fail; unless you’re running it on the primary.

I wouldn’t bother with pg_start_backup() to take a snapshot backup on the replica.  When recovering, the database will
firstdo its crash recovery and then apply any WAL files needed to reach your recovery target time. 


pgsql-admin by date:

Previous
From: Stephen Frost
Date:
Subject: Re: Backup From HotStandby
Next
From: Licio Matos
Date:
Subject: Re: Backup From HotStandby