Re: PostgreSQL server listen on other port than 5432

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