Re: identifying local connections

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
Cc: postgresql Forums <pgsql-general(at)postgresql(dot)org>
Subject: Re: identifying local connections
Date: 2010-11-15 16:24:18
Message-ID: 15409.1289838258@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Scott Ribe <scott_ribe(at)elevated-dev(dot)com> writes:
> On Nov 15, 2010, at 8:50 AM, Tom Lane wrote:
>> netstat will probably work for this, depending on what platform you're on.

> OS X. I can see the connections, but I don't see an option to display PIDs.

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jerry Richards 2010-11-15 16:35:13 Trouble Accessing Schema-Qualified Table
Previous Message Steve Clark 2010-11-15 16:05:51 Re: identifying local connections