[pgpool-general: 2345] Re: trigger file permissions

Tatsuo Ishii ishii at postgresql.org
Wed Dec 18 11:05:04 JST 2013


> I have a simple question. If the streaming replication is used, the trigger
> file is created on the secondary server in case the primary server is down.
> According to the pgpool manual it is done within execution of the script
> failover_stream.sh. The failover_stream.sh is defined as failover_command.
> 
> Is the script failover_stream.sh executed with postgres superuser
> permissions? I need to be sure, the trigger_file is created with postgres
> user permissions.

No, the script is executed with pgpool uid.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp


More information about the pgpool-general mailing list