[pgpool-general: 5623] Re: pgpool 3.6.4 failover - failover scenario question

[Tatsuo Ishii]

Pgpool-II 3.6.5 fixes some of the failover problems. These works are
done by Usama. I believe he is the authority in the are. Usama?

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

> Hi,
> 
> We also have problems with failovers when postgres and pgpool are on the same machine.  If there are configuration parameters that can be changed to improve the failover mechanism I will also be happy to hear.
> 
> Thanks
> Avi
> 
> From: pgpool-general-bounces at pgpool.net [mailto:pgpool-general-bounces at pgpool.net] On Behalf Of Shay Cohavi
> Sent: Friday, July 14, 2017 7:57 PM
> To: pgpool-general at pgpool.net
> Subject: [pgpool-general: 5621] pgpool 3.6.4 failover - failover scenario question
> 
> Hi,
> I have 2 postgres servers (postgres 9.3.5) installed with pgpool(3.6.4) on the same node.
> 
> 
> server1 192.168.15.55
> server 2 192.168.15.56
> pgpool vip 192.168.15.59
> 
> 
> 
> [cid:ii_j5440tpw2_15d420772c4ababb]​
> 
> 
> # psql -U postgres -h 192.168.15.59 -p 9999 -c 'show pool_nodes'
>  node_id |   hostname    | port | status | lb_weight |  role   | select_cnt | load_balance_node | replication_delay
> ---------+---------------+------+--------+-----------+---------+------------+-------------------+-------------------
>  0       | 192.168.15.55 | 5432 | up     | 0.500000  | primary | 3718       | true              | 0
>  1       | 192.168.15.56 | 5432 | up     | 0.500000  | standby | 0          | false             | 0
> 
> 
> 
> my question is about disaster recovery scenario:
> 
> 1. "primary postgres" and the "master pgpool" is on server1 . pgpool vip established on this node (192.168.15.59)
> 
> 2. server1 went down due to  power break. (server1 is dead!!!)
> 
> 3. pgpool on server server2 get promoted (vip established 192.168.15.59) .
> 
> 4. NO postgres failover action occurs by the pgpool. pgpool keeps searching for primary postgres with no success.
> 
> should the new master pgpool execute an failover action(promote) to the slave postgres ??
> 
> 
> 
> Thanks,
> cohavisi
> IMPORTANT - This email and any attachments is intended for the above named addressee(s), and may contain information which is confidential or privileged. If you are not the intended recipient, please inform the sender immediately and delete this email: you should not copy or use this e-mail for any purpose nor disclose its contents to any person.