Re: Doubts about replication..

From: Laurentius Purba <lpurba(at)sproutloud(dot)com>
To: Edmundo Robles <edmundo(at)sw-argos(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Doubts about replication..
Date: 2018-04-20 21:44:27
Message-ID: CAMfLBnivJ4XiMrpWOHbdfAWL47ad4-OdMfEkg1Fhpos7+qO1qw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)sw-argos(dot)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(at)a-kretschmer(dot)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
>>
>>
>>
>
>
> --
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2018-04-20 22:09:53 Re: New website
Previous Message Adrian Klaver 2018-04-20 21:33:55 Re: Problem with trigger makes Detail record be invalid