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

Tatsuo Ishii ishii at sraoss.co.jp
Tue Jul 4 16:56:12 JST 2017

> 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

More information about the pgpool-general mailing list