View Issue Details

IDProjectCategoryView StatusLast Update
0000440Pgpool-II[All Projects] Generalpublic2018-11-02 13:53
Reporterpio01Assigned To 
PriorityhighSeveritymajorReproducibilityhave not tried
Status resolvedResolutionopen 
Product Version3.7.5 
Target VersionFixed in Version 
Summary0000440: pool_nodes status
DescriptionDear 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)

TagsNo tags attached.

Activities

pio01

2018-11-01 22:49

reporter   ~0002234

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 = '*********'

pengbo

2018-11-02 13:53

developer   ~0002235

OK. I will mark the status to "resolved".

Issue History

Date Modified Username Field Change
2018-11-01 22:14 pio01 New Issue
2018-11-01 22:49 pio01 Note Added: 0002234
2018-11-02 13:53 pengbo Note Added: 0002235
2018-11-02 13:53 pengbo Status new => resolved