[pgpool-general: 5599] Re: Unused status problem

[Tatsuo Ishii]

> Hello,
> 
> I am trying to install pgpool-II.  I have 2 servers both running postgres 9.4 and pgpool is running on one of the servers.  I am trying to do native replication.  I cannot get the second server to work and it shows as unused.
> 
> node_id |   hostname    | port | status | lb_weight |  role  | select_cnt | load_balance_node | replication_delay
> ---------+---------------+------+--------+-----------+--------+------------+-------------------+-------------------
> 0       | localhost     | 5432 | up     | 0.538462  | master | 0          | true              | 0
> 1       | 192.168.33.10 | 5432 | unused | 0.230769  | slave  | 0          | false             | 0
> 
> I am not finding much concerning the unused status so I don’t quite know what to change.

Please remove the bogus entry:

backend_hostname2 = '192.168.33.10'
backend_port2 = 5432
backend_weight2 = .3
backend_data_directory2 = '/var/lib/pgsql/9.4/data'
backend_flag2 = 'ALLOW_TO_FAILOVER'

And try to restart Pgpool-II with -D option. This will remove the
stale status file while starting up.

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