Postgres Pro
Downloads
Home   >   mailing lists

Thread: Is there any configuration in postgresql.conf or any otherconfiguration of postgres which will make this possible to listen onparticular interface

Is there any configuration in postgresql.conf or any otherconfiguration of postgres which will make this possible to listen onparticular interface

From
M Tarkeshwar Rao
Date:

Hi all,

 

postmaste  2917 postgres    3u  IPv4    52341      0t0  TCP *:5432 (LISTEN)

postmaste  2917 postgres    4u  IPv6    52342      0t0  TCP *:5432 (LISTEN)

 

Above processes are bind on all the interfaces of a machine. Is there any configuration in postgresql.conf or any other configuration of postgres which will make this possible to listen on particular interface?

 

Regards

Tarkeshwar

 

Re: Is there any configuration in postgresql.conf or any otherconfiguration of postgres which will make this possible to listen onparticular interface

From
Francisco Olarte
Date:
On Wed, Oct 16, 2019 at 12:07 PM M Tarkeshwar Rao
<m.tarkeshwar.rao@ericsson.com> wrote:
> Above processes are bind on all the interfaces of a machine. Is there any configuration in postgresql.conf or any
otherconfiguration of postgres which will make this possible to listen on particular interface?
 

Listening on an INTERFACE is a tricky thing. But if you can manage
with listening on a particular ADDRESS and letting the os pick the
interfaces for you, you can try listen_address ( which is trivially
found on https://www.postgresql.org/docs/12/runtime-config-connection.html#RUNTIME-CONFIG-CONNECTION-SETTINGS
, although being lazy I just searched for "listen" on the manual index
)

Francisco Olarte.