PGPool hot standby VIP

Category: azure database for postgresql

Question

topgun966 on Thu, 27 Sep 2018 19:38:01


I am trying to <g class="gr_ gr_17 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del" data-gr-id="17" id="17">setup</g> a couple PG servers with <g class="gr_ gr_33 gr-alert gr_spell gr_inline_cards gr_disable_anim_appear ContextualSpelling" data-gr-id="33" id="33">pgpool</g>. They are <g class="gr_ gr_61 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del" data-gr-id="61" id="61">setup</g> as a hot standby. I put in a VIP that is within my private subnet, <g class="gr_ gr_239 gr-alert gr_gramm gr_inline_cards gr_run_anim Punctuation only-ins replaceWithoutSep" data-gr-id="239" id="239">however</g> when <g class="gr_ gr_164 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling" data-gr-id="164" id="164">pgpool</g> activates the primary, other servers in the private subnet cannot access the <g class="gr_ gr_233 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" data-gr-id="233" id="233">vip</g>. <g class="gr_ gr_335 gr-alert gr_gramm gr_inline_cards gr_run_anim Grammar only-ins replaceWithoutSep" data-gr-id="335" id="335">Only</g> way to get it to work is to assign the VIP <g class="gr_ gr_311 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" data-gr-id="311" id="311">ip</g> to the server active. This won't work in <g class="gr_ gr_436 gr-alert gr_gramm gr_inline_cards gr_run_anim Grammar only-ins doubleReplace replaceWithoutSep" data-gr-id="436" id="436">failover</g> scenario. What am I doing wrong?

Replies

Mike Ubezzi (Azure) on Thu, 27 Sep 2018 19:51:31


This forum post is unrecognizable. Can it be edited to remove all HTML tagging.

<Removed HTML Tags>

I am trying to setup a couple PG servers with pgpool. They are setup as a hot standby. I put in a VIP that is within my private subnet, however when pgpool activates the primary, other servers in the private subnet cannot access the vip. Only way to get it to work is to assign the VIP ip to the server active. This won't work in failover scenario. What am I doing wrong?

Mike Ubezzi (Azure) on Fri, 28 Sep 2018 17:50:21


Hi Topgun,

Do you have the specific error message from the log files?

Pgpool failing to connect to standby postgres server

The pgpool.conf donfiguration is quite complex but, if you are able to hang with and resolve the error messages by making corrections to the pgpool.conf file, you should get to a working state.

Please let us know what additional questions you have.

Thank you,

Mike

topgun966 on Tue, 02 Oct 2018 16:18:41


Hi Mike, just that the VIP after it is assigned after the failover is not accessible on the standby server by any other server.