Postgres Pro
Downloads
Home   >   mailing lists

Re: Backup From HotStandby - Mailing list pgsql-admin

From Licio Matos
Subject Re: Backup From HotStandby
Date
Msg-id CAK6Tc4P+pKCeu31RZe-Exi9KC=mLVX6DSdGe6v+zCikjdcCv=g@mail.gmail.com
Whole thread Raw
In response to Re: Backup From HotStandby  (Jeff Janes <jeff.janes@gmail.com>)
Responses Re: Backup From HotStandby  (Rui DeSousa <rui@crazybean.net>)
Re: Backup From HotStandby  (Stephen Frost <sfrost@snowman.net>)
List pgsql-admin
Tree view
Tks Jeff,

But in this case i am not using pg_basebackup, but i make pg_start_backup() and pg_stop_backup() in the script and make a snapshot.
So, i believe this work too, right?

Tks again.

Licio Matos

Em qua, 28 de ago de 2019 às 15:24, Jeff Janes <jeff.janes@gmail.com> escreveu:
On Wed, Aug 28, 2019 at 1:42 PM Licio Matos <licio.matos@gmail.com> wrote:
Hi Guys,

Is it possible to make a backup snapshot from a hotstandby (slave) that is receiving WAL stream from a master on postgresql 9.6?

 Yes, but with some restrictions.  See the docs for your version (https://www.postgresql.org/docs/9.6/app-pgbasebackup.html) starting with "pg_basebackup can make a base backup from not only the master but also the standby."

Cheers,

Jeff

pgsql-admin by date:

Previous
From: Jeff Janes
Date:
Subject: Re: Backup From HotStandby
Next
From: Rui DeSousa
Date:
Subject: Re: Backup From HotStandby