Re: row filtering for logical replication

Поиск
Список
Период
Сортировка
От Erik Rijkers
Тема Re: row filtering for logical replication
Дата
Msg-id c1791604db16e94b40ccae60ccaa7a64@xs4all.nl
обсуждение исходный текст
Ответ на Re: row filtering for logical replication  (Euler Taveira <euler@timbira.com.br>)
Список pgsql-hackers
On 2018-11-02 02:59, Euler Taveira wrote:
> Em qui, 1 de nov de 2018 às 05:30, Erik Rijkers <er@xs4all.nl> 
> escreveu:
>> > I ran pgbench-over-logical-replication with a WHERE-clause and could
>> > not get this to do a correct replication.  Below is the output of the
>> > attached test program.
>> >
>> >
>> > $ ./logrep_rowfilter.sh
>> 
> Erik, thanks for testing.
> 
>> So it seems this bug is due to some timing error in your patch (or
>> possibly in logical replication itself).
>> 
> It is a bug in the new synchronization code. I'm doing some code
> cleanup/review and will post a new patchset after I finish it. If you
> want to give it a try again, apply the following patch.
> 
> diff --git a/src/backend/replication/logical/tablesync.c
> b/src/backend/replication/logical/tablesync.c
> index e0eb73c..4797e0b 100644
> --- a/src/backend/replication/logical/tablesync.c
> +++ b/src/backend/replication/logical/tablesync.c
> [...]


That does indeed fix it.

Thank you,

Erik Rijkers



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: COPY FROM WHEN condition
Следующее
От: Antonin Houska
Дата:
Сообщение: Re: Doubts about pushing LIMIT to MergeAppendPath