[Pgpool-general] replication/failover feature in Master/Slavemode

[Tatsuo Ishii]

> Yes, I'm aware that I need to create a trigger file (same as what is defined in 
> recovery.conf) to start the failover and promote the Standby to Primary. I have 
> tried this when I did not use pgpool and it worked fine. I thought, when pgpool 
> is in picture, it will execute the failver_command, when it detects that primary 
> is down. and since, the failover_command in my case is to "touch trigger file". 
> Shouldn't pgpool execute the failover_command here and create that file 
> automatically?

Besides the problem that it's not easy to read and parse
recovery.conf, creating trigger file might not be the only way to
promote standby server forever. Actually currently PostgreSQL
developers are discussing about "pg_ctl failover" command which will
be a new way to promote standby in the next version of
PostgreSQL. Pgpool-II is designed to be flexible to work with as many
PostgreSQL version as possible. So we don't want to hard code "touch
trigger file" in pgpool itself.

> I think, either pgpool is not able to detect that primary is down 
> or it is unable to execute the failover_command. Am I missing to define anything 
> in the configuration file?