Re: identifying local connections

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: postgresql Forums <pgsql-general(at)postgresql(dot)org>
Subject: Re: identifying local connections
Date: 2010-11-15 16:37:31
Message-ID: 170606C0-22D4-43BE-9DCB-2E4ABA5B7D46@elevated-dev.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Nov 15, 2010, at 9:24 AM, Tom Lane wrote:

> In that case see lsof --- you can match up the ends of the connection
> using the hex value in the "device" column.
>
> regards, tom lane
>

Yes, that works. Match "Address" from netstat to "DEVICE" in lsof.

Thanks.

--
Scott Ribe
scott_ribe(at)elevated-dev(dot)com
http://www.elevated-dev.com/
(303) 722-0567 voice

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Ribe 2010-11-15 16:40:52 Re: identifying local connections
Previous Message Jerry Richards 2010-11-15 16:35:13 Trouble Accessing Schema-Qualified Table