binding postmaster to *one* virtual IP address

Started by Thierry Besanconabout 25 years ago6 messagesgeneral
Jump to latest
#1Thierry Besancon
Thierry.Besancon@prism.uvsq.fr

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

#2Anand Raman
araman@india-today.com
In reply to: Thierry Besancon (#1)
Re: binding postmaster to *one* virtual IP address

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

Show quoted text

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

#3gianpaolo racca
gianpaolo@preciso.net
In reply to: Thierry Besancon (#1)
Re: binding postmaster to *one* virtual IP address

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

#4Thierry Besancon
Thierry.Besancon@prism.uvsq.fr
In reply to: Thierry Besancon (#1)
Re: binding postmaster to *one* virtual IP address

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

#5Tom Lane
tgl@sss.pgh.pa.us
In reply to: Thierry Besancon (#1)
Re: binding postmaster to *one* virtual IP address

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

#6Brett W. McCoy
bmccoy@chapelperilous.net
In reply to: Thierry Besancon (#4)
Re: Re: binding postmaster to *one* virtual IP address

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