Search Postgresql Archives

Re: Barman disaster recovery solution

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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







[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux