Hi, If you want to reduce the amount of data lost, you might want to consider another type of backup : https://www.postgresql.org/docs/current/static/continuous-archiving.html
That awsome tool can also help you with it : https://pgbackrest.org/ On 04/19/2018 08:48 PM, Edmundo Robles 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 > <andr...@a-kretschmer.de <mailto: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 <http://www.2ndQuadrant.com> > > > > > > -- > Kind regards, -- Stefan FERCOT http://dalibo.com - http://dalibo.org
signature.asc
Description: OpenPGP digital signature
