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.=C3=A0r.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

--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Frank Broniewski [ Fr, 07 August 2009 11:48 ] [ ID #2011355 ]

Re: Used ports

Frank Broniewski <brfr [at] metrico.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

--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Kevin Grittner [ Fr, 07 August 2009 16:48 ] [ ID #2011356 ]
Datenbanken » gmane.comp.db.postgresql.admin » Used ports

Vorheriges Thema: Autovacuum: found orphan tenp table
Nächstes Thema: CSV Utility