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

2011-01-30 Thread Sandeep Thakkar
-3com.com daniel.cre...@l-3com.com To: Armin Nesiren armin.nesi...@intera.si Cc: sandee...@yahoo.com; pgpool-general@pgfoundry.org; Tatsuo Ishii is...@sraoss.co.jp Sent: Sat, January 29, 2011 3:30:18 AM Subject: RE: RE: [Pgpool-general] replication/failover feature in Master/Slavemode Try running

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

2011-01-28 Thread Sandeep Thakkar
...@lelarge.info; pgpool-general@pgfoundry.org Sent: Fri, January 28, 2011 1:08:08 PM Subject: Re: [Pgpool-general] replication/failover feature in Master/Slavemode 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

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

2011-01-28 Thread Tatsuo Ishii
Cc: daniel.cre...@l-3com.com; guilla...@lelarge.info; pgpool-general@pgfoundry.org Sent: Fri, January 28, 2011 1:08:08 PM Subject: Re: [Pgpool-general] replication/failover feature in Master/Slavemode Yes, I'm aware that I need to create a trigger file (same as what is defined

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

2011-01-28 Thread Sandeep Thakkar
: daniel.cre...@l-3com.com; guilla...@lelarge.info; pgpool-general@pgfoundry.org Sent: Fri, January 28, 2011 2:01:50 PM Subject: Re: [Pgpool-general] replication/failover feature in Master/Slavemode No. Failover_command will be automatically executed by pgpool-II if primary goes down. And you can have touch

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

2011-01-28 Thread Armin Nesiren
:* Tatsuo Ishii is...@sraoss.co.jp *To:* sandee...@yahoo.com *Cc:* daniel.cre...@l-3com.com; guilla...@lelarge.info; pgpool-general@pgfoundry.org *Sent:* Fri, January 28, 2011 2:01:50 PM *Subject:* Re: [Pgpool-general] replication/failover feature in Master/Slavemode No. Failover_command

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

2011-01-28 Thread Daniel . Crespo
*To:* sandee...@yahoo.com *Cc:* daniel.cre...@l-3com.com; guilla...@lelarge.info; pgpool-general@pgfoundry.org *Sent:* Fri, January 28, 2011 2:01:50 PM *Subject:* Re: [Pgpool-general] replication/failover feature in Master/Slavemode No. Failover_command will be automatically executed

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

2011-01-28 Thread Daniel . Crespo
:01 PM To: Crespo, Daniel @ SSG - SDS Cc: sandee...@yahoo.com; pgpool-general@pgfoundry.org; Tatsuo Ishii Subject: Re: RE: [Pgpool-general] replication/failover feature in Master/Slavemode In my case there is no missunderstunding... Again... when I try to recover my old primary node (node 0

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

2011-01-27 Thread Daniel . Crespo
-general@pgfoundry.org Subject: Re: [Pgpool-general] replication/failover feature in Master/Slavemode 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

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

2011-01-27 Thread Sandeep Thakkar
, January 27, 2011 9:33:01 PM Subject: RE: [Pgpool-general] replication/failover feature in Master/Slavemode “failover_command” entry in pgpool.conf allows you to do whatever you need to do when pgpool detects a database node degeneration. In your case you would need to touch the file where

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

2011-01-27 Thread Sandeep Thakkar
@pgfoundry.org Sent: Fri, January 28, 2011 11:53:48 AM Subject: Re: [Pgpool-general] replication/failover feature in Master/Slavemode 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

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

2011-01-27 Thread 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