[pgpool-general: 8654] Re: online recovery causes node to loose replication state.

[Todd Stein]

Hi Tatsuo,
Thank you for the recovery_timeout tip.  I will make the change.
I just sent the files from my original question, different scenario...
Please have a look at them.



Regards,

Todd Stein

-----Original Message-----
From: Tatsuo Ishii <ishii at sraoss.co.jp> 
Sent: Friday, March 17, 2023 9:16 AM
To: Todd Stein <todd.stein at microfocus.com>
Cc: pgpool-general at pgpool.net
Subject: Re: [pgpool-general: 8646] Re: online recovery causes node to loose replication state.

> Hi Tatsuo,
> Please find the attached zip file containing the config files and logs you asked for.
> 
> Thank you in advance !

Thanks. Unfortunately there's no PostgreSQL logs. But I guess the reason for this:

>> My process to get the cluster back to normal.  Don't understand why the recovery process is failing...  Eventually, it works...
>> pcp_recovery_node -h 10.78.121.3 -p 9898 -U postgres -n 2
>> 
>> ERROR:  recovery is checking if postmaster is started
>> DETAIL:  postmaster on hostname:"catvmtspg04c.domain.net" 
>> database:"template1" user:"postgres" failed to start in 0 second
>> 
>> [postgres at catvmtspg04a pgpool-II]$ pcp_recovery_node -h 10.78.121.3 
>> -p
>> 9898 -U postgres -n 2
>> Password:
>> ERROR:  recovery is checking if postmaster is started
>> DETAIL:  postmaster on hostname:"catvmtspg04c.domain.net" 
>> database:"template1" user:"postgres" failed to start in 0 second

Because you set: recovery_timeout = 0. This will not give postmaster a chance to spend sometime for internal processing before it starts up. I'd suggest to get back to the default value (90).

Best reagards,
--
Tatsuo Ishii
SRA OSS LLC
English: https://nam12.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.sraoss.co.jp%2Findex_en%2F&data=05%7C01%7Ctodd.stein%40microfocus.com%7C5295d0df6d50461ed37c08db26e9d097%7C856b813c16e549a585ec6f081e13b527%7C0%7C0%7C638146557889839979%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=xJRycM%2BWu6bwt2Iui1SXdHf9UedhxvyN2wshobhXZds%3D&reserved=0
Japanese:https://nam12.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.sraoss.co.jp%2F&data=05%7C01%7Ctodd.stein%40microfocus.com%7C5295d0df6d50461ed37c08db26e9d097%7C856b813c16e549a585ec6f081e13b527%7C0%7C0%7C638146557889839979%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=K%2BL%2FOZOIgXTZWPRX2nywOKVmHsWVsv7NGN8zF3CQxz8%3D&reserved=0