Re: Barman disaster recovery solution

Em 27/02/2019 09:31, Achilleas Mantzios escreveu:
> 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 configure standby 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.



Well,


This setup it is working really well for past two years; prior to that, 
we used backup from primary server.

We have about 50 databases, half terabyte in total, primary and standby 
separated geographically.

We had to write special app to monitor if standby is behind primary (it 
compares the transaction id between primary and standby).

For eight years, we had no single failure from PgSQL databases (using 
since 9.0 and today on 9.6), replication is for "just in case" data 
center unavailability, and backup is for disaster recovery (in case two 
data centers in different states from different vendors get out of work 
at same time).


But we give no chance to bad luck: we monitor replication status every 2 
minutes, we make full backup every 2 days with incremental backup in 
between, and test all backups on a recover server every day. As pointed, 
we have no single database failure that required to use the replication 
server or the backup server, but we will not lower the attention.


Regards,


Edson


>
>>
>> Just my 2c,
>>
>> Edson Richter
>>
>> /Enviado do meu Telefone LG/
>>
>> ------ Mensagem original------
>> *De: *Achilleas Mantzios
>> *Data: *qua, 27 de fev de 2019 06:40
>> *Para: *pgsql-general@lists.postgresql.org 
>> <mailto:pgsql-general@lists.postgresql.org>;
>> *Cc:*
>> *As! sunto:*Re: Barman disaster recovery solution
>>
>> On 21/2/19 9:28 π.μ., Achilleas Mantzios wrote:
>>> On 21/2/19 9:17 π.μ., Julie Nishimura wrote:
>>>> Does anyone use this solution? any recommenations?
>>>>
>>>> Thanks!
>>>
>>> Barman will fit most requirements. PgBackRest excels when WAL 
>>> traffic goes on 100000 files/day or more. I have written an article, 
>>> not yet publised, on a comparison on the 3 most known solutions. 
>>> Will post a link as soon as it gets published.
>>
>> Hello, as promised here is my blog :
>> https://severalnines.com/blog/current-state-open-source-backup-management-postgresql
>>
>>>
>>> -- 
>>> Achilleas Mantzios
>>> IT DEV Lead
>>> IT DEPT
>>> Dynacom Tankers Mgmt
>>
>>
>> -- 
>> Achilleas Mantzios
>> IT DEV Lead
>> IT DEPT
>> Dynacom Tankers Mgmt
>
>
> -- 
> Achilleas Mantzios
> IT DEV Lead
> IT DEPT
> Dynacom Tankers Mgmt