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 <[email protected]> To: Sandeep Thakkar <[email protected]> Cc: [email protected] 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
_______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
