View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000184 | Pgpool-II | Bug | public | 2016-03-25 15:57 | 2017-10-18 13:08 |
| Reporter | wangzhenbo | Assigned To | |||
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | closed | Resolution | open | ||
| Summary | 0000184: when failover happened, the trigger will disappear | ||||
| Description | pgpool:3.4.4 postgresql:9.1 I set the trigger file at /var/lib/postgresql/trigger_file0. when failover happened,create the trigger file at new primary node,and disappear immediately. Before,I set the trigger file at /tmp/trigger_file0,the trigger file will not disappear. | ||||
| Tags | No tags attached. | ||||
|
|
when failover happened, the trigger FILE will disappear |
|
|
Hi, I had the same issue, this is postgres issue, not pgpool. trigger file should be deleted by postgres after failover is done and recovery.conf is renamed to recover.done. If the file is not deleted after failover you have a permission problem on the file, try to create it with postgres and not root. see here - http://www.postgresql-archive.org/postgres-not-deleting-trigger-file-td5860795.html Regards, Eldad |
|
|
Eldad, Thank you for the excellent follow up! I am going to close this issue. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2016-03-25 15:57 | wangzhenbo | New Issue | |
| 2016-03-26 18:54 | wangzhenbo | Note Added: 0000726 | |
| 2017-10-17 00:11 | eldad | Note Added: 0001758 | |
| 2017-10-18 11:03 | t-ishii | Note Added: 0001764 | |
| 2017-10-18 13:08 | t-ishii | Status | new => closed |
