Lists: | pgsql-admin |
---|
From: | Frank Broniewski <brfr(at)metrico(dot)lu> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Used ports |
Date: | 2009-08-07 09:48:47 |
Message-ID: | 200908071148.48529.brfr@metrico.lu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-admin |
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
From: | "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> |
---|---|
To: | "Frank Broniewski" <brfr(at)metrico(dot)lu>,<pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Used ports |
Date: | 2009-08-07 14:48:37 |
Message-ID: | 4A7BF8750200002500029655@gw.wicourts.gov |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-admin |
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