Re: Backup From HotStandby

Jeff Janes <[email protected]> Wed, 28 Aug 2019 14:24:45 -0400

Newsgroups	gmane.comp.db.postgresql.admin
Message-ID	<CAMkU=1yOQ=9sGktkodafbsS_V0Fdtmxio_NkoGXnnnOXbWh8GQ@mail.gmail.com>

On Wed, Aug 28, 2019 at 1:42 PM Licio Matos <[email protected]> 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