Re: row filtering for logical replication - Mailing list pgsql-hackers

From Fabrízio de Royes Mello
Subject Re: row filtering for logical replication
Date
Msg-id CAFcNs+pA9ywYJbf940UFXW5B5i+An3=0yzxC8_bXubu+CsOQ=A@mail.gmail.com
Whole thread Raw
In response to Re: row filtering for logical replication  (Petr Jelinek <petr.jelinek@2ndquadrant.com>)
Responses Re: row filtering for logical replication  (Stephen Frost <sfrost@snowman.net>)
Re: row filtering for logical replication  (Petr Jelinek <petr.jelinek@2ndquadrant.com>)
List pgsql-hackers

On Fri, Nov 23, 2018 at 4:13 PM Petr Jelinek <petr.jelinek@2ndquadrant.com> wrote:
>
> >
> > If carefully documented I see no problem with it... we already have an
> > analogous problem with functional indexes.
>
> The difference is that with functional indexes you can recreate the
> missing object and everything is okay again. With logical replication
> recreating the object will not help.
>

In this case with logical replication you should rsync the object. That is the price of misunderstanding / bad use of the new feature.

As usual, there are no free beer ;-)

Regards,

--
   Fabrízio de Royes Mello         Timbira - http://www.timbira.com.br/
   PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento

pgsql-hackers by date:

Previous
From: Petr Jelinek
Date:
Subject: Re: row filtering for logical replication
Next
From: Tom Lane
Date:
Subject: Re: 64-bit hash function for hstore and citext data type