[pgpool-general: 9371] Re: Raw mode and failback

[Tatsuo Ishii]

> Hello, "raw" mode states that it "does not care about the database
> synchronization" so this should applies to auto_failback too doesn't
> it ?

The key is "It's user's responsibility to make the whole system does a
meaningful thing." which follows the sentence "Pgpool-II does not care
about the database synchronization." in the raw mode doc.

> So if I want a way to implements that, I should have process check for
> node status and attach them back to the pool when they become
> available ?

Yes.

> That's okay with me, I just want to be sure about pgpool stance on
> this :)

Our stance is, let user handle bring back the previous down node in
raw mode.

Best reagards,
--
Tatsuo Ishii
SRA OSS K.K.
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp

> Many thanks
> 
> Le 18/02/2025 à 12:43, Bo Peng a écrit :
>> Hi,
>>
>>> In raw mode Pgpool does not care about the database synchronization,
>>> so
>>> would it be possible to use auto_failback ?
>> In raw mode, auto_failback is not supported because Pgpool-II
>> cannot ensure that the standby node is healthy.
>>
>> On Thu, 13 Feb 2025 11:26:25 +0100
>> Charly Koza <cka at f4-group.com> wrote:
>>
>>> Hello ! I have a question about raw mode and failback
>>>
>>> In raw mode (as far as I can tell), when a backend has an issue
>>> (network
>>> error, restart), it's "detached" from the pool and does not come back
>>> in
>>> the pool automatically(no failback).
>>>
>>> I'd like for said backend to come back to the pool asap.
>>>
>>> In raw mode Pgpool does not care about the database synchronization,
>>> so
>>> would it be possible to use auto_failback ?
>>>
>>> Or am I missing something ?
>>>
>>> Many thanks
>>>
>>> _______________________________________________
>>> pgpool-general mailing list
>>> pgpool-general at pgpool.net
>>> http://www.pgpool.net/mailman/listinfo/pgpool-general
>>
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general