[pgpool-general: 5604] Re: About pgpool backend and failover-command

[Tatsuo Ishii]

> Hi, all
> 
> I’m new to pgpool, I have two questions here, can anyone give some advises? Thanks a lot.

Welcome to Pgpool-II world:-)

>   1.  I have two PostgreSQL server running as master and slave with streaming replication mode, so is it a MUST that the master PostgreSQL server should be defined as backend0 and slave as backend1?

No. The master can be either backend0 or backend1.

>   2.  The failover command will touch a trigger file to the new master, but which account will pgpool to execute the command?

The same account as pgpool process starts.

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