[pgpool-general: 4803] Re: 3 or more postgres backends and failover.

Tema Zelikin gunslinger at nightflame.info
Thu Jul 21 17:34:19 JST 2016


21.07.2016 11:07, Tatsuo Ishii пишет:
>>>> Ok, youngest node id makes sense. Thanks. But why does it needs to
>>>> start with 0? As i understand, its an arbitrary number set in config
>>>> file, but when i set backends starting with "backend1_*", i've got
>>>> empty node with node_id 0 in "show pool_nodes".
>>> That's how pgpool-II is implemented. Do you have any specific reason
>>> to want to start with backend1_*, rather than backend_0*?
>>>
>> Not as such, no. Its just when i use pgpool in conjunction with repmgr
>> (which also uses arbitrary node ids), i want to use the same ids and not
>> always start with 0. Just a matter of good looks.
> Intersting. repmgr wants to start from 1, rather than 0, I guess.
>
Yes. So when i generate configuration files by ansible, i need to
subtract 1 from node id. As you can guess, its not veryconvenient and
requires some workarounds.


More information about the pgpool-general mailing list