[pgpool-general: 2701] Re: pgpool builtin watchdog and order of the backend nodes

Tatsuo Ishii ishii at postgresql.org
Fri Apr 4 08:10:51 JST 2014


I'm a little bit confused. Can you show your pgpool.conf?

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> Hi!
> 
> Just a simple question:
> 
> Is the order of the nodes important for the pgpool cluster-members?
> I guess the answer is no, since only one pool member will be active at any
> time, the only important is to enumerate all the backends for all the pool
> members...
> 
> But still I would like to know.
> 
> Currently I use localhost as backend0 for all the nodes, and enumerate all
> other backends in some order starting from backend1.
> The configs are generated from data tables (called pillars) by saltstack,
> currently I do not specify any order.
> 
> The only strange thing is, that running pcp_node_info gives different
> result for the same node number on all members.
> 
> Regards,
> Attila


More information about the pgpool-general mailing list