Re: BUG #17454: Using psql without ipv4 address,the inet_server_port do not return PORT.

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: BUG #17454: Using psql without ipv4 address,the inet_server_port do not return PORT.
Дата
Msg-id CAKFQuwZm==rNg0z9XYG5OSCB0oiMJn=6d9x+rdTpbsz7G0TVvQ@mail.gmail.com
обсуждение исходный текст
Ответ на BUG #17454: Using psql without ipv4 address,the inet_server_port do not return PORT.  (PG Bug reporting form <noreply@postgresql.org>)
Список pgsql-bugs
Дерево обсуждения
On Sat, Apr 2, 2022 at 6:37 PM Wong Simon <thbytwo@live.cn> wrote:
If I run multiple instances on one server with local socket, how can I distinguish them?I think the port is need.


You do have the right idea, but you need to inspect the static configuration setting the server is using as opposed to the connection state reported by the function.

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

port

The TCP port the server listens on; 5432 by default. Note that the same port number is used for all IP addresses the server listens on. This parameter can only be set at server start.

David J.

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Wong Simon
Дата:
Сообщение: 回复: BUG #17454: Using psql without ipv4 address,the inet_server_port do not return PORT.
Следующее
От: Francisco Olarte
Дата:
Сообщение: Re: BUG #17454: Using psql without ipv4 address,the inet_server_port do not return PORT.