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 <jeff(dot)janes(at)gmail(dot)com>
escreveu:

> On Wed, Aug 28, 2019 at 1:42 PM Licio Matos <licio(dot)matos(at)gmail(dot)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
>