| From: | Edmundo Robles <edmundo(at)sw-argos(dot)com> |
|---|---|
| To: | |
| Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Doubts about replication.. |
| Date: | 2018-04-19 18:48:15 |
| Message-ID: | CAOXzpYDejJPcivatfQZhx2sSyRGzj-WBCFGJi3xSdUi=1yqBsg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 | PegoraroF10 | 2018-04-19 18:52:09 | Re: Problem with trigger makes Detail record be invalid |
| Previous Message | Adrian Klaver | 2018-04-19 18:44:20 | Re: Problem with trigger makes Detail record be invalid |