[Pgpool-general] replication/failover feature in Master/Slave mode

[Guillaume Lelarge]

Le 27/01/2011 09:49, Sandeep Thakkar a écrit :
> I was just testing the pgpool with one primary and one standby on the same box. 
> Hot Standby, Streaming replication, load balancing, all are working fine. But, I 
> see that failover is not happening when I shut down my primary server. When I 
> manually touch the trigger file, failover happens. I thought, pgpool will 
> execute the fail over command on it's own. Am I doing anything wrong?
> 
> Here is my related settings in pgpool.conf:
> failover_command = 'touch <path_to_trigger_file>
> 

If you only do a touch, it means pgpool is launched on the slave? if you
want the touch happen in another node, you need to execute it via an ssh
command.


-- 
Guillaume
 http://www.postgresql.fr
 http://dalibo.com