[wplug] postgresql and tcpip

[Robert Coutch]

Another option could be to use ipchains or iptables to block the ports on all 
interfaces except for the loopback device.

-Bob

On Wednesday 27 August 2003 09:24 am, Tim Lesher wrote:
> On Wed, Aug 27, 2003 at 10:11:52AM -0400, John Harrold wrote:
> > i have a server which is running
> > postgresql with the tcpip option turned on. now the database is only
> > being accessed through the localhost interface. is there any way to tell
> > postgresql to listen only to the lo interface and to ignore requests on
> > the external (eth0 in this case) interface.
>
> Tell postgres to bind only to loopback (127.0.0.1), using the
> VIRTUAL_HOST() directive.