Postgres Pro
Downloads
Home   >   mailing lists

Thread: binding postmaster to *one* virtual IP address

binding postmaster to *one* virtual IP address

From
Thierry Besancon
Date:
        Hello

I'd like to run postmaster on a workstation with several IP
addresses. What I'd like is to have it bind to one and only one of
those IP addresses.

I didn't see any specific option to do that.
Is it possible ?

Thanks in advance for any information.

        THierry

Re: binding postmaster to *one* virtual IP address

From
Anand Raman
Date:
I think there is no such option.. However u can control who can connect
to ur database and which ip address thru options in pg_hba.conf file..

Sorry couldnt be of much help

Anand



On Tue, Feb 20, 2001 at 01:38:04PM +0100, Thierry Besancon wrote:
>
>        Hello
>
>I'd like to run postmaster on a workstation with several IP
>addresses. What I'd like is to have it bind to one and only one of
>those IP addresses.
>
>I didn't see any specific option to do that.
>Is it possible ?
>
>Thanks in advance for any information.
>
>        THierry

Re: binding postmaster to *one* virtual IP address

From
Thierry Besancon
Date:
Dixit gianpaolo racca <gianpaolo@preciso.net> (le Tue, 20 Feb 2001 15:54:56 +0100) :

» > I'd like to run postmaster on a workstation with several IP
» > addresses. What I'd like is to have it bind to one and only one of
» > those IP addresses.
»
» maybe you can block incoming connections to pgport on the other ip adresses
» with ipchains.
»
» hope it helps

Nope but thanks.

I think that should be builtin in the application and should not rely
on other parts of the system.

I'm trying to figure out how to add a new option to do that.
If not already scheduled in 7.1, is it of any interest for 7.1 ?

        Thierry

Re: binding postmaster to *one* virtual IP address

From
Tom Lane
Date:
Thierry Besancon <Thierry.Besancon@prism.uvsq.fr> writes:
> I'd like to run postmaster on a workstation with several IP
> addresses. What I'd like is to have it bind to one and only one of
> those IP addresses.

There is support for this in 7.1, but not in previous releases.

            regards, tom lane

Re: Re: binding postmaster to *one* virtual IP address

From
"Brett W. McCoy"
Date:
On 20 Feb 2001, Thierry Besancon wrote:

> Nope but thanks.
>
> I think that should be builtin in the application and should not rely
> on other parts of the system.
>
> I'm trying to figure out how to add a new option to do that.
> If not already scheduled in 7.1, is it of any interest for 7.1 ?

You can control access to postgres on an IP basis using the pg_hba.conf.
That is probably the best way to do it.

-- Brett
                                     http://www.chapelperilous.net/~bmccoy/
---------------------------------------------------------------------------
Comparing information and knowledge is like asking whether the fatness
of a pig is more or less green than the designated hitter rule."
        -- David Guaspari

Re: binding postmaster to *one* virtual IP address

From
gianpaolo racca
Date:
On Tuesday 20 February 2001 13:38, Thierry Besancon wrote:
>         Hello
>
> I'd like to run postmaster on a workstation with several IP
> addresses. What I'd like is to have it bind to one and only one of
> those IP addresses.
>

maybe you can block incoming connections to pgport on the other ip adresses
with ipchains.

hope it helps

--
gianpaolo racca
gianpaolo@preciso.net
http://www.preciso.net