Re: Connection log entries - random port number recorded

mike g wrote:
> Hello,
>
> I have postgres set to log all connections.  I run it on port 5432.  I
> have noticed in the postgres logs that the port being used to connect to
> the database is logged but never equal to 5432.  The ip address recorded
> is correct but the port number recorded is always a different number
> each time.

This is entirely normal. The database listens on port 5432, but the
client will connect *from* a randomly chosen port (it's not actually
random, but it is meaningless).

You can't have two connections with the same endpoints, i.e. if you open
up one connection and it goes:
   client:12345 => server:5432
then the next outbound connection will have to use a different port e.g.
   client:12346 => server:5432

On linux you can use "lsof -i" to see all current connections, I used to
  use something similar on Windows, but can't remember what it was.

HTH
--
   Richard Huxton
   Archonet Ltd