Re: Allow logical replication to copy tables in binary format

Поиск
Список
Период
Сортировка
От Peter Smith
Тема Re: Allow logical replication to copy tables in binary format
Дата
Msg-id CAHut+Pubvnb3vD1W7ZpRHzjoQgusr2TZp4diPuJ7tJBmELNzQw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Allow logical replication to copy tables in binary format  (Melih Mutlu <m.melihmutlu@gmail.com>)
Ответы Re: Allow logical replication to copy tables in binary format  (Amit Kapila <amit.kapila16@gmail.com>)
Список pgsql-hackers
There are a couple of TAP tests where the copy binary is expected to
fail. And when it fails, you do binary=false (changing the format back
to 'text') so the test is then expected to be able to proceed.

I don't know if this happens in practice, but IIUC in theory, if the
timing is extremely bad, the tablesync could relaunch in binary mode
multiple times (any fail multiple times?) before your binary=false
change takes effect.

So, I was wondering if it could help to use the subscription
'disable_on_error=true' parameter for those cases so that the
tablesync won't needlessly attempt to relaunch until you have set
binary=false and then re-enabled the subscription.

------
Kind Regards,
Peter Smith.
Fujitsu Australia



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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: Fix fseek() detection of unseekable files on WIN32
Следующее
От: Thomas Munro
Дата:
Сообщение: Re: Commitfest 2023-03 starting tomorrow!