Postgres Pro
Downloads
Home   >   mailing lists

Re: Doubts about replication.. - Mailing list pgsql-general

From Edmundo Robles
Subject Re: Doubts about replication..
Date
Msg-id CAOXzpYDejJPcivatfQZhx2sSyRGzj-WBCFGJi3xSdUi=1yqBsg@mail.gmail.com
Whole thread Raw
In response to Re: Doubts about replication..  (Andreas Kretschmer <andreas@a-kretschmer.de>)
Responses Re: Doubts about replication..  (Stefan Fercot <stefan.fercot@dalibo.com>)
Re: Doubts about replication..  (Francisco Olarte <folarte@peoplecall.com>)
Re: Doubts about replication..  (Laurentius Purba <lpurba@sproutloud.com>)
List pgsql-general
Tree view
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@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





--

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Problem with trigger makes Detail record be invalid
Next
From: PegoraroF10
Date:
Subject: Re: Problem with trigger makes Detail record be invalid