View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000620 | Pgpool-II | General | public | 2020-06-17 21:44 | 2020-08-26 16:19 |
| Reporter | Ken | Assigned To | pengbo | ||
| Priority | normal | Severity | block | Reproducibility | always |
| Status | closed | Resolution | open | ||
| Product Version | 4.1.2 | ||||
| Summary | 0000620: Problem with promote server | ||||
| Description | Hello 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 | ||||
| Tags | No tags attached. | ||||
|
|
|
|
|
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 |
|
|
Have you resolved this issue? If you have resolved this issue, I'm going to close this issue. |
|
|
I confirm, i have resolved issue with promote server. Thanks you for answer Best redards |
|
|
I am going to close this issue. |
| 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 | |
| 2020-08-03 12:43 | pengbo | Note Added: 0003450 | |
| 2020-08-03 12:43 | pengbo | Status | assigned => feedback |
| 2020-08-26 10:43 | pengbo | Note Added: 0003515 | |
| 2020-08-26 16:16 | Ken | Note Added: 0003519 | |
| 2020-08-26 16:16 | Ken | Status | feedback => assigned |
| 2020-08-26 16:19 | pengbo | Note Added: 0003520 | |
| 2020-08-26 16:19 | pengbo | Status | assigned => closed |
