Re: Backup From HotStandby

@Rui DeSousa <[email protected]>

I am running this on the primary, the question is if i can run this same
script on the replica.

Tks
*Licio Matos*




Em qua, 28 de ago de 2019 às 17:09, Rui DeSousa <[email protected]>
escreveu:

>
>
> > On Aug 28, 2019, at 3:31 PM, Licio Matos <[email protected]> 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 filesystem before 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 filesystem from 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 first do its crash recovery
> and then apply any WAL files needed to reach your recovery target time.