pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feed8.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>
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:36 Tom Lane <tgl@sss.pgh.pa.us>
parent: Chris Hoover <revoohc@gmail.com>
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