[wplug] postgresql and tcpip

Tim Lesher tim at lesher.ws
Wed Aug 27 09:24:36 EDT 2003


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.

-- 
Tim Lesher <tim at lesher.ws>
http://www.lesher.ws




More information about the wplug mailing list