[pgpool-general: 3567] Re: Reg Failover Script in pgpool
kirstein at tuhh.de
Mon Mar 23 23:49:23 JST 2015
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.
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!
> pgpool-general mailing list
> pgpool-general at pgpool.net
More information about the pgpool-general