Binding PostgreSQL to a specific ip address
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
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
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
Show quoted text
-----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 addressOn 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
Note if you are trying to run more than one postgresql you also have to
prevent the unix socket files from clashing.
Show quoted text
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