View Issue Details

IDProjectCategoryView StatusLast Update
0000623Pgpool-IIBugpublic2020-08-03 12:35
ReportereldadAssigned Topengbo 
PrioritylowSeverityminorReproducibilityalways
Status feedbackResolutionopen 
PlatformawsOSLinuxOS VersionCentOS 7.8
Product Version4.1.2 
Target VersionFixed in Version 
Summary0000623: Show pool_nodes not showing full data
DescriptionI'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 Informationmaster_slave_mode = on
master_slave_sub_mode = 'stream'
TagsNo tags attached.

Activities

pengbo

2020-06-23 23:49

developer   ~0003421

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

eldad

2020-06-25 21:06

reporter   ~0003424

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

pengbo

2020-08-03 12:35

developer   ~0003449

You need to restart pgpool.

Issue History

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