| From: | Rui DeSousa <rui(at)crazybean(dot)net> |
|---|---|
| To: | Licio Matos <licio(dot)matos(at)gmail(dot)com> |
| Cc: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com>, pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Backup From HotStandby |
| Date: | 2019-08-28 20:09:57 |
| Message-ID: | 1F62FCE5-E2AB-4307-81C4-859208B24865@crazybean.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
> On Aug 28, 2019, at 3:31 PM, Licio Matos <licio(dot)matos(at)gmail(dot)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 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Licio Matos | 2019-08-28 20:11:23 | Re: Backup From HotStandby |
| Previous Message | Stephen Frost | 2019-08-28 19:33:15 | Re: Backup From HotStandby |