Postgres Pro
Downloads
Home   >   mailing lists

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

From Laurentius Purba
Subject Re: Doubts about replication..
Date
Msg-id CAMfLBnivJ4XiMrpWOHbdfAWL47ad4-OdMfEkg1Fhpos7+qO1qw@mail.gmail.com
Whole thread Raw
In response to Re: Doubts about replication..  (Edmundo Robles <edmundo@sw-argos.com>)
List pgsql-general
Tree view
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@sw-argos.com> 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@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: Adrian Klaver
Date:
Subject: Re: New website