View Issue Details

IDProjectCategoryView StatusLast Update
0000687Pgpool-IIBugpublic2021-02-19 09:40
Reporterharukat Assigned Topengbo  
PrioritynormalSeverityminorReproducibilityalways
Status closedResolutionopen 
Product Version4.2.2 
Target Version4.2.2Fixed in Version4.2.2 
Summary0000687: wrong pg_rewind usage in follow_primary.sh.sample
Descriptionfollow_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.
TagsNo tags attached.

Activities

pengbo

2021-02-12 15:15

developer   ~0003730

Thank you for reporting this issue.
I'm looking into this one.

thesn@hotmail.com

2021-02-15 01:32

reporter   ~0003733

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

pengbo

2021-02-15 09:41

developer   ~0003734

Fixed by the following commit:
https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=7bd103a6a33a2a675bd37f996ab46b7819a731d7

pengbo

2021-02-15 09:44

developer   ~0003735

> 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.

Issue History

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