Em 27/02/2019 12:12, Achilleas Mantzios escreveu:
On 27/2/19 5:04 μ.μ., Edson Carlos Ericksson Richter wrote:
Em 27/02/2019 09:31, Achilleas Mantzios escreveu:
On 27/2/19 1:58 μ.μ., richter@xxxxxxxxxxxxxx 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.
Using which tool?
Barman.
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.
Which means you tested your backups?
Recover and run our main app on it.
Regards,
Edson
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@xxxxxxxxxxxxxxxxxxxx
<mailto:pgsql-general@xxxxxxxxxxxxxxxxxxxx>;
*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
