[pgpool-general: 1798] Re: There might be an error in the tutorial for streaming replication on multiple servers
tflori at germanpersonnel.de
Wed May 29 19:03:53 JST 2013
In the referenced pgpool.conf
the configuration variable failback_command is set to delete a file:
failback_command = '/bin/rm -f /var/log/pgpool/trigger/trigger_file1'
This command gets executed on pgpool-server, or not? Therefore the trigger file on the pgpool server gets deleted and not on the backend server.
Am 29.05.2013 03:27, schrieb Tatsuo Ishii:
>> I think there might be an error in the tutorial
>> In pgpool.conf there will be deleted a file on the pgpool server
> What do you mean? Sorry but I just couldn't follow the sentence.
>> (/var/log/pgpool/trigger/trigger_file1) but in the failover.sh script
>> this file will be created on the backend server.
> Sure. trigger file should be created on the backend server and because
> of it failover.sh uses ssh.
>> Anyway I'm not able to run this configuration successfully on ubuntu
>> 12.04 lts servers using the postgresql-9.1 and pgpool2 packages from
>> default repositories. But that should be another thread...
>> Best regards
>> Thomas Flori
>> GermanPersonnel e-search GmbH
More information about the pgpool-general