Thread: Can I make Postgresql to bind to 127.0.0.1:5432, instead of all the available interfaces

Can I make Postgresql to bind to 127.0.0.1:5432, instead of all the available interfaces

From

Uday Singh

Date:

14 February 2003, 01:00:40

Hi guys,

I am trying to figure out if I can get Postgres to bind to only the loop-back interface (127.0.0.1) as apposed to binding to all the available interfaces (0.0.0.0) available on the system.

1. The first question is whether this is feasible at all?

2. If yes, what is the configuration (and where) to enable it.

Thanks a lot in advance.

- Uday

Re: Can I make Postgresql to bind to 127.0.0.1:5432, instead of all the available interfaces

From

Tom Lane

Date:

14 February 2003, 01:12:17

Uday Singh <uday@ironhide.com> writes:
> I am trying to figure out if I can get Postgres to bind to only the
> loop-back interface (127.0.0.1) as apposed to binding to all the available
> interfaces (0.0.0.0) available on the system.

I think you can do that with the virtual_host config parameter.

            regards, tom lane