Re: logical replication restrictions

From: Marcos Pegoraro <marcos(at)f10(dot)com(dot)br>
To: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
Cc: Euler Taveira <euler(at)eulerto(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: logical replication restrictions
Date: 2021-09-23 10:22:59
Message-ID: CAB-JLwYPHDhd_esvv5zDLRJoQCavz5Le9EhCPAQE33JAfKmGPg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

>
> What kind of reasons do you see where users prefer to delay except to
> avoid data loss in the case where users unintentionally removed some
> data from the primary?
>
>
> Debugging. Suppose I have a problem, but that problem occurs once a week
or a month. When this problem occurs again a monitoring system sends me a
message ... Hey, that problem occurred again. Then, as I configured my
replica to Delay = '30 min', I have time to connect to it and wait, record
by record coming and see exactly what made that mistake.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2021-09-23 10:27:17 Re: logical decoding and replication of sequences
Previous Message Amit Kapila 2021-09-23 10:18:57 Re: Column Filtering in Logical Replication