@Rui DeSousa
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 <rui@xxxxxxxxxxxxx> escreveu:
> On Aug 28, 2019, at 3:31 PM, Licio Matos <licio.matos@xxxxxxxxx> 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.
