Re: Backup From HotStandby

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 <[email protected]>
escreveu:

> 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
>