View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000507 | Pgpool-II | General | public | 2019-05-02 07:06 | 2019-05-17 09:52 |
| Reporter | pio01 | Assigned To | pengbo | ||
| Priority | immediate | Severity | major | Reproducibility | N/A |
| Status | closed | Resolution | open | ||
| Product Version | 3.7.3 | ||||
| Summary | 0000507: show pool_nodes | ||||
| Description | Hi Why all pool_nodes it's in standby role.. how we can fix it? I have attached the pgool configuration. node_id | hostname | port | status | lb_weight | role | select_cnt | load_balance_node | replication_delay ---------+------------+------+--------+-----------+---------+------------+-------------------+------------------- 0 | 10.1.24.13 | 5432 | down | 0.500000 | standby | 0 | false | 0 1 | 10.0.2.67 | 5432 | up | 0.500000 | standby | 60 | true | 0 (2 rows) | ||||
| Tags | No tags attached. | ||||
|
|
|
|
|
Try to restart pgpool by using -D option. If you installed pgpool by RPM, add -D option to "/etc/sysconfig/pgpool" to ignore the pgpool_status file: --- OPTS=" -D -n" --- |
|
|
I have forget to give feedback. Yes we need to restart pgpool with -D option. Thanks for your feedback. |
|
|
Could you mark this issue as "Resolved"? |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2019-05-02 07:06 | pio01 | New Issue | |
| 2019-05-02 07:06 | pio01 | File Added: pgpool.conf | |
| 2019-05-07 08:32 | administrator | Note Added: 0002583 | |
| 2019-05-07 08:32 | administrator | Assigned To | => pengbo |
| 2019-05-07 08:32 | administrator | Status | new => assigned |
| 2019-05-07 17:12 | pio01 | Note Added: 0002587 | |
| 2019-05-07 17:14 | pengbo | Note Added: 0002588 | |
| 2019-05-16 16:18 | administrator | Status | assigned => resolved |
| 2019-05-17 09:52 | administrator | Status | resolved => closed |
