View Issue Details

IDProjectCategoryView StatusLast Update
0000533Pgpool-II[All Projects] Generalpublic2020-02-05 09:42
ReporterGoist11Assigned Tohoshiai 
PrioritynormalSeveritymajorReproducibilityalways
Status feedbackResolutionopen 
Product Version4.0.5 
Target VersionFixed in Version 
Summary0000533: Pgpooll - standby.stop appear instantly despite i configure it to be delayed
DescriptionHi, i have an issue with standby.stop and failover in pgpool.
I would like to set up pgpool to standby.stop would appear after 10 seconds. I tried to configure pgpool by changing few parameters like:
health_check_period from 0 to 5
health_check_max_retries from 0 to 10
health_check_retry_delay and this one
i switch replication_stop_on_mismatch to on and tried it with off and standby stop appear instantly but i want to change it.
I would be really appreciated if someone would help me to configure it well. I'm a little bit new in this and have no idiea how could i resolve it better.


I will attach my pgpool.conf.
Steps To ReproduceSet replication -> lose connection with postgress -> check standby stop(appear immediately)
Additional Informationpgpool-II version 4.0.5 (torokiboshi)
PostgreSQL 9.6
TagsNo tags attached.

Activities

Goist11

2019-08-06 16:45

reporter  

pgpool.conf (42,197 bytes)

hoshiai

2019-08-19 11:09

developer   ~0002793

It means,
Do you want to do that stopping postgres is detect late by pgpool ?

Could you give me pgpool.log, when this problem was happend.

hoshiai

2020-02-05 09:42

developer   ~0003133

Do you have any questions?
If you don't have any problems, I would like to close this issue.

Issue History

Date Modified Username Field Change
2019-08-06 16:45 Goist11 New Issue
2019-08-06 16:45 Goist11 File Added: pgpool.conf
2019-08-07 10:32 hoshiai Assigned To => hoshiai
2019-08-07 10:32 hoshiai Status new => assigned
2019-08-19 11:09 hoshiai Note Added: 0002793
2019-08-19 11:09 hoshiai Status assigned => feedback
2020-02-05 09:42 hoshiai Note Added: 0003133