PostgreSQL listens on localhost?

El día martes, agosto 01, 2023 a las 09:12:51a. m. -0700, Frank Gunseor escribió:

I have read that PostgreSQL listens on localhost is it possible to have it
listen on an IP address?

Thank you.

FDG

How about reading the man page of postgresql.conf and pg_hba.conf

Thanks

matthias
--
Matthias Apitz, ✉ guru@unixarea.de, http://www.unixarea.de/ +49-176-38902045
Public GnuPG key: http://www.unixarea.de/key.pub

On 8/1/23 11:12, Frank Gunseor wrote:

I have read that PostgreSQL listens on localhost is it possible to have it
listen on an IP address?

Of course.  "localhost" is just the default.

--
Born in Arizona, moved to Babylonia.

On 8/1/23 09:12, Frank Gunseor wrote:

I have read that PostgreSQL listens on localhost is it possible to have
it listen on an IP address?

Read:

https://www.postgresql.org/docs/current/runtime-config-connection.html#RUNTIME-CONFIG-CONNECTION-SETTINGS

Thank you.

FDG

--
Adrian Klaver
adrian.klaver@aklaver.com

Hi Adrian,

I have just started with PostgreSQL after years away from Micro$oft SQL
Server.
Thank you very much for the quick reference as I have also been trying to
get through the documentation (all 3063 pages of it!).

FDG

On Tue, Aug 1, 2023 at 11:42 AM Adrian Klaver <adrian.klaver@aklaver.com>
wrote: