View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000440 | Pgpool-II | General | public | 2018-11-01 22:14 | 2018-11-02 13:53 |
| Reporter | pio01 | Assigned To | |||
| Priority | high | Severity | major | Reproducibility | have not tried |
| Status | resolved | Resolution | open | ||
| Product Version | 3.7.5 | ||||
| Summary | 0000440: pool_nodes status | ||||
| Description | Dear all, How I can change the role status of my primary pg pool_node(10.1.24.18) to become a primary role and the status comes up? postgres=# show pool_nodes; node_id | hostname | port | status | lb_weight | role | select_cnt | load_balance_node | replication_delay ---------+------------+------+--------+-----------+---------+------------+-------------------+------------------- 0 | 10.1.24.18 | 5432 | down | 0.500000 | standby | 0 | false | 0 1 | 10.0.2.159 | 5432 | up | 0.500000 | standby | 0 | true | 0 (2 rows) ---- I would like that : postgres=# show pool_nodes; node_id | hostname | port | status | lb_weight | role | select_cnt | load_balance_node | replication_delay ---------+------------+------+--------+-----------+---------+------------+-------------------+------------------- 0 | 10.1.24.18 | 5432 | up | 0.500000 | primary | 0 | false | 0 1 | 10.0.2.159 | 5432 | up | 0.500000 | standby | 0 | true | 0 (2 rows) | ||||
| Tags | No tags attached. | ||||
|
|
Now it's ok... postgres=# show pool_nodes; node_id | hostname | port | status | lb_weight | role | select_cnt | load_balance_node | replication_delay ---------+------------+------+--------+-----------+---------+------------+-------------------+------------------- 0 | 10.1.24.18 | 5432 | up | 0.500000 | primary | 0 | false | 0 1 | 10.0.2.159 | 5432 | up | 0.500000 | standby | 0 | true | 0 (2 rows) postgres=# I have modify some output in the pgpool.conf and modify the password for the user to connect to the database. - listen_addresses = '*' - backend_hostname0 = '**********196.***' - backend_port0 = 5*** - backend_weight0 = 1 - backend_data_directory0 = '/data/******1' - backend_flag0 = 'ALLOW_TO_FAILOVER' - backend_hostname1 = '**********198.***' - backend_port1 = 5*** - backend_weight1 = 1 - backend_data_directory1 = '/data/******2' - backend_flag1 = 'ALLOW_TO_FAILOVER' - enable_pool_hba = on - logdir = '/var/log/pgpool-II-95' - pid_file_name = '/data/node1/pgpool-II-95/pgpool.pid' - sr_check_user = 'pgpool' - sr_check_password = '*********' |
|
|
OK. I will mark the status to "resolved". |
