Re: Distinguishing between connections in pg_hba.conf

From: Adam Witney <awitney(at)sgul(dot)ac(dot)uk>
To: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>, Stephane Bortzmeyer <bortzmeyer(at)nic(dot)fr>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Distinguishing between connections in pg_hba.conf
Date: 2005-05-18 16:19:31
Message-ID: BEB129A3.464A6%awitney@sgul.ac.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 17/5/05 2:59 pm, "Scott Marlowe" <smarlowe(at)g2switchworks(dot)com> wrote:

> On Tue, 2005-05-17 at 05:08, Stephane Bortzmeyer wrote:
>> On Mon, May 16, 2005 at 03:31:27PM -0500,
>> Scott Marlowe <smarlowe(at)g2switchworks(dot)com> wrote
>> a message of 48 lines which said:
>>
>>>> but how do you assign it so that requests from apache appear on
>>>> the db box as one IP address, and requests coming through stunnel
>>>> appear as the second IP address?
>>>
>>> That's kinda OS dependent. On RedHat you should have some kind of
>>> netconfig command
>>
>> I do not think it was the question.
>>
>> For stunnel, the solution is probably :
>>
>> -I host
>> IP of the outgoing interface is used as source for remote
>> connections.
>> Use this option to bind a static local IP address, instead.
>
> Sorry, I'm not that familiar with stunnel, so I didn't really get it
> that that's what the OP was asking...

Hi,

Yep I missed the -I switch in the stunnel docs. And using Scott's idea of an
network interface alias, apache connects with one IP and stunnel connects
with another!

Thanks again for your help

Adam

--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adem HUR 2005-05-18 17:46:21 OLAP with PostgreSQL
Previous Message Scott Marlowe 2005-05-18 16:05:32 Re: OLAP with PostgreSQL