Re: Barman disaster recovery solution

On 27/2/19 4:16 μ.μ., David Steele wrote:
> On 2/27/19 2:31 PM, Achilleas Mantzios wrote:
>> On 27/2/19 1:58 μ.μ., richter@simkorp.com.br wrote:
>>> Just to notice, I d o use backup from standby and WAL archive from standby. It is possible. But you have to
configurestandby with option of wal archive "always".
 
>>
>> I guess there are issues with it. If this was so easy then pgbarman and pgbackrest would support it out of the box.
>
> There are a few issues with it:
>
> 1) If you allow the primary and standby to archive to the same repository then there needs to be some conflict
resolutionif they write at the same time.  If they write to different repositories 
 
> then you need to decided which one to use for a restore, or have some kind of conflict resolution between them.  It
getscomplicated.
 
>
> 2) Writing only from the standby reduces load on the primary but if the connection to the primary is down then you
canget behind on archiving. If something then happens to the primary then your 
 
> recovery point will be limited.

David to quote an older email from you:
"pgBackRest currently requires some files and all WAL to be sent from the primary even when doing backup from standby. 
Wemay improve this in the future but it's not on the road map right now. "
 
So, I had the impression that receiving WALs from the standby was a greater technical problem.

>
> Regards,


-- 
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt