Re: PostgreSQL server listen on other port than 5432

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: PostgreSQL server listen on other port than 5432
Дата
Msg-id 4A715952.6030801@archonet.com
обсуждение исходный текст
Ответ на PostgreSQL server listen on other port than 5432  (Dotan Barak <dotanba@gmail.com>)
Ответы Re: PostgreSQL server listen on other port than 5432
Список pgsql-general
Dotan Barak wrote:
> Hi.
>
> I'm using CentOS 5.3 and PostgreSQL version 8.1.11.
>
> I opened the posgres SQL to accept incoming connections:
>
> <snip start from postgresql.conf>
> listen_addresses = '*'
>                                        # comma-separated list of addresses;
>                                        # defaults to 'localhost', '*' = all
> port = 5432
> max_connections = 100
> <snip end>
>
> It seems that the posgres SQL sometimes listen on other ports than 5432:
> # lsof -i -n -P  | grep postg
> postmaste 18415 postgres    3u  IPv4  99670       TCP *:17583 (LISTEN)
> postmaste 18415 postgres    4u  IPv6 102029       TCP *:5432 (LISTEN)
> postmaste 18415 postgres    5u  IPv4 102030       TCP *:5432 (LISTEN)

Never seen this before. One thing that does leap out though is that
you've got IPv4 and IPv6 sockets active at the same time. Does grepping
for "17583" show anything useful?

--
   Richard Huxton
   Archonet Ltd

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

Предыдущее
От: Dotan Barak
Дата:
Сообщение: PostgreSQL server listen on other port than 5432
Следующее
От: Thomas Kellerer
Дата:
Сообщение: Re: pg_stat_activity undocumented?