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

Yong Zhang hiscal at outlook.com
Tue Jul 4 17:34:01 JST 2017

Thank you Tatsuo.

For question1, on pgpool FIRST startup, will it check automatically from all of the backends to find out who is the master pg server? And only when failover it will then use the youngest node id as master?

From: Tatsuo Ishii<mailto:ishii at sraoss.co.jp>
Sent: Tuesday, July 4, 2017 3:56 PM
To: hiscal at outlook.com<mailto:hiscal at outlook.com>
Cc: pgpool-general at pgpool.net<mailto:pgpool-general at pgpool.net>
Subject: Re: [pgpool-general: 5603] About pgpool backend and failover-command

> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20170704/edf9a8a2/attachment.html>

More information about the pgpool-general mailing list