View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000687 | Pgpool-II | Bug | public | 2021-02-12 13:44 | 2021-02-19 09:40 |
| Reporter | harukat | Assigned To | pengbo | ||
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | closed | Resolution | open | ||
| Product Version | 4.2.2 | ||||
| Target Version | 4.2.2 | Fixed in Version | 4.2.2 | ||
| Summary | 0000687: wrong pg_rewind usage in follow_primary.sh.sample | ||||
| Description | follow_primary.sh.sample script do the following steps for the target backend server : (1) pg_ctl -m fast stop (2) write recovery.conf or myrecovery.conf (3) pg_rewind However, pg_rewind try to sync any files from the source to the tagget in the data directory, so recovery.conf or myrecovery.conf will be removed. Probably the current sample script can work only if pg_rewind doesn't need to rewind really. I think we will swap (2) for (3) . Pgpool-II 4.1.x, 4.2.x, and master have this problem. | ||||
| Tags | No tags attached. | ||||
|
|
Thank you for reporting this issue. I'm looking into this one. |
|
|
also in my case, i use postgresql-12.5, which i believe recovery.conf is no longer applicable. instead, if use pg_basebackup, it creates postgresql.auto.conf |
|
|
Fixed by the following commit: https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=7bd103a6a33a2a675bd37f996ab46b7819a731d7 |
|
|
> also in my case, i use postgresql-12.5, which i believe recovery.conf is no longer applicable. > instead, if use pg_basebackup, it creates postgresql.auto.conf Yes. You can customize the follow_primary.sh to use postgresql.auto.conf. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2021-02-12 13:44 | harukat | New Issue | |
| 2021-02-12 15:12 | pengbo | Assigned To | => pengbo |
| 2021-02-12 15:12 | pengbo | Status | new => assigned |
| 2021-02-12 15:12 | pengbo | Description Updated | |
| 2021-02-12 15:15 | pengbo | Note Added: 0003730 | |
| 2021-02-15 01:32 | thesn@hotmail.com | Note Added: 0003733 | |
| 2021-02-15 09:41 | pengbo | Note Added: 0003734 | |
| 2021-02-15 09:44 | pengbo | Note Added: 0003735 | |
| 2021-02-15 09:45 | pengbo | Status | assigned => feedback |
| 2021-02-19 09:39 | administrator | Fixed in Version | => 4.2.2 |
| 2021-02-19 09:39 | administrator | Target Version | => 4.2.2 |
| 2021-02-19 09:40 | administrator | Status | feedback => closed |