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 <andr...@a-kretschmer.de > 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 > > > --