[pgpool-general: 2705] Re: pcp override locahost as default host?

[Tatsuo Ishii]

Hi Jeff,

Oh, I see. As I said currently there's no way to override the
setting. Can you please propose a fix for it?

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

> Hi Tatsuo,
> 
> the reason is they run a multi-tenet form of PaaS on a single physical
> host, you could for example have several different application 'instances'
> running and each needs to be prevented from stepping on the other deployed
> applications, what Openshift does is assign a unique IP address to each
> application instance that they can bind to instead.  They use selinux to
> lock down each application into it's own jail.  Kind of an interesting idea
> but it seems to always trip up applications that reference 'localhost'.
> 
> I had to patch postgres (pgstat.c) to overcome this exact issue.  I think I
> see the line of code in main.c where I could make a similar patch for
> pgpool but wasn't sure if there was another way to override the setting.
> 
> regards
> 
> Jeff McCormick
> 
> 
> On Thu, Apr 3, 2014 at 7:09 PM, Tatsuo Ishii <ishii at postgresql.org> wrote:
> 
>> > Is there a way to override the host that pcp binds to?  it appears to
>> bind
>> > to localhost
>> > by default.
>>
>> Sorry, but no.
>>
>> > I am running pgpool on Openshift where binding to 127.0.0.1 is not
>> allowed.
>>
>> Just out of curiosity, do you know why Openshift does not allow it?
>>
>> If the reason is sane, I would like to address the problem in the future.
>>
>> Best regards,
>> --
>> Tatsuo Ishii
>> SRA OSS, Inc. Japan
>> English: http://www.sraoss.co.jp/index_en.php
>> Japanese: http://www.sraoss.co.jp
>>
> 
> 
> 
> -- 
> *Jeff McCormick*
> 843-327-5754
> jeffmc04 at gmail.com