Frank Broniewski <brfr@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