[pgpool-general: 5604] Re: About pgpool backend and failover-command
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.
SRA OSS, Inc. Japan
More information about the pgpool-general