Thread: PostgreSQL listens on localhost?

PostgreSQL listens on localhost?

From
Frank Gunseor
Date:
I have read that PostgreSQL listens on localhost is it possible to have it listen on an IP address?

Thank you.

FDG

Re: PostgreSQL listens on localhost?

From
Matthias Apitz
Date:
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



Re: PostgreSQL listens on localhost?

From
Ron
Date:
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.



Re: PostgreSQL listens on localhost?

From
Adrian Klaver
Date:
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




Re: PostgreSQL listens on localhost?

From
Frank Gunseor
Date:
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:
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