View Issue Details

IDProjectCategoryView StatusLast Update
0000620Pgpool-II[All Projects] Generalpublic2020-08-03 12:43
ReporterKenAssigned Topengbo 
PrioritynormalSeverityblockReproducibilityalways
Status feedbackResolutionopen 
Product Version4.1.2 
Target VersionFixed in Version 
Summary0000620: Problem with promote server
DescriptionHello

I have configuration pgpool and loadbalancing and watchdog working. I have replication type streaming too and replication working.
Server Postmetahive1 - is primary and status up
Server Postmetahive2 - is standby and status up
When I want perform command pcp_promote_node that watchdog switch itself but database don't. And after this command I recived
Server Postmetahive1 - standby and status down
Server Postmetahive2 - primary and status up
When I connected to S2 that I couldn't create database or enter change on data because I recived infromation: database is only read status

Additional if I perform pcp_attache_node Postmetahive1 I recived:
Server Postmetahive1 - primary and status up
Server Postmetahive2 - standby and status up

and i noticed that in query show pool_nodes i see empty columns replication_state and replication_sync_state

Below in attachment configuration

TagsNo tags attached.

Activities

Ken

2020-06-17 21:44

reporter  

postgresql_postmetahive1.conf (26,701 bytes)
postgresql.conf (26,646 bytes)
pool_passwd (67 bytes)
postgres:postgres1234
pgpool:md5e4578dba45b976ecfe15519b1ad8418e


pool_passwd (67 bytes)
pgpool.conf (43,678 bytes)
pg_hba.conf (4,407 bytes)
pcp.conf (940 bytes)

pengbo

2020-08-03 12:43

developer   ~0003450

https://www.pgpool.net/docs/latest/en/html/pcp-promote-node.html

Please note that this command does not actually promote standby PostgreSQL backend:
it just changes the internal status of Pgpool-II and trigger failover and users have to promote standby PostgreSQL outside Pgpool-II.

> and i noticed that in query show pool_nodes i see empty columns replication_state and replication_sync_state

You need to configure "backend_application_name" parameter which is specified in "primary_conninfo".

https://www.pgpool.net/docs/latest/en/html/runtime-config-backend-settings.html#GUC-BACKEND-APPLICATION-NAME

Issue History

Date Modified Username Field Change
2020-06-17 21:44 Ken New Issue
2020-06-17 21:44 Ken File Added: pcp.conf
2020-06-17 21:44 Ken File Added: pg_hba.conf
2020-06-17 21:44 Ken File Added: pgpool.conf
2020-06-17 21:44 Ken File Added: pool_passwd
2020-06-17 21:44 Ken File Added: postgresql.conf
2020-06-17 21:44 Ken File Added: postgresql_postmetahive1.conf
2020-06-18 17:45 pengbo Assigned To => pengbo
2020-06-18 17:45 pengbo Status new => assigned
2020-06-18 17:45 pengbo Description Updated View Revisions
2020-08-03 12:43 pengbo Note Added: 0003450
2020-08-03 12:43 pengbo Status assigned => feedback