Used ports

Hello all,

when I do "netstat -an" I get the following lines:

tcp 0 0 127.0.0.1:5432 0.0.0.0:* LISTEN
tcp 0 0 127.0.0.1:5432 127.0.0.1:57647
ESTABLISHED
tcp 0 0 127.0.0.1:41572 127.0.0.1:5432
ESTABLISHED
tcp 0 0 127.0.0.1:5432 127.0.0.1:41572
ESTABLISHED
tcp 0 0 127.0.0.1:57647 127.0.0.1:5432
ESTABLISHED

Is this normal?

Many thanks for any hints

Frank
--
Frank Broniewski

Metrico s.àr.l. ( http://www.metrico.lu )
36, rue des Romains
L-5433 Niederdonven
Luxembourg

Fon: +352 26 74 94 28
Fax: +352 26 74 94 99

Frank Broniewski <brfr(at)metrico(dot)lu> wrote:

> when I do "netstat -an" I get the following lines:
>
> tcp 0 0 127.0.0.1:5432 0.0.0.0:*
> LISTEN
> tcp 0 0 127.0.0.1:5432 127.0.0.1:57647
> ESTABLISHED
> tcp 0 0 127.0.0.1:41572 127.0.0.1:5432
> ESTABLISHED
> tcp 0 0 127.0.0.1:5432 127.0.0.1:41572
> ESTABLISHED
> tcp 0 0 127.0.0.1:57647 127.0.0.1:5432
> ESTABLISHED
>
> Is this normal?

Seems pretty normal if you don't want to allow connections from other
machines and you have two connections from processes on the same
machine.

What this shows is that PostgreSQL is accepting connections only on
the local loopback IP (unless you left something else for this port
number out). It shows two connections to PostgreSQL from processes on
that machine. Each connection shows twice -- once to show the user
end of the connection, and once to show the server end of the
connection. (If you were accepting connections from a other machines,
you would only see the server side of those connections to
PostgreSQL.)

-Kevin