View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000623 | Pgpool-II | Bug | public | 2020-06-23 23:32 | 2020-09-14 14:40 |
| Reporter | eldad | Assigned To | pengbo | ||
| Priority | low | Severity | minor | Reproducibility | always |
| Status | closed | Resolution | open | ||
| Platform | aws | OS | Linux | OS Version | CentOS 7.8 |
| Product Version | 4.1.2 | ||||
| Summary | 0000623: Show pool_nodes not showing full data | ||||
| Description | I'm using PostgreSQL 12.3 with pgpool 4.1.2. show pool_nodes doesn't show replication_state | replication_sync_state -bash-4.2$ psql -U postgres -p 5400 -h ***** -c 'show pool_nodes' node_id | hostname | port | status | lb_weight | role | select_cnt | load_balance_node | replication_delay | replication_state | replication_sync_state | last_status_change ---------+----------------+------+--------+-----------+---------+------------+-------------------+-------------------+-------------------+------------------------ +--------------------- 0 | lreorgprdpdb01 | 5432 | up | 0.000000 | primary | 0 | true | 0 | | | 2020-06-23 07:14:06 1 | lreorgprdpdb02 | 5432 | up | 1.000000 | standby | 0 | false | 0 | | | 2020-06-23 07:14:06 (2 rows) | ||||
| Additional Information | master_slave_mode = on master_slave_sub_mode = 'stream' | ||||
| Tags | No tags attached. | ||||
|
|
You need to configure "backend_application_name" which is specified in "primary_conninfo". https://www.pgpool.net/docs/latest/en/html/runtime-config-backend-settings.html#GUC-BACKEND-APPLICATION-NAME |
|
|
Hi, application name is "walreceiver" as seen in pg_stat_replication. I have wrote it in the backend_application_name0 and backend_application_name1 and reload the pgpool. Still get same result. Regards, Eldad |
|
|
You need to restart pgpool. |
|
|
Have you resolved this issue? If you have resolved this issue, I am going to close this one. |
|
|
Close issue. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2020-06-23 23:32 | eldad | New Issue | |
| 2020-06-23 23:47 | pengbo | Assigned To | => pengbo |
| 2020-06-23 23:47 | pengbo | Status | new => assigned |
| 2020-06-23 23:49 | pengbo | Note Added: 0003421 | |
| 2020-06-23 23:50 | pengbo | Status | assigned => feedback |
| 2020-06-25 21:06 | eldad | Note Added: 0003424 | |
| 2020-06-25 21:06 | eldad | Status | feedback => assigned |
| 2020-08-03 12:35 | pengbo | Note Added: 0003449 | |
| 2020-08-03 12:35 | pengbo | Status | assigned => feedback |
| 2020-09-01 09:43 | administrator | Note Added: 0003552 | |
| 2020-09-14 14:40 | pengbo | Status | feedback => closed |
| 2020-09-14 14:40 | pengbo | Note Added: 0003565 |
