| 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: | Whole Thread | Raw Message | 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
>>
>>
>>
>
>
> --
>
>
| 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 |