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

[Sandeep Thakkar]

Here, both the dbservers and pgpool run on the single box. This may not be the 
practical scenario, but I was just testing the features.
Hence, I directly used touch. Is it fine then?

 



________________________________
From: Guillaume Lelarge <guillaume at lelarge.info>
To: Sandeep Thakkar <sandeeptt at yahoo.com>
Cc: pgpool-general at pgfoundry.org
Sent: Thu, January 27, 2011 5:23:22 PM
Subject: Re: [Pgpool-general] replication/failover feature in Master/Slave mode

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



      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20110127/725ded26/attachment.html>