I use Barman, and I am happy with it.
Just in case you want to try different tools, https://github.com/dhamaniasad/awesome-postgres.
On Thu, Apr 19, 2018 at 2:48 PM, Edmundo Robles <edmundo@xxxxxxxxxxxx> wrote:
Yes, you are right, the replication is not a backup ;) , actually i backup database daily at 3:00 am but if database crash, the amount of data is big! that is the reason i want to replicate to reduce the data loss. By the way a few days ago a job partner did a delete with no where.--On Thu, Apr 19, 2018 at 1:33 PM, Andreas Kretschmer <andreas@xxxxxxxxxxxxxxx> wrote:
Am 19.04.2018 um 19:57 schrieb Edmundo Robles:
I will use replication as simple backup.
please keep in mind, replication is not a backup. All logical errors on the master (delete from table and forgot the where-condition) will replicated to the standby.
Andreas
--
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com