Re: Exit walsender before confirming remote flush in logical replication
От
Vitaly Davydov
Тема
Re: Exit walsender before confirming remote flush in logical replication
Дата
Msg-id
1a9d89-68d67480-1b-29edfa00@90613631
Ответ на
Re: Exit walsender before confirming remote flush in logical replication (Greg Sabino Mullane)
Список
Дерево обсуждения
Exit walsender before confirming remote flush in logical replication "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
Re: Exit walsender before confirming remote flush in logical replication Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>
Re: Exit walsender before confirming remote flush in logical replication Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: Exit walsender before confirming remote flush in logical replication Amit Kapila <amit.kapila16@gmail.com>
RE: Exit walsender before confirming remote flush in logical replication "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
RE: Exit walsender before confirming remote flush in logical replication "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
Re: Exit walsender before confirming remote flush in logical replication Dilip Kumar <dilipbalaut@gmail.com>
RE: Exit walsender before confirming remote flush in logical replication "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
Re: Exit walsender before confirming remote flush in logical replication Amit Kapila <amit.kapila16@gmail.com>
Re: Exit walsender before confirming remote flush in logical replication Amit Kapila <amit.kapila16@gmail.com>
RE: Exit walsender before confirming remote flush in logical replication "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
Re: Exit walsender before confirming remote flush in logical replication Amit Kapila <amit.kapila16@gmail.com>
RE: Exit walsender before confirming remote flush in logical replication "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
Re: Exit walsender before confirming remote flush in logical replication Kyotaro Horiguchi <horikyota.ntt@gmail.com>
RE: Exit walsender before confirming remote flush in logical replication "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
Re: Exit walsender before confirming remote flush in logical replication Amit Kapila <amit.kapila16@gmail.com>
Re: Exit walsender before confirming remote flush in logical replication Amit Kapila <amit.kapila16@gmail.com>
Re: Exit walsender before confirming remote flush in logical replication Masahiko Sawada <sawada.mshk@gmail.com>
Re: Exit walsender before confirming remote flush in logical replication Amit Kapila <amit.kapila16@gmail.com>
Re: Exit walsender before confirming remote flush in logical replication Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: Exit walsender before confirming remote flush in logical replication Amit Kapila <amit.kapila16@gmail.com>
Re: Exit walsender before confirming remote flush in logical replication Masahiko Sawada <sawada.mshk@gmail.com>
Re: Exit walsender before confirming remote flush in logical replication Amit Kapila <amit.kapila16@gmail.com>
Re: Exit walsender before confirming remote flush in logical replication Andres Freund <andres@anarazel.de>
Re: Exit walsender before confirming remote flush in logical replication Amit Kapila <amit.kapila16@gmail.com>
Re: Exit walsender before confirming remote flush in logical replication Andres Freund <andres@anarazel.de>
Re: Exit walsender before confirming remote flush in logical replication Amit Kapila <amit.kapila16@gmail.com>
Re: Exit walsender before confirming remote flush in logical replication Andres Freund <andres@anarazel.de>
Re: Exit walsender before confirming remote flush in logical replication Amit Kapila <amit.kapila16@gmail.com>
Re: Exit walsender before confirming remote flush in logical replication Andres Freund <andres@anarazel.de>
RE: Exit walsender before confirming remote flush in logical replication "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
RE: Exit walsender before confirming remote flush in logical replication "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
RE: Exit walsender before confirming remote flush in logical replication "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
Re: Exit walsender before confirming remote flush in logical replication Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: Exit walsender before confirming remote flush in logical replication Amit Kapila <amit.kapila16@gmail.com>
RE: Exit walsender before confirming remote flush in logical replication "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
RE: Exit walsender before confirming remote flush in logical replication "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
RE: Exit walsender before confirming remote flush in logical replication "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
Re: Exit walsender before confirming remote flush in logical replication Masahiko Sawada <sawada.mshk@gmail.com>
RE: Exit walsender before confirming remote flush in logical replication "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
RE: Exit walsender before confirming remote flush in logical replication "Takamichi Osumi (Fujitsu)" <osumi.takamichi@fujitsu.com>
RE: Exit walsender before confirming remote flush in logical replication "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
Re: Exit walsender before confirming remote flush in logical replication Peter Smith <smithpb2250@gmail.com>
RE: Exit walsender before confirming remote flush in logical replication "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
Re: Exit walsender before confirming remote flush in logical replication Andrey Silitskiy <a.silitskiy@postgrespro.ru>
Re: Exit walsender before confirming remote flush in logical replication Fujii Masao <masao.fujii@gmail.com>
Re: Exit walsender before confirming remote flush in logical replication Andrey Silitskiy <a.silitskiy@postgrespro.ru>
Re: Exit walsender before confirming remote flush in logical replication Fujii Masao <masao.fujii@gmail.com>
Re: Exit walsender before confirming remote flush in logical replication Andrey Silitskiy <a.silitskiy@postgrespro.ru>
Re: Exit walsender before confirming remote flush in logical replication Fujii Masao <masao.fujii@gmail.com>
Re: Exit walsender before confirming remote flush in logical replication Andrey Silitskiy <a.silitskiy@postgrespro.ru>
Re: Exit walsender before confirming remote flush in logical replication Fujii Masao <masao.fujii@gmail.com>
Re: Exit walsender before confirming remote flush in logical replication Vitaly Davydov <v.davydov@postgrespro.ru>
Re: Exit walsender before confirming remote flush in logical replication Andrey Silitskiy <a.silitskiy@postgrespro.ru>
Re: Exit walsender before confirming remote flush in logical replication Fujii Masao <masao.fujii@gmail.com>
Re: Exit walsender before confirming remote flush in logical replication Andrey Silitskiy <a.silitskiy@postgrespro.ru>
Re: Exit walsender before confirming remote flush in logical replication Andrey Silitskiy <a.silitskiy@postgrespro.ru>
Re: Exit walsender before confirming remote flush in logical replication Michael Paquier <michael@paquier.xyz>
Re: Exit walsender before confirming remote flush in logical replication Andrey Silitskiy <a.silitskiy@postgrespro.ru>
Re: Exit walsender before confirming remote flush in logical replication Fujii Masao <masao.fujii@gmail.com>
Re: Exit walsender before confirming remote flush in logical replication Ronan Dunklau <ronan@dunklau.fr>
Re: Exit walsender before confirming remote flush in logical replication Andrey Silitskiy <a.silitskiy@postgrespro.ru>
Re: Exit walsender before confirming remote flush in logical replication Ronan Dunklau <ronan@dunklau.fr>
Re: Exit walsender before confirming remote flush in logical replication Andrey Silitskiy <a.silitskiy@postgrespro.ru>
Re: Exit walsender before confirming remote flush in logical replication Japin Li <japinli@hotmail.com>
Re: Exit walsender before confirming remote flush in logical replication Andrey Silitskiy <a.silitskiy@postgrespro.ru>
Re: Exit walsender before confirming remote flush in logical replication Alexander Korotkov <aekorotkov@gmail.com>
Re: Exit walsender before confirming remote flush in logical replication Greg Sabino Mullane <htamfids@gmail.com>
Re: Exit walsender before confirming remote flush in logical replication Andrey Silitskiy <a.silitskiy@postgrespro.ru>
Re: Exit walsender before confirming remote flush in logical replication Greg Sabino Mullane <htamfids@gmail.com>
Re: Exit walsender before confirming remote flush in logical replication Andrey Silitskiy <a.silitskiy@postgrespro.ru>
Re: Exit walsender before confirming remote flush in logical replication Fujii Masao <masao.fujii@gmail.com>
Re: Exit walsender before confirming remote flush in logical replication Alexander Korotkov <aekorotkov@gmail.com>
Re: Exit walsender before confirming remote flush in logical replication Andrey Silitskiy <a.silitskiy@postgrespro.ru>
Re: Exit walsender before confirming remote flush in logical replication Andrey Silitskiy <a.silitskiy@postgrespro.ru>
Re: Exit walsender before confirming remote flush in logical replication Fujii Masao <masao.fujii@gmail.com>
Re: Exit walsender before confirming remote flush in logical replication Fujii Masao <masao.fujii@gmail.com>
Re: Exit walsender before confirming remote flush in logical replication Andrey Silitskiy <a.silitskiy@postgrespro.ru>
Re: Exit walsender before confirming remote flush in logical replication Fujii Masao <masao.fujii@gmail.com>
Re: Exit walsender before confirming remote flush in logical replication Fujii Masao <masao.fujii@gmail.com>
Re: Exit walsender before confirming remote flush in logical replication Andres Freund <andres@anarazel.de>
Re: Exit walsender before confirming remote flush in logical replication Evgeny Voropaev <evgeny.voropaev@tantorlabs.com>
Re: Exit walsender before confirming remote flush in logical replication Alexander Lakhin <exclusion@gmail.com>
Re: Exit walsender before confirming remote flush in logical replication Fujii Masao <masao.fujii@gmail.com>
Re: Exit walsender before confirming remote flush in logical replication Chao Li <li.evan.chao@gmail.com>
Re: Exit walsender before confirming remote flush in logical replication Fujii Masao <masao.fujii@gmail.com>
Re: Exit walsender before confirming remote flush in logical replication Chao Li <li.evan.chao@gmail.com>
Re: Exit walsender before confirming remote flush in logical replication Fujii Masao <masao.fujii@gmail.com>
Re: Exit walsender before confirming remote flush in logical replication Fujii Masao <masao.fujii@gmail.com>
Re: Exit walsender before confirming remote flush in logical replication Chao Li <li.evan.chao@gmail.com>
Re: Exit walsender before confirming remote flush in logical replication Fujii Masao <masao.fujii@gmail.com>
Re: Exit walsender before confirming remote flush in logical replication Chao Li <li.evan.chao@gmail.com>
Re: Exit walsender before confirming remote flush in logical replication Fujii Masao <masao.fujii@gmail.com>
Re: Exit walsender before confirming remote flush in logical replication Fujii Masao <masao.fujii@gmail.com>
Re: Exit walsender before confirming remote flush in logical replication Vitaly Davydov <v.davydov@postgrespro.ru>
Re: Exit walsender before confirming remote flush in logical replication Greg Sabino Mullane <htamfids@gmail.com>
Re: Exit walsender before confirming remote flush in logical replication Alexander Korotkov <aekorotkov@gmail.com>
Re: Exit walsender before confirming remote flush in logical replication Fujii Masao <masao.fujii@gmail.com>
Re: Exit walsender before confirming remote flush in logical replication Andrey Silitskiy <a.silitskiy@postgrespro.ru>
RE: Exit walsender before confirming remote flush in logical replication "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
Re: Exit walsender before confirming remote flush in logical replication Andrey Silitskiy <a.silitskiy@postgrespro.ru>
Re: Exit walsender before confirming remote flush in logical replication Amit Kapila <amit.kapila16@gmail.com>
RE: Exit walsender before confirming remote flush in logical replication "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
Re: Exit walsender before confirming remote flush in logical replication Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: Exit walsender before confirming remote flush in logical replication Amit Kapila <amit.kapila16@gmail.com>
Re: Exit walsender before confirming remote flush in logical replication Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: Exit walsender before confirming remote flush in logical replication Andres Freund <andres@anarazel.de>
Re: Exit walsender before confirming remote flush in logical replication Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: Exit walsender before confirming remote flush in logical replication Greg Sabino Mullane <htamfids@gmail.com>
Re: Exit walsender before confirming remote flush in logical replication "Vitaly Davydov" <v.davydov@postgrespro.ru>
Re: Exit walsender before confirming remote flush in logical replication Peter Smith <smithpb2250@gmail.com>
RE: Exit walsender before confirming remote flush in logical replication "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
Re: Exit walsender before confirming remote flush in logical replication Amit Kapila <amit.kapila16@gmail.com>
Re: Exit walsender before confirming remote flush in logical replication Dilip Kumar <dilipbalaut@gmail.com>
RE: Exit walsender before confirming remote flush in logical replication "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
RE: Exit walsender before confirming remote flush in logical replication "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
RE: Exit walsender before confirming remote flush in logical replication "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
Re: Exit walsender before confirming remote flush in logical replication Amit Kapila <amit.kapila16@gmail.com>
Re: Exit walsender before confirming remote flush in logical replication Kyotaro Horiguchi <horikyota.ntt@gmail.com>
RE: Exit walsender before confirming remote flush in logical replication "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
Dear Greg, All I'm interested in walsender shutdown mode option as well. Unexpected waiting for wal sender shutdown in fast mode creates some problems to follow a SLA. I also propose to create a GUC which can be used to set the shutdown mode globally. Once, the original author was not responded for some time, I like the idea to create a new separate patch for walsender shutdown mode based on the work in this thread. I'm ready to participate in patch preparation and testing. With best regards, Vitaly On Tuesday, September 17, 2024 15:29 MSK, Greg Sabino Mullane wrote: > Thanks for everyone's work on this, I am very interested in it getting into > a release. What is the status of this? > > My use case is Patroni - when it needs to do a failover, it shuts down the > primary. However, large transactions can cause it to stay in the "shutting > down" state for a long time, which means your entire HA system is now > non-functional. I like the idea of a new flag. I'll test this out soon if > the original authors want to make a rebased patch. This thread is old, so > if I don't hear back in a bit, I'll create and test a new one myself. :) > > Cheers, > Greg
В списке pgsql-hackers по дате отправления
От: shveta malik
Дата:
От: Dilip Kumar
Дата: