[pgpool-general: 6458] Re: Load balancing and unused status

Pierre Timmermans ptim007 at yahoo.com
Fri Mar 15 03:36:33 JST 2019


For some reason the status is unused, it should be up or down.
I think you should stop pgpool, remove the file /tmp/pgpool_status, then restart pgpool. The file /tmp/pgpool_status is used by pgpool to record the status of the node. When the file is not there it will create it at startup
Regards, 
Pierre 

    On Thursday, March 14, 2019, 7:32:04 PM GMT+1, Fernando Luizão <fernandoluizao at gmail.com> wrote:  
 
 Hi,
I'm new to pgpool, and I'm trying to use the load balancer. I have a primary and a hot standby, using native streaming replication.
Versions: postgresql - 11.2pgpool - 4.0.2
Here's what I changed in pgpool.conf:
listen_addresses = '*'port = 5432
backend_hostname0 = '192.168.51.186'backend_port0 = 5433backend_weight0 = 0.4backend_data_directory0 = '/var/lib/postgresql/11/main'backend_flag0 = 'ALWAYS_MASTER'
backend_hostname1 = '192.168.51.185'backend_port1 = 5433backend_weight1 = 0.6backend_data_directory1 = '/var/lib/postgresql/11/main'
load_balance_mode = on
master_slave_mode = onmaster_slave_sub_mode = 'stream'
However, when I inspect the nodes on pgpool, I get the following:
postgres=# show pool_nodes; node_id |    hostname    | port | status | lb_weight |  role   | select_cnt | load_balance_node | replication_delay | last_status_change  ---------+----------------+------+--------+-----------+---------+------------+-------------------+-------------------+--------------------- 0       | 192.168.51.186 | 5433 | up     | 0.400000  | primary | 6113       | true              | 0                 | 2019-03-14 11:39:15 1       | 192.168.51.185 | 5433 | unused | 0.600000  | standby | 0          | false             | 0                 | 2019-03-14 11:39:15
All queries are being redirected to primary. I can query the standby directly, so everything seems fine with my replication setup.
Why it says the standby is unused? I'm missing something in the configuration?
Thanks,
Fernando_______________________________________________
pgpool-general mailing list
pgpool-general at pgpool.net
http://www.pgpool.net/mailman/listinfo/pgpool-general
  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20190314/9c7f80b1/attachment-0001.html>


More information about the pgpool-general mailing list