[pgpool-general: 1799] Re: There might be an error in the tutorial for streaming replication on multiple servers
ishii at postgresql.org
Wed May 29 23:28:38 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
Thanks for pointing it out. The failback_command has mistakes in
- Trigger file exists on PostgreSQL server. So trying to remove it on
the pgpool server is plain nonsense.
- PostgreSQL removes trigger file after failover event. So deleting it
on the failback_command is a waste of CPU cycle.
In summary, failback_command should be empty in the tutorial. Will
SRA OSS, Inc. Japan
> 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