pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
8.1 display in top
2+ messages / 2 participants
[nested] [flat]

* 8.1 display in top
@ 2006-03-23 16:18 Chris Hoover <revoohc@gmail.com>
  2006-03-23 16:36 ` Re: 8.1 display in top Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 2+ messages in thread

From: Chris Hoover @ 2006-03-23 16:18 UTC (permalink / raw)
  To: pgsql-admin

Quick question.

I am looking at top on my RH AS 4.0 server that runs my PG 8.1 database.
When I see a db process in top, it says postgres: user db ipaddr(number)
condition (i.e. postgres: user1 db1 10.4.10.10(23456) SELECT).

What does the number after the ip address represent (the (23456)]?

Thanks,

Chris

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: 8.1 display in top
  2006-03-23 16:18 8.1 display in top Chris Hoover <revoohc@gmail.com>
@ 2006-03-23 16:36 ` Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2006-03-23 16:36 UTC (permalink / raw)
  To: Chris Hoover <revoohc@gmail.com>; +Cc: pgsql-admin

"Chris Hoover" <revoohc@gmail.com> writes:
> What does the number after the ip address represent (the (23456)]?

It's the TCP port number on the client end.  Some people requested that
so they could tell apart multiple connections from the same client
machine (you can use lsof or equivalent on the client side to identify
the particular process that has a given port open).

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2006-03-23 16:36 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-03-23 16:18 8.1 display in top Chris Hoover <revoohc@gmail.com>
2006-03-23 16:36 ` Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox