[pgpool-general: 1798] Re: There might be an error in the tutorial for streaming replication on multiple servers

[Thomas Flori]

In the referenced pgpool.conf 
(http://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting2_3.1/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:
>> Hi,
>>
>> I think there might be an error in the tutorial
>> http://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting2_3.1/
>>
>> 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
>> Developer
>>
>> GermanPersonnel e-search GmbH
>>