Thread: 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 forconnections 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 > -----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 >
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