Is there any way to force PostgreSQL to bind to a specific IP address?

There doesn't seem to be anything about this in the docs, and if its not
implemented, it would be a useful feature to have (and an easy one to
implement).

--
Alastair D'Silva B. Sc.            mob: 0413 485 733
Networking Consultant
New Millennium Networking  http://www.newmillennium.net.au


Wed, 27 Mar 2002 15:39:13 +1100
"Alastair D'Silva" <deece@newmillennium.net.au>
Binding PostgreSQL to a specific ip address
On Wed, 27 Mar 2002, Alastair D'Silva wrote:

> Is there any way to force PostgreSQL to bind to a specific IP address?
> 
> There doesn't seem to be anything about this in the docs, and if its not
> implemented, it would be a useful feature to have (and an easy one to
> implement).
(from runtime-config.html)

   VIRTUAL_HOST (string)
          Specifies the TCP/IP hostname or address on which the
          postmaster is to listen for connections from client
          applications. Defaults to listening on all configured addresses
          (including localhost).

Gavin


Wed, 27 Mar 2002 15:45:40 +1100 (EST)
Gavin Sherry <swm@linuxworld.com.au>
Re: Binding PostgreSQL to a specific ip address
Cheers, next time I'll look a bit harder :)

--
Alastair D'Silva B. Sc.            mob: 0413 485 733
Networking Consultant
New Millennium Networking  http://www.newmillennium.net.au 

> -----Original Message-----
> From: Gavin Sherry [mailto:swm@linuxworld.com.au] 
> Sent: Wednesday, 27 March 2002 3:46 PM
> To: Alastair D'Silva
> Cc: pgsql-hackers@postgresql.org
> Subject: Re: [HACKERS] Binding PostgreSQL to a specific ip address
> 
> 
> On Wed, 27 Mar 2002, Alastair D'Silva wrote:
> 
> > Is there any way to force PostgreSQL to bind to a specific 
> IP address?
> > 
> > There doesn't seem to be anything about this in the docs, 
> and if its 
> > not implemented, it would be a useful feature to have (and 
> an easy one 
> > to implement).
> (from runtime-config.html)
> 
>    VIRTUAL_HOST (string)
>           Specifies the TCP/IP hostname or address on which the
>           postmaster is to listen for connections from client
>           applications. Defaults to listening on all 
> configured addresses
>           (including localhost).
> 
> Gavin
> 


Wed, 27 Mar 2002 15:49:51 +1100
"Alastair D'Silva" <deece@newmillennium.net.au>
Re: Binding PostgreSQL to a specific ip address
Note if you are trying to run more than one postgresql you also have to 
prevent the unix socket files from clashing.

 > On Wed, 27 Mar 2002, Alastair D'Silva wrote:
> >
> > > Is there any way to force PostgreSQL to bind to a specific
> > IP address?
> > >
> > > There doesn't seem to be anything about this in the docs,
> > and if its
> > > not implemented, it would be a useful feature to have (and
> > an easy one
> > > to implement).
> > (from runtime-config.html)
> >
> >    VIRTUAL_HOST (string)
> >           Specifies the TCP/IP hostname or address on which the
> >           postmaster is to listen for connections from client
> >           applications. Defaults to listening on all
> > configured addresses
> >           (including localhost).
> >
> > Gavin
> >
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org



Wed, 27 Mar 2002 16:05:33 +0800
Lincoln Yeoh <lyeoh@pop.jaring.my>
Re: Binding PostgreSQL to a specific ip address