Content-Type: text/plain;
	charset=utf-8
Mime-Version: 1.0 (Mac OS X Mail 12.4 \(3445.104.11\))
Subject: Re: Backup From HotStandby
From: Rui DeSousa <rui@crazybean.net>
In-Reply-To: 
 <CAK6Tc4MPUUTK1y0pjW=ON2R6Y-O+ch+T5G_pkb6p4vFxSCFV9A@mail.gmail.com>
Date: Wed, 28 Aug 2019 16:09:57 -0400
Cc: Jeff Janes <jeff.janes@gmail.com>,
 pgsql-admin@lists.postgresql.org
Content-Transfer-Encoding: quoted-printable
Message-Id: <1F62FCE5-E2AB-4307-81C4-859208B24865@crazybean.net>
References: 
 <CAK6Tc4OFMQA9Nb7rh2bnQkUyHjO=oAThWFGWTP0P-c9+jzAWXQ@mail.gmail.com>
 <CAMkU=1yOQ=9sGktkodafbsS_V0Fdtmxio_NkoGXnnnOXbWh8GQ@mail.gmail.com>
 <CAK6Tc4P+pKCeu31RZe-Exi9KC=mLVX6DSdGe6v+zCikjdcCv=g@mail.gmail.com>
 <61A32609-4552-4F4D-9B88-EF15C06010C1@crazybean.net>
 <CAK6Tc4MPUUTK1y0pjW=ON2R6Y-O+ch+T5G_pkb6p4vFxSCFV9A@mail.gmail.com>
To: Licio Matos <licio.matos@gmail.com>
Precedence: bulk


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

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.   =20


> 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=E2=80=A6 are you running that on the replica? It should fail; unless =
you=E2=80=99re running it on the primary.=20

I wouldn=E2=80=99t 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.=