[pgpool-general: 3567] Re: Reg Failover Script in pgpool

[Michel Kirstein]

Hi Gurunadh,
did you catch the "Host key verification failed."-error in line 1196 
from the first log file you sent? If it still does not run after 
inserting the space you might want to have a look at this.

Michel

Am 19.03.2015 um 22:26 schrieb Mark Kirkwood:
> On 19/03/15 23:22, Gurunadh Venkata wrote:
>> Hi all,
>>
>> I have setup the pgpool for streaming replication failover in PostgreSQL.
>>
>> I have two PostgreSQL servers 10.0.0.80(master) & 10.0.0.81(slave) and
>> pgpool running on 10.0.0.81 with port 9999.
>>
>> Now i want to write a failover script where if my master pg server fails
>> then slave server should take the role of Master server.
>>
>> Please help me in creating a failover script. I have already tried with
>> different failover scripts but none of them are working fine .
>>
>> Please find the attached pgpoog.conf, pgpool logs failover script files and
>> please let me Know if any changes required.
>>
>> Thanks for your time..
>>
>
> Your script failover.sh has a syntax error at line 22:
>
>
> if [$failed_node_id = $old_primary_node_id ];then       # master failed
>
> should be:
>
> if [ $failed_node_id = $old_primary_node_id ];then       # master failed
>
> note the space! Shell is touchy about that sort of thing!
>
> Cheers
>
> Mark
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general
>