Re: PostgreSQL server listen on other port than 5432 - Mailing list 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