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
